How to make custom delivery charge report

V5 Question
9

I don’t do Delivery, and have no DELIVERER Ticket Tag, so I have no way to test this, so you will need to figure it out yourself by trying things.

You can try using expression:

TT.<tag name>                      Ticket Tagged With

Maybe:

{REPORT CALCULATION TOTAL:(CT=Delivery Charge) and (TT.DELIVERER=Joe)}

:warning: Remember, everything is cAse-sENsitive, and must match exactly. So if your Ticket Tag Name is Deliverer instead of DELIVERER, then you need to use (TT.Deliverer=Joe). The same is true for the Calculation Type Name, ie. (CT=Delivery Cost) … or whatever.

If the above works, then you can make the report a bit more “automatic” by making an @list of Deliverers, then use that list dynamically using $1 variable, like:

[Delivery Charge by Deliverer:1, 1]
@Joe,Fred,Mark,John
>Deliverer|Charges
$1|{REPORT CALCULATION TOTAL:(CT=Delivery Charge) and (TT.DELIVERER=$1)}

That ^ produces this report:

image

To make it even more “automatic”, try this:

[Delivery Charge by Deliverer:3, 1]
@{TICKET TAG LIST:DELIVERER}
>Deliverer|Charges
$1|{REPORT CALCULATION TOTAL:(CT=Delivery Charge) and (TT.DELIVERER=$1)}
1 Like