Report

Hey guys,

When I try to run the select statement below straight in the MS-SQL it runs Ok, but when I try to use it in the Report (from SC+) some columns doesn't shows any data.

   
     SELECT H.QUEUENAME AS Grupo, F.FIRST_NAME AS Representante, A.WORKORDERID AS Chamado, A.WORKORDERID AS Chamado2,D.NAME AS Conta, A.TITLE AS Assunto, A.DESCRIPTION AS Descrição, B.FIRST_NAME AS Contato, SUBSTRING((CONVERT(varchar(30), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000'), 112)),7,2) AS Dia, SUBSTRING((CONVERT(varchar(30), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000'), 112)),5,2) AS Mes, SUBSTRING((CONVERT(varchar(30), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000'), 112)),1,4) AS Ano, (CAST((CONVERT(VARCHAR(5),(((SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 112),7,2)-1)*24*60*60)+(SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 108),1,2) * 3600) + (SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 108),4,2) * 60) + SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 108),7,2))/60)) AS NUMERIC))/1400 AS MinTotal, (CAST((CONVERT(VARCHAR(5),(((SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 112),7,2)-1)*24*60*60)+(SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 108),1,2) * 3600) + (SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 108),4,2) * 60) + SUBSTRING(CONVERT(VARCHAR(8), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000')-DATEADD(SECOND, A.CREATEDTIME/1000, '01/01/1970 00:00:00.000'), 108),7,2))/60)) AS NUMERIC))/1400 AS MinTotal2, (CAST((A.TIMESPENTONREQ/1000/60) AS NUMERIC))/1400 AS MinRes, (CAST((A.TIMESPENTONREQ/1000/60) AS NUMERIC))/1400 AS MinRes2, (CAST(SUM(J.MM2COMPLETEREQUEST/60000) AS NUMERIC))/1440 AS MinReal, (CAST(SUM(J.MM2COMPLETEREQUEST/60000) AS NUMERIC))/1440 AS MinReal2 FROM WorkOrder A LEFT JOIN AaaUser B ON A.REQUESTERID=B.USER_ID LEFT JOIN Customer_Requester C ON B.USER_ID=C.REQUESTER_ID LEFT JOIN AaaOrganization D ON C.CUSTOMER_ID=D.ORG_ID LEFT JOIN WorkOrderStates E ON A.WORKORDERID=E.WORKORDERID LEFT JOIN AaaUser F ON E.OWNERID=F.USER_ID LEFT JOIN WorkOrder_Queue G ON A.WORKORDERID=G.WORKORDERID LEFT JOIN QueueDefinition H ON G.QUEUEID=H.QUEUEID LEFT JOIN RequestResolution I ON A.WORKORDERID=I.REQUESTID LEFT JOIN RequestCharges J ON A.WORKORDERID=J.WORKORDERID LEFT JOIN RCTechnicianIDs K ON J.REQUESTCHARGEID=K.REQUESTCHARGEID LEFT JOIN AaaUser L ON K.TECHNICIANID=L.USER_ID LEFT JOIN StatusDefinition M ON E.STATUSID=M.STATUSID LEFT JOIN RequestResolver N ON A.WORKORDERID=N.REQUESTID WHERE K.TECHNICIANID=N.TECHNICIANID AND A.ISPARENT=1 AND M.STATUSNAME = 'Closed' AND (CONVERT(varchar(30), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000'), 112)) > '20091201' AND (CONVERT(varchar(30), DATEADD(SECOND, A.COMPLETEDTIME/1000, '01/01/1970 00:00:00.000'), 112)) < '20091231' GROUP BY TIMESPENTONREQ, H.QUEUENAME, F.FIRST_NAME, A.WORKORDERID, D.NAME, A.TITLE, A.DESCRIPTION, B.FIRST_NAME, A.COMPLETEDTIME, A.CREATEDTIME

MS-SQL Result: