Expression problem with a report

V5 Question
1

I am trying to filter the Deliverers list just to the active deliveres ((EC.Deliverers.Mostrar=Yes)) so I can change that during week days… but I cannot figure out how to filter it…

@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Deliverers) AND (EC.Deliverers.Mostrar=Yes)::{0}:,}


[Taxas $1:1,3, 2, 2, 2]
{REPORT TICKET DETAILS:T.TicketNumber,EN.Bairro,EC.Customers.Distance,EC.Bairros.Taxa,EC.Bairros.TaxaExtra:(TEN.Deliverer=$1)}
SubTotal|||R$ {REPORT TICKET DETAILS:EC.Bairros.Taxa.Sum:(TEN.Deliverer=$1)}|R$ {REPORT TICKET DETAILS:EC.Bairros.TaxaExtra.Sum:(TEN.Deliverer=$1)}
>Total $1||||R$ [=F(TN('{REPORT TICKET DETAILS:EC.Bairros.Taxa.Sum:(TEN.Deliverer=$1)}')+TN('{REPORT TICKET DETAILS:EC.Bairros.TaxaExtra.Sum:(TEN.Deliverer=$1)}'),'0.00')]

Pasted image1366×768 38.1 KB

Thanks and for sure this has been explained but could not find it…

G.

2

So your using the wrong logic then. If your wanting to use comparative logic you could try

@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Deliverers) && Entity.GetCustomData("Mostrar").contains("Yes")::{0}:,}
3

shoot… I should have known… da@#$@%#$%@#$ed

Thanks!!!

G.

4

Let me know if that works I have not tried it. It seems to me like it should.

5

it did not work… LOL…

6

Hmm ok let me try some things.

7

its getting data from wich entity, should we define it anywhere?

G.

8

Well the report you showed isnt requiring a specific entity… it was listing them… is that not what you wanted? You already defined the Entity Type.

PS You sure its not working? Do you have any Entities with Yes for that data right now?

9

It works fine for me…

10

SORRY FOR THAT!!!

its working great…

G.

:blush: