Forum Discussion
Helper IPaginated Report / Execute Multiple Reports at Once
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 |
2 Replies
- lbendlin
Super User
Do you still want separate pages per city?
lliu08it 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.
