Need some hep with a Report

V5 Question
21

Sorry on phone canr type wwll

22

Well… drop the phone… and write… LOL!!!

1 Like
23

I cant. Im walking to my restaurant.

24

sorry, it was a bad joke…

G.

1 Like
25

Least i didnt say im drivibg

3 Likes
26

Well… waited until now…LOL!!! and no comment… my dear kendash… LOL!!!

did not understand you in your $1 and @1 post

Thanks!!!

G.

27

Try something like

@blah
[$1:1,1,1]
Blah report blah blah.
28

Does SQL or Samba recognize blah statements? I am really out with those new script languages… LOL!!!

Thanks… will try it

G.

29

I was hoping your brain module parser would pick that up.

1 Like
30

nop… to much caipirinhas… by the way anyone has seen the series BRAINDEAD?

well tried that

Pasted image1366×768 54.4 KB

seems I am not parsing it correctly…

and if I change it to:

Pasted image1366×768 43.9 KB

G.

31

I dont seem to get the grip to this… tonight will get drunk again with caipirinha to forget all this…

LOL!!!

Well after some caipirinhas and serious toughts… I got it working…

Pasted image1366×768 44.1 KB

The only think I cannot find the way to show is the header, as soon as I use something like >blah|blah|blah| the report shows as blank…

Thanks

G.

32

Well, thanks to all that help out, would not be having this report otherwise!!!

now, just one question…

this:

@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Deliverers)::{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')]

is working out great, but would like to report only the ones that actually have records to inform:

would taht be possible?

Thanks!!!

G.

33

You are a hard man to please 'dog!

You parameter setup above queries your Entity Table right? So it gathers ALL deliverers. So what you need to do gather a “short list” from Tickets of Deliverers used and then use that as your parameter list.

You need to modify this sample but below I have extracted only Departments used on Tickets:

@{REPORT TICKET DETAILS:T.DepartmentId,T.TotalAmount.sum::{0}:,}

Hopefully you can design something that references Entity Deliverer.
Must run to see my dear old mum! GLCK.

1 Like