i put this to a new script
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
FROM Tickets AS T
LEFT OUTER JOIN TicketEntities AS TE ON TE.Ticket_Id = T.Id
WHERE DATE > ‘{Start}’ AND DATE < ‘{End}’
GROUP BY T.TicketNumber
ORDER BY DATE,TIME
and this to new report
[Tickets:1,2,2,2,2, 2]
Ticket No|Date|Time|Customer|Table|Amount
@@TicketList
and get this
