Paginated Report / Execute Multiple Reports at Once

[lliu08]

Hi community, 

I have a task that I am wondering if it's doable on paginated report. 

So here are the records below: 

ID	Country	City	Content
1	Canada	Toronto	ABC
2	US	New York	DEF
3	Mexico	Mexico City	GHI
4	Canada	Toronto	JKL

I have a report parameter set at "Country" and "City"

The Paginated Report looks something like below table

Content

<Result of the content>

As you can see, from the records, if a user selects "Canada" then "Toronto",

the result of the paginated report will be 

Content

ABC

JKL

Is there anyway that instead of expanding the results in the same "report"/"table", the paginated report is able to loop through each item as it's own report so instead of one report with two records expanding the table rows, the result will be two seperate tables/two reports. 

Ideal Result should look like below

Content

ABC

Content

JKL

[lbendlin]

Do you still want separate pages per city?

[lliu08]

it doesn't have to be saparate pages but multiple tables per city. I think I have figured it out now, I just have to "group" them and make sure all the tables I want in a report are actually just "one" big table. 

Another possible solution that I haven't looked into was I think the "sub-report" feature might does the job I am looking for.