Help Needed: Paginated Report Export Collated by Department in QuickSight

Q&A
, , ,
1

Hi Quick Suite Community,

I’m currently building a paginated report in Quick Sight and need help with exporting it in a grouped, collated format.

Here’s my use case:

  • I’ve set up repeating sections based on our Department field.

  • Each department (e.g., Finance, Legal) should have three distinct pages showing the views and insights for that department.

  • The goal is to export the report so that each department appears as a grouped three-page section, like this:

Finance
• Page 1
• Page 2
• Page 3

Legal
• Page 1
• Page 2
• Page 3

...and so on.

I’ve tried two approaches:

  1. Three separate sheets (one per page), each with its own repeating section. But I can only export each sheet individually, and so the export results in 10 pages of Sheet 1, then 10 pages of Sheet 2, etc.—not collated by Department.

  2. One sheet with three repeating sections, each representing a page. But the export still gives me 10 pages of Section 1, then 10 pages of Section 2, etc.—again, not grouped by Department.

I’ve searched documentation and asked Copilot but haven’t found a way to produce a collated export that maintains the grouped structure by department.

Can anyone point me to a resource or explain how to achieve this? Is there a best practice for structuring paginated reports to support collated exports like this?

Thanks

2

If I understand correctly, you are looking to next page breaks or a multi-section template into a repeating section.

If that is correct, we there is not currently a way to achieve this out come with Paginated reports beyond the two approaches you have already attempted.

At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request. We are not able to comment on upcoming features, because our roadmap is subject to change.

Please respond if you feel I have misunderstood the problem.

3

Thanks Josh, you’ve nailed it. This is exactly what I am trying to create. We have a client group that lives and dies by PowerPoint. No one loved our former visualization platform (now owned by SalesForce) but they liked the ability to export dashboards to PowerPoint so you might add this to the list too. It annoys me to no end that they can’t just share the actual dashboard during a meeting, but what are you going to do?

4

Ok good to hear! I know both of these things (nested sections and powerpoint export) are highly requested and I have added your feedback to the Product Feature Requests associated to them.