SSRS Render URL - Total Page Count

Question

SSRS Render URL - Total Page Count

Karl Cinnamond 0

Using SSRS URL Access (REST) we need to get Total Page Count.

We are integration SSRS reports into our web application and calling our reports using e.g. POST to

/ReportServer?/myReportToRender&rs:Command=Render&rc:Toolbar=false&rc:Section=3&rs:Format=HTML5

Looking at the documents we can of course Page through using Section=PageNo wanted

BUT the response doesnt provide any indication in the Header, or HTML body of how many pages there are total?

Am I missing a command for the URL, that will calculate this?

1 answer

Your answer

Answer 1

Anonymous

Hi @Karl Cinnamond

Based on my searches, there doesn't seem to be a way to get the total number of pages accessed by URL. Here is a reference on URL access parameters: [https://learn.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-ver16.

If you want to get the total number of pages, you can add a textbox in the header of the report, and then use the global variable TotalPages in the expression.

For more details, you can refer to this link: [https://learn.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-built-in-globals-and-users-references-report-builder?view=sql-server-ver16.

Best regards,

Aniya

Karl Cinnamond 0 Reputation points

2023-01-12T17:28:44.6433333+00:00

@Anonymous Thanks for confirming.
Sadly I couldnt find it either, I was hoping the URL would have taken something like &rs:PageCountMode=
And rendered it into the metadata for the HTML :)

I've tried HTML4.0 and HTML5 rendering no luck

Interesting idea to include the field on the report, but a few issues from looking at it.

The div rendered for e.g. the textbox with PageCount doesnt have an ID etc on the div attribute, so no way to find it, unless you find a word like from the label, but this means each report needs visited to ensure they render a label and value the same each time

And if you chose to make the control hidden, its not on the HTML rendered at all

Anyway, many thanks for looking.

Share via

SSRS Render URL - Total Page Count

1 answer

Your answer