i have modified the ticketlist user report i am not getting the required result even though i checked its working in sql server
where did i go wrong?
SQl query:
SELECT
T.TicketNumber,
MIN(CONVERT(nvarchar,T.DATE,105)) AS DATE,
MIN(CONVERT(nvarchar,T.DATE,108)) AS TIME,
COALESCE(MIN(CASE WHEN TE.EntityTypeId = 1 THEN TE.EntityName ELSE NULL END),‘-’) AS [Customer Name],
COALESCE(MIN(CASE WHEN TE.EntityTypeId = 2 THEN TE.EntityName ELSE NULL END),‘-’) AS [TABLE Name],
MIN(T.TotalAmount) AS TotalAmount,
COALESCE(min(T.LastModifiedUserName),‘-’) as [LastModifiedUserName]
FROM Tickets AS T
LEFT OUTER JOIN TicketEntities AS TE ON TE.Ticket_Id = T.Id
WHERE DATE > ‘{Start}’ AND DATE < ‘{End}’ AND T.LastModifiedUserName like ‘%waitor%’
GROUP BY T.TicketNumber
ORDER BY DATE,TIME