Custom report how to breakdown report for one terminal

So I have been creating a custom report with SQL code and I want to choose one terminal with T.Terminal. How would I do this?

So what I need is the report to have something like this:

{REPORT ORDER DETAILS:T.Terminal then add the terminal name so it only works out the order details for that one terminal.

Try (TE=<terminal name>) expression.

Hi Erme,

I am using your create report for “Item Sales Report” and I just want to add a bit of code so it only shows the results for one till. I have tried that way and it doesn’t work. Is there any other way of getting this to work?

Here is what I am modifying at the moment

[Nelsons Bar Front :5, 3, 3, 1, 1]

{REPORT ORDER DETAILS:(TE=),O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}

Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}

<terminal name> means your terminal name so it should be something like…

{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) && (TE=The terminal name)}
1 Like