Unable to create a sales report using sql 2014 server script

[Posflow]

Have a look at this, might get you started

How to make Compare Report Sold, Gift, Void

You can use Pivot Table for that but you’ll need SQL to be able to bring data to the shape you need. SQL can also help us to pivot our data. I prepared a sample for you to give an idea. [image] This is full custom report. You can modify that to fit to your needs. [Report:3, 1, 1, 1] >Name|Sold|Gift|Void @{REPORT SQL DETAILS:Select distinct GroupCode as GroupCode from MenuItems:F.GroupCode::,} >>$1 {REPORT SQL DETAILS: Select GroupCode,MenuItemName,isnull(Sold,0) as Sold,isnull(Gift,0) as Gif…