I want to a department report

[Tzvictor]

[YILDIZHANPOS]

[Product Sales from Each Department:2,2, 1, 1]
>Item Group|Item|Qty|Total
@{REPORT ORDER DETAILS:O.Department.distinct:(ODI=True)}
>>Department : 	$1
{REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (DE=$1)}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (DE=$1)}

[Tzvictor]

Thank you
Let me try it

[YILDIZHANPOS]

Pivot Product Sales from Each Department.zip (1.5 KB)

[YILDIZHANPOS]

[Tzvictor]

Thank you
Worked perfectly

[Tzvictor]

Do you have a format for individual item sales
But with the total of each user

[YILDIZHANPOS]

[Tzvictor]

The SQL format please
Thank you

[Jesse]

The SQL format would be a massive undertaking when you can get the result with Report Tags. Why do you need a sql version? Report tags were designed so you do not have to use SQL it simplifies report building.