Page numbering for subreport thats independent of main report (Report Builder)

mng — Thu, 21 Dec 2023 19:31:50 GMT

Hello,

I am using a subreport and want to use page numbering but I am only able to use the global page count which includes the count for every page of the report. The subreport needs to display its own page count in this format "Page X of Y".

If the main report has 10 pages and the subreport has 3 pages, the subreport 3 pages should show these respectively on each page "Page 1 of 3, Page 2 of 3, Page 3 of 3"

I'm currently using this expression but it gets the total count of the report.

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

Re: Page numbering for subreport thats independent of main report (Report Builder)

trivedisunita — Wed, 24 Jun 2026 09:41:40 GMT

Hi mng

In SSRS (and Power BI Report Server), the Globals!PageNumber and Globals!TotalPages always refer to the entire report, not just the subreport. That’s why you’re seeing the full count across all pages.

subreports don’t have their own independent page numbering context. They inherit the pagination from the parent report viewer. So there isn’t a built‑in way to reset page numbers inside a subreport.

Treat the subreport as a standalone report. If you export or render the subreport separately, the page numbers will correctly show “Page X of Y.” When embedded as a subreport, it loses that independence.

Also Instead of embedding as a subreport, consider merging the content into the main report with grouping and page breaks. Then you can control page numbering per group using expressions like-

="Page " & RowNumber("GroupName") & " of " & CountRows("GroupName")

I hope this helps you in your query.

If this reply helped, mark it as solutions and kudos would mean a lot!

Thank You

Sunita

topic Page numbering for subreport thats independent of main report (Report Builder) in Report Server

Page numbering for subreport thats independent of main report (Report Builder)

Re: Page numbering for subreport thats independent of main report (Report Builder)