Need TAG's Report by Department

Hi, i am new I don’t know how to make Tags report separated by department.

As i see in Work period Report

[Ticket Tags:1, 1, 1]
{REPORT TICKET TAGS}

But this is not departmental report but i need it departmental so please guide. Thanks

Hi, Customize the attached depending on what you want to achieve. In my setup, BAR2 is a department.

[BAR2:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True) and (DE=BAR2):{0}:,}

{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (DE=BAR2) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:’ '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (DE=BAR2) and O.MenuItemName="$1":2}
Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) and (DE=BAR2)}
[User Sales:1, 1]
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum.desc:(ODI=True) and (DE=BAR2)}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}

[Payments:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0 and (DE=BAR2)}

Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0 and (DE=BAR2)}

[Settled by $1:1, 1, 1]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1) and (DE=BAR2)}

Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1) and (DE=BAR2)}

[Refund Payments:2, 1, 2]
{REPORT REFUND PAYMENTS}

1 Like

1
I want this type of report but should be just for 1 department that i need. If i have 2 departments but i want this Ticket tag report for 1 department. so if you can help then please give me code for this report

Which is your code for this?

I think you want Ticket Tag report separated by department. I am sharing a code to design report in which you change your Department from " (DE=Delivery) ". and TT.Rider is ticket tag here you can change your Ticket Tag.

[Rider Sale Delivery:4, 2]
>Rider|Sales
{REPORT ORDER DETAILS:TT.Rider,O.ExactTotal.sum:(DE=Delivery):(ODI=True)}
>>Total|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum:(DE=Delivery)}'),'0.;(0.); ')]
2 Likes