ssrs page number error in report

Posted on 2011-05-05
Last Modified: 2012-05-11
In my page footer I have this common expression: ="Page " + Globals!OverallPageNumber.ToString + " of " + Globals!OverallTotalPages.ToString

When I preview the report in VS, the page numbers are displayed correctly.  I then build & deploy the report to my reportserver.  When I go to the reportserver and run the report, the page number expression displays #Error.  Grrrrr....ppplease help.
Question by:MariaHalt
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Are you building the report in a 2008 R2 environment and deploying it to a 2008 environment maybe?

    Author Comment

    by:MariaHalt can I tell???
    LVL 22

    Accepted Solution


    You can also change the expression to:
    ="Page " & Globals!PageNumber & " of " & Globals!TotalPages.ToString
    If that solves your problem the server probably has 2008, because OverallPageNumber and OverallTotalPages are new to 2008 R2.

    Author Closing Comment

    Yep, that works.  Thank you.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
    This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video discusses moving either the default database or any database to a new volume.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now