Hi,
I have the data with below hierarchy:
Region > State > City
How do I paginate to show data like this:
Region 1: showing details of sale of region 1
‘CA’ state: showing details of sale of state CA
‘Los Angeles’ city: showing details of sale of the city Los Angeles
‘San Diego’ city: showing details of sale of the city San Diego
‘WA’ state: showing details of sale of state WA
‘Seattle’ city: showing details of sale of the city Seattle
Region 2: showing details of sale of region 1
‘GA’ state: showing details of sale of state GA
‘Atlanta’ city: showing details of sale of the city Atlanta
‘NY’ state: showing details of sale of state NY
‘New York’ city: showing details of sale of the city Atlanta
… and so on
The showing order is like the sub group of Crystal Report.
Currently, with section, the report will show the details of all regions and then the details of all states and then city. It’s not what I want.
Is there any way I can use to show the report in the order I need?