Regarding Ticket Type List in Report

[alvin]

Hi @emre,

Could you help me to solve the below scenario ?
I have created a report for Ticket Type Total, here is the below code and out put

[Ticket Details:2, 1, 2]
>>Ticket Counts
@!{TICKET TYPE LIST}
$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET TOTAL:(TY=$1)}
>>Total|{REPORT TICKET COUNT}|{REPORT TICKET TOTAL}

And in this out put, I have different types of tickets and transactions only in one ticket .
My question is how to show only the ticket types which has the transactions.

[Bob_be]

@alvin

@!{TICKET TYPE LIST}

When I build a grouping list, I like to view the grouping list first to make sure it’s the list I want (by not putting a @ sign in front of the report). I will try different dates to also make sure. If you look at the report tag, it will show all the ticket types. So we need to try a different approach. Since you want something related to tickets, so lets take a look at one of the ticket reports. If you under REPORT TICKET DETAILS there is a field for TicketType. Try that. If that isn’t exactly what you want, you can try putting some expressions in the report to get the desired results.

Also, you don’t need the ! between the @ & {.

On a sad note, @emre passed away last year.

Emre Eren 1976 - ∞

[28] Founder and developer of SambaPOS, a successful software developer, a reliable partner, a great father, a great husband, and my best friend for 32 years; he passed away on March 3, 2019 due to a heart attack. Unfortunately his heart and body were not strong enough to carry this great genius. I’m sure his soul is in heaven. He will live forever in our hearts. Maybe you didn’t have a chance to meet him in person, but if you have had a chance to meet him in person, you’d understand that ever…

[alvin]

@Bob_be Am very sorry, I didn’t know about that sad news.

[RestoANT]

@alvin

$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET TOTAL:(TY=$1)} >>Total|{REPORT TICKET COUNT}|{REPORT TICKET TOTAL}

Plesa try this.

[Ticket Details:2, 1, 2]
>>Ticket Counts
@{REPORT TICKET DETAILS:T.TicketType::,}
$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET TOTAL:(TY=$1)}
>>Total|{REPORT TICKET COUNT}|{REPORT TICKET TOTAL}

[alvin]

Thanks a lot @RestoANT. That’s works for me.

[alvin]

Hi @RestoANT,

I tried to add the Tax in that but its not working properly here is my code.

[TICKETS:1,1, 1, 1, 1, 1]
>Ticket|Items|Sub Total|TAX|Total
@{REPORT TICKET DETAILS:T.TicketType::,}
$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET DETAILS:T.PlainSum,T.Tax,T.TotalAmount:(TY=$1)}

[RestoANT]

@alvin

T.PlainSum

What is “T.PlainSum” ?

[RestoANT]

Please try this.

[TICKETS:1,1, 1, 1, 1, 1]
>Ticket|Items|Sub Total|TAX|Total
@{REPORT TICKET DETAILS:T.TicketType::,}
$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET DETAILS:([T.TotalAmount.Sum]- 
[T.Tax.Sum]),T.Tax.Sum,T.TotalAmount.Sum:(TY=$1)}

[alvin]

Thanks @RestoANT. Its working.