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