topic paginated report - drilldown, drill down, drill-down functionality setup in Report Server

paginated report - drilldown, drill down, drill-down functionality setup

garythomannCoGC — Wed, 10 Dec 2025 03:54:49 GMT

Posting for future reference. Found the information hard to find and search hits intermixed with drill-through functionality.
Hence the title of this post "drilldown, drill down, drill-down" to help folks with a direct search hit.
In short found this youtube video the most usefull, drilldown report in paginated report builder

The microsoft official pages referenced throughout the forums points to:

Drilldown action in a paginated report (Power BI Report Builder) which points to

Tables in paginated reports (Report Builder) which points to
Add an expand or collapse action to a Report Builder paginated report
Now the key help here is the term ToggleItem which is found only in the 3rd child link above. Also do not make the mistake like I did of looking at Textbox cells. We are wanting to work our way up the children of the multi level group hierarchy.
Each child group references its parent group. Set Hidden (Visibility) to True to set the initial toggle state to unexpanded (+)

Youtube

drilldown report in paginated report builder by SKRTDATAMUSIC (thanks bro 🙂

Screenshots

Re: paginated report - drilldown, drill down, drill-down functionality setup

v-veshwara-msft — Wed, 10 Dec 2025 09:31:17 GMT

Hi garythomannCoGC ,
Thanks for sharing this in Microsoft Fabric Community and for adding the helpful links.

This is useful information, and the way you explained the group hierarchy and the use of the parent group as the ToggleItem will assist others working on drilldown in paginated reports.

If you are open to it, this could also be a good post for the Power BI Community Blog so more users can benefit from it: Power BI Community Blog - Microsoft Fabric Community

If you have any other questions, feel free to reach out.

Best Regards,
Vinay Kumar Eshwara.

Re: paginated report - drilldown, drill down, drill-down functionality setup

garythomannCoGC — Wed, 10 Dec 2025 22:50:12 GMT

Thanks v-veshwara-msft Vinay, yes open to sharing on the community blog.

Re: paginated report - drilldown, drill down, drill-down functionality setup

v-veshwara-msft — Mon, 15 Dec 2025 07:55:02 GMT

Hi garythomannCoGC ,
Thank you for confirming. Appreciate your willingness to share this on the Community Blog. Please feel free to reach out if you have any further questions.