Detailed Server Report-->All server transactions for current Work Period and Current logged user

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.

http://sambapos.com/wiki/doku.php?id=custom_reporting_tags

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.