@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}
[EOD SERVER SALES:1,1,1,1,1,1,1,1,1]
Name|Total|Chk Amt|Discounts|Total|Tax|Tips|Paid Ins|Receipts
{REPORT PAYMENT DETAILS:P.User,P.Amount.sum,T.TotalAmount.sum,discounts no data,[T.TotalAmount.sum]-[T.Tax.sum],T.Tax.sum,-[P.Amount.sum]+[T.TotalAmount.sum]:(PU=$1) }
I think i need a sql command where p.user and ordertag user are the same to get total order tag discounts. Also need a way to get total tips by user