I was trying to re-write the SOLD ITEMS report, with has three parts:
SOLD ITEMS
GIFTED ITEMS
VOID ITEMS
I was trying to change the SQL sentence to a REPORT TAG sentence and I found 3 obstacles:
I could not find the way to sum Quantity in a NON Pivot table (this report is too simple to be a pivot report)
It cannot be sorted by Quantity (if its not a pivot table…
I cannot filter by CalculatePrice and DecreaseInventory
The Report Tags I tried are:
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity:(O.CalculatePrice=0)} This throws an error
{REPORT ORDER COUNT:O.MenuItemName,O.Quantity:(O.CalculatePrice=0)} This works but does not sort by Quantity, and as soon as I put the expression part starts throwing an error.
This will sum GRAND TOTAL, I need a Quantity sum for each MenuItemName… does not seem to be one… unless using pivot tables… and ther is the order issue…
I think that for this case, its simplier to have a SQL sentence…
another question: Where can we read the GIFT and VOID reasons?