I'm trying to seperate Dine In and Delivery Sales using Custom Reports

[emre]

@ab0udamd

I made a new ticket type, and changed the department ticket type, but nothing is showing in the work period report

It won’t change past reports. Create new work period, new tickets and report will appear fine.

Additionally that sample custom report displays payments collected by department. It might be a starting point.

Payments by Terminal Report

###@@PaymentsByDepartment select PT.Name, Convert(nvarchar,Cast(sum(Amount) as Money),1) as Amount from payments inner join PaymentTypes as PT on PT.Id = PaymentTypeId where DepartmentId in (select id from Departments where Name = '@1') and Date > '{Start}' and Date < '{End}' group by PT.Name ###Template [Payments by Department:1, 1] >Restaurant| @@PaymentsByDepartment:Restaurant >Delivery| @@PaymentsByDepartment:Delivery It displays report for two departments named Res…