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
.
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