Hello,
Could someone help me format this report to give me of a list of Customers and the Items sold to them.
I have struggled with it but the result am getting is note entirely what I desire.
[Customer Sales Details:2,3,1, 1]
>CUSTOMER|ITEM|QTY|AMOUNT
{REPORT ORDER DETAILS:EN.Customer,O.MenuItemName,O.Quantity,O.ExactTotal:(TY=INVOICE)}
I desire to get something like this…
But this is what I get…
Below is my set up
Hi Mambo.
[Customer Sales Details:3, 1, 2]
>ITEM|QTY|AMOUNT
@{REPORT ORDER DETAILS:EN.Customer,O.Quantity.Sum::{0}:,}
>>$1
{REPORT ORDER DETAILS:,,O.MenuItemName.asc,O.Quantity.Sum,O.ExactTotal.Sum:(TEN.Customer=$1) and (ODI=True) and (TY=INVOICE)}
>Total:||{REPORT ORDER DETAILS:O.TotalPrice.Sum:(TEN.Customer=$1) and (ODI=True) and (TY=INVOICE)}
Thank you so so much… I have seen where I was going wrong and what I was missing. Thank you for your help. Be blessed.