Access Page number in report body In SSRS

by

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

More Related Contents:

  1. How to get rid of blank pages in PDF exported from SSRS
  2. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  3. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  4. Need help in calculation using two Datasets using Expression SSRS
  5. SSRS distinct lookupset function
  6. SSRS Conditional Formatting Switch or IIF
  7. Pivot a table in reporting services?
  8. SSRS multi-value parameter using a stored procedure
  9. Compare SQL Server Reporting Services to Crystal Reports [closed]
  10. Does the iif function compute both paths in SSRS or is it short-circuited?
  11. SSRS Expression Divide by Zero Error
  12. Reporting Services export to Excel with Multiple Worksheets
  13. Changes to parameter not showing on Report Server after deployment
  14. When to use RDLC over RDL reports?
  15. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  16. divide by zero/null workaround in SSRS 2008 report
  17. SSRS – How to build a simple multi-column report?
  18. SSRS – How to continue data to next column?
  19. How do I format date and time on ssrs report?
  20. Optional multi-valued parameters in SSRS
  21. Passing Credentials to Sql Report Server 2008
  22. How to combine aggregates within a group with aggregates across groups within SSRS
  23. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx
  24. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  25. hide/remove header and footer
  26. Left Outer Join Not Working?
  27. SSRS 2014 report deploy issue
  28. Reporting Services permissions on SQL Server R2 SSRS
  29. SSRS 2008 – Dealing with division by zero scenarios
  30. Could not load file or assembly ‘Microsoft.ReportViewer.Common, Version=11.0.0.0

Leave a Comment