pauln
1
Hello @emre
Why does this REPORT Tag not support P.Type.Contains()
- it is a very useful additive when you need to filter Records:
{REPORT PAYMENT DETAILS:P.Type,P.Amount:(DE=$1) && P.Type.Contains("Cash")}
Below is an example which greatly assisted in the reporting down to Cash Till & Department basis:
{REPORT CALCULATION DETAILS:C.Name,T.Terminal,C.CalculationAmount.Sum:(TE={SETTING:CURRENTTERMINAL}) && C.CalculationAmount <> 0 && C.Name.Contains("Cash Out"):{0}||${2}:}
Help please…
emre
2
I didn’t tested but you can try Payment.Name.Contains("Cash")
1 Like
pauln
3
ON my way home 7.30pm - should have it tested in another 2 hours - thanks.
pauln
4
Umm @emre - not sure if this is working:
{REPORT PAYMENT DETAILS:P.Name,T.TicketNumber,P.Amount:(DE=$1) && Payment.Name.Contains("Cash")}
Returns:
did I assume wrong that P.Name is not the same as Payment.Name?
OMG - oops!!!
Tripped out by the Name arrhhh!
THANKS - Emre I can confirm this works:
{REPORT PAYMENT DETAILS:P.Amount.sum:(DE=$1) && Payment.Name.Contains("Cash ")}
I can now run this same report off for Department OR SPLIT by Department Till
1 Like