Skip to Content
0
Former Member
May 28, 2015 at 06:00 PM

Ayuda reporte

18 Views

Jovenes tengo un query que desde el sql server si mi funciona perfectamente pero cuando lo quiero pasar al query manager y utilizo [%0] y el [%1] me da error el sistemas y no se que sea adjutno una imagen del error que da y les dejo el query que quiero ejecutar.

Query

SELECT DISTINCT 
'orden_de_venta' as tipo,  t2.cardcode as codigo, t2.cardname as Cliente, t2.DocNum AS Orden_de_venta, t2.doctotal as Total_Orden, 
                 t2.DocDate [Fecha_Creacion_Orden], t2.DocTime[Hora_Creacion_Orden],  sum(T8.Weight1)[Peso_Orde_Venta],

'Entregas' as Tipo, t4.DocNum AS No_Entrega, t4.doctotal as totalentrega, t4.DocDate [Fecha_Creacion_Entrega], t4.doctime[Hora_Creacion_Entrega],
                 sum(T3.Weight1) [Peso_Entregas], 

'factura_normal' as tipo,  /*t5.cardcode as codigo, t5.cardname as Cliente,*/ t5.DocNum AS No_Fact, 
                t5.doctotal as Total_fact, t5.DocDate [Fecha_Creacion_Factura], t5.DocTime[Hora_Creacio_ Factura], 
                sum(t6.Weight1)[Peso_Facturas_Normal],
                
'Factura Reserva' as Tipo,/* 
                Case When t5.ObjType = '13' Then T5.CardCode Else '' End [Codigo],
                Case When t5.ObjType = '13' Then T5.CardName Else '' End [Cliente],*/
                Case When t5.ObjType = '13' Then T5.DocDate Else '' End [Fecha_Creacion_Factura_Reserva],
                Case When t5.ObjType = '13' Then t5.DocTime Else '' End [Hora_Creacion_Factura_Reserva],
                Case When t5.ObjType = '13' Then T5.DocNum Else '' End [No._Factura_Reserva],
                Case When t5.ObjType = '13' Then T5.DocTotal Else '' End [Total_Factura_Reserva],
                Case When t5.ObjType = '13' Then sum(T8.Weight1) Else '' End [Peso_Factura_Reserva],    

'Notas de Credito' as Tipo, T0.DocDate [Fecha Creacion_Nota_Credito], T0.DocTime[Hora_Creacion_Nota_Credito],
                t0.DocNum AS Nota_credito, T0.DocTotal[Total_Notas_Credito], sum(T1.Weight1)[LB_Notas_Credito]    
                
                FROM ORIN t0 INNER JOIN
                      RIN1 t1 ON t0.DocEntry = t1.DocEntry RIGHT OUTER JOIN
                      ORDR t2 LEFT OUTER JOIN
                      DLN1 t3 INNER JOIN
                      ODLN t4 ON t3.DocEntry = t4.DocEntry INNER JOIN
                      OINV t5 INNER JOIN
                      INV1 t6 ON t5.DocEntry = t6.DocEntry ON t4.DocEntry = t6.BaseEntry ON 
                                 t2.DocEntry = t3.BaseEntry ON t1.BaseEntry = t5.DocNum LEFT OUTER JOIN
                      [DBO].[_SBOV_ORDEN_DE_VENTA] T7 ON T0.DocEntry = T7.[# Doc] INNER JOIN 
                      RDR1 T8 ON t2.DocEntry = T8.DocEntry

where t5.isins='N' and t2.DocDate>= [%0] and t2.DocDate<= [%1]
Group By t2.cardcode, t2.cardname,t2.DocNum, t2.doctotal, t2.DocDate , t4.DocNum, t4.doctotal, t4.DocDate, t5.DocNum, 
         t5.doctotal, t5.DocDate, t0.DocNum, T0.DocDate, T0.DocTotal, t2.cardcode, t2.cardname, t2.DocNum, 
         t2.doctotal, t2.DocDate, t5.ObjType, T5.CardCode, T5.CardName, T5.DocNum,  T5.DocDate,
         t5.DocTotal, t2.DocTime, t4.doctime, t5.DocTime, T0.DocTime

Espero me puedas ayudar ya probe colocar comillas simples en los atributos pero no funciona tampoco '[%0]' espero me puedas ayudar e indicarme en donde esta mi error

Por su tiempo y ayuda muy agradecido

Saludos cordiales

Attachments

Error.jpg (24.1 kB)