Topic: Report grouping

Hi all,
I have orders as follow:

ID    Ordermame       Store
1         order1            store1
2         order2            store2
3         order3            store3
4         order4            store1
5         order5            store2

and addresses:
ID      Storename         Address           State
1        Store1               Buffalo              USA
2        Store2               London              UK
3        Store3               Berlin                DE

I need to make report but to group them by store address

So it would look like:


Store1
Buffalo, USA

Order1
Order3


On next page, same info but different address;

Store2
London, UK

Order2
Order5


And on final page, same report form but different address:

Store3
Berlin, DE

Order3

Thank You

2 (edited by brian.zaballa 2020-08-19 13:55:41)

Re: Report grouping

This might help

Post's attachments

Attachment icon store.zip 493.87 kb, 40 downloads since 2020-08-19 

brian

Re: Report grouping

Hi Argonx, Hi Brian,
Perhaps something like the attached.
Derek.

Post's attachments

Attachment icon argonx.zip 338.4 kb, 54 downloads since 2020-08-19 

Re: Report grouping

Thanks guys, didn't see grouping in FastReport

Ty once again wink