Reporte de Actividades

Cordial Saludo:

Envió informe de actividades CRM

SELECT T0.[CntctDate], T0.[ClgCode],T3.[CardName], T0.[Recontact], T4.[Name] as Tipo, T5.[Name] as Asunto, T1.[U_NAME] as ‘Asignado a:’,T2.[U_NAME] as ‘Asigando Por:’, Estado= CASE T0.[Closed] WHEN ‘Y’ THEN ‘CERRADO’ WHEN ‘N’ THEN ‘ABIERTO’ ELSE ‘N/A’ END FROM OCLG T0  INNER JOIN OUSR T1 ON T0.AttendUser = T1.USERID INNER JOIN OUSR T2 ON T0.AssignedBy = T2.USERID

INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode INNER JOIN OCLT T4 ON T0.CntctType = T4.Code INNER JOIN OCLS T5 ON T0.CntctSbjct = T5.Code WHERE T0.[CntctDate] Between [%0] and  [%1] ORDER BY T0.[CntctDate] asc

A espera de sus comentarios.