Help with an EXPRESSION in REPORTS

V5 Question
1

I am trying to filter by Customer.Name in thsi report, but I am not doing it right…

@{REPORT ENTITY DETAILS:E.Name:(ET=Customers)}
[Clientes:3, 2]
>Cliente $1|Total
{REPORT ORDER DETAILS:O.MenuItemName.asc,O.Quantity.Sum:(ODI=True) && (TEN.Name=$1)}

why? Then (TEN.Name=$1) is for sure wrong, but I cannot find wich is the correct sintax…

Thanks!!!

I tried another approach:

@{REPORT TICKET DETAILS:T.TicketNumber,EN.Customer}
[Pedidos Por Cliente:3,2, 2]
>Cliente $2: Pedido|Tamanho|Cantidad
{REPORT ORDER DETAILS:O.MenuItemName.asc,O.PortionName,O.Quantity.Sum:(ODI=True) AND T.TicketNumber=$1}

but still having problems with T.TicketNumber=$1

Thanks!!!

G.

PS Expressions and I do not get along… LOL

2

Did you tried TEN.Customers ?

3

Hi Emre, how are things!!! long time no read!!! LOL

yes I tried that… allways a blank report… what am I doing wrong here:

@{REPORT TICKET DETAILS:EN.Customer}
[Pedidos Por Cliente:3,2, 2]
>Cliente $1: Pedido|Tamanho|Cantidad
{REPORT ORDER DETAILS:O.MenuItemName.asc,O.PortionName,O.Quantity.Sum:(ODI=True) AND (TEN.Customer=$1)}

Thanks!!!

G.

4

Guessing from mind you may need a configure a splitter here as parameter lists are csv’s. Try

@{REPORT TICKET DETAILS:EN.Customer::,}
5

Thanksm that did the trick!!!

G