reporting-servicesssrs-2008ssrs-2008-r2

Access Page number in report body In SSRS


I want to use Globals!PageNumber in Report body part. How can I access inside Report body?

I am using SQL Server Reporting Service 2008 R2.


Solution

  • Create functions in the code under the report properties:

    Page Number:

    Function PageNumber() As String    
        Return Me.Report.Globals!PageNumber    
    End Function
    

    Total Pages:

    Function TotalPages() As String   
        Return Me.Report.Globals!TotalPages    
    End Function
    

    Access it in the body via an expression:

    =code.PageNumber & " of " & code.TotalPages
    

    Check out Sample Usage of the Concat Function