No worries. I would think a combined report showing the stat’s for each user would be good.
Maybe you should look here and decide how you want to build your report.
Thanks. I didnt know that tutorial was there. Will check it out.
You can convert @na1978’s first sample to a user based report like …
[Server Sales Details:3,2,3,2,2]
Date:|{DATE}
@Administrator,Manager,Waiter
>Server:|$1
C.C: |||${REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU=$1)}
Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU=$1)}
G.C:|||${REPORT PAYMENT TOTAL:(PT=Gift Card) AND (TU=$1)}
TOTAL:|||${REPORT PAYMENT TOTAL:(TU=$1)}
Subtract|Gift Card:|
Subtract|C.C Total w/Tips:|
Over|Short
You can change @Administrator,Manager,Waiter
line to list users you want to include in report.
If you want to have a user list generated from user accounts you can see a sample here http://sambapos.com/wiki/doku.php?id=creating_custom_reports_with_sql#using_parameter_sources
2 Likes
Thank you Emre! I will definitely give this a try.