Waiters sales report

V5 Question
21

coud you make this post public? i cant see it

22

I was playing with this but i can not understand how it works
i need to see the REPORT ORDER DETAILS for each Ticket Tag ā€œCamarer@ā€ could somebody help me?

image
image1920Ɨ1080 163 KB

23

You see the @ report? This generates a list and then the report is looped for each value of the list using $1
So the item sales report you show has report for menu item names on the @ and then the actual returned report contains menuitem=$1 in the constraints part.

24

ok, could you give me an example?

25

This is an old report that had a bug if special chars in names but an example of dual @ expressions;

@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
[$1 Sales:8, 2, 2]
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1)}
{REPORT ORDER DETAILS:'        '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1) and O.PortionName!="Normal"}
>>Total $1|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and (MG=$1)}

[Item Sales:8, 2, 2, 2]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent,O.Quantity.Sum,O.ExactTotal.Sum}
>>Total Sales||{REPORT ORDER DETAILS:O.ExactTotal.Sum}

See the two @ declaration reports and the use of $1 and $2

26

ok, thanks for your time but i have no idea how to use it in my report

27

@juancho23 Is this in a case where waiters are Tagged to sale?

28

yes, its a ticket tag when the ticket is open to select a waiter

29

If your using ticket tag and reporting whole ticket based on user (via ticket tag on ticket created) why not just report ticket user?
Am confused what your trying to do.

30

its because i have no idea how to use it, the last reports that i finaly make it works took me a hole week, reading and using the tips that the people in the forum gave me, but when you talk about $1or @ is imposible for my to use it, i dont know here put it not even what are they do :slight_smile:

31

@ declairs a list

@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
This gives a list of product group codes

Then $ causes a loop from the list values
$1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (MG=$1)}
So this reports items for each groupcode under a header for each group.

1 Like
32

Hey I created a Report based on Ticket Tagsā€¦ So my waiters donā€™t login to the system but instead they are just tagged to a Ticket. Not sure if itā€™s something you meant
Note: You will have to change TT.Waiters to whatever you call your Tag

[Waitress Tag Item Sales:2, 1, 1, 1]
@{REPORT ORDER DETAILS:TT.Waiters,O.Quantity.Sum::{0}:,}
>>$1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum,O.ExactTotal.Percent.desc,O.ExactTotal.Sum: 
(TT.Waiters=$1)}
>Total:||{REPORT ORDER DETAILS:O.ExactTotal.Sum:(TT.Waiters=$1)}
1 Like