x

How to make SSRS display the correct number of pages

When a report spans multiple pages, SSRS displays the page number like this in the navigation bar: 1 of 2 ?

SSRS displays 2 ? when there are in fact 14 pages in the report.

How can I force SSRS to display the final page number correctly (without requiring the user to click the Last Page button)?
more ▼

asked Feb 11, 2011 at 03:05 AM in Default

xnl28 gravatar image

xnl28
895 56 60 62

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
It's been a couple of months since I was playing around in SSRS, but if I remember correctly, switching to the print view displays the actual number of pages.
more ▼

answered Feb 11, 2011 at 10:46 AM

djpbusinessinc gravatar image

djpbusinessinc
1

(comments are locked)
10|1200 characters needed characters left
Change the ReportViewer PageCountMode to "Actual"
more ▼

answered May 06, 2013 at 12:21 PM

Giridhar_ks gravatar image

Giridhar_ks
1

(comments are locked)
10|1200 characters needed characters left

1.Add a footer at the bottom of the report. 2.In the footer create a textbox. 3.Add the following expression in the textbox:

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

answered May 07, 2013 at 07:10 AM

ruancra gravatar image

ruancra
1.1k 21 25 32

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x587
x555

asked: Feb 11, 2011 at 03:05 AM

Seen: 2385 times

Last Updated: May 07, 2013 at 07:10 AM