SSRS total pages number error. (Adds a Question mark(?) after total page number in SSRS report)

Paging Issue in SSRS Report adds a question mark instead of display the total number of pages

In this blog i am going to give the solution how to solve this problem. Generally the problem could be like below:

Suppose we have one report deployed on ssrs 2008, it shows on view report
1 of 2? or 2 of 3? and so on... as shown below in image.



So if you can see the screenshot there is a question mark after 3(Encircled in red) .we have a total of 50 pages in the report
but instead of displaying the last page it is showing a question mark and we cannot show question mark as it was client request.
When press to show next page, it shows
2 of 3?,
after 3 of 4?. And in that mode till the end of the report.



So, we could easily solve this error. Just place a textbox in footer or header and goto the Expression of that textbox. Now goto Built-In Fileds and select OverallTotalPages(or type in query box:: =Globals!OverallTotalPages)
i.e. Place Textbox in Header/ Footer-> Goto Expression-> Select Built In Fields-> Select OverallTotalPages.

Now goto the textbox properties of textbox and in Visibility section Select Hide radio button. Your problem is solved. Look at the image below. . :)




Comments

  1. HI you have a good blog i like your blog as it have all the good information. for more information Click on cotton kurtis

    ReplyDelete
  2. Thanks for sharing with us. It’s very informative blog and this blog has solved many problems
    Plot in Hyderabad
    Farm Land in Hyderabad
    Land in Hyderabad

    ReplyDelete
  3. It is an exclusive online community designed to help interracial, diverse ethnic singles to meet new friends, make great dates, and build lasting interracial relationships. Meet like minded singles who are looking to date outside their race.
    Interracial Marriage
    Interracial Dating

    ReplyDelete

Post a Comment

Popular posts from this blog

How to show enlarge image when mouse hover on image or link in Asp.Net(c#) using JavaScript

StateCode and StatusCode Values for mostly used entities in Microsoft Dynamics CRM 2013

How to add custom filter lookup field based on OptionSet field selection in Dynamics CRM.

go to top image