Sold Items Report V2.0

Version 4 V4 Custom Reports
1

I made some changes and enhancements to meet my requirements… hopes this is usefull for others too!!!

Report:

[Totales por Grupo:2, 1]
>Grupo|Total
@@Totalesxgrupo

[Items Vendidos:1,2, 1]
>Grupo|Item|Total
@@Itemsxgrupo

SQL:

@@Itemsxgrupo
SELECT [MenuItems].[GroupCode],[MenuItemName]+(CASE WHEN [PortionName] = 'Normal' THEN '' ELSE ' ' + [PortionName] END),CONVERT(INT,SUM([Quantity])) as Cantidad

FROM [Orders]

LEFT OUTER JOIN [MenuItems] on [Orders].[MenuItemId] = [MenuItems].[Id]

WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND DecreaseInventory = 1 AND CalculatePrice <> 0

GROUP BY [MenuItems].[GroupCode],[MenuItemName]+(CASE WHEN [PortionName] = 'Normal' THEN '' ELSE ' ' + [PortionName] END)

ORDER BY Cantidad DESC

and

@@Totalesxgrupo
SELECT [MenuItems].[GroupCode], CONVERT(INT,SUM([Quantity])) as Cantidad

FROM [Orders]

LEFT OUTER JOIN [MenuItems] on [Orders].[MenuItemId] = [MenuItems].[Id]

WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND DecreaseInventory = 1 AND CalculatePrice <> 0

GROUP BY [MenuItems].[GroupCode]

ORDER BY Cantidad DESC
2 Likes