Global variables
Let's go to the expression editor. Click on Globals in
the first column of the expression editor. In the second column, you will see the
list of the global variables that are provided to the report.
In this example, we are going to use the global variables to create a page-numbering
scheme for our report. First, add a footer to the report. You enable this by going
to the Layout tab and selecting the Report Footer option from the
Report main menu. Now that you have a footer, drag four text boxes into the
footer section. Set their font properties to 8 pt, bold. Set the text for each text
box as follows:
Page
|
=Globals!PageNumber
|
of
|
=Globals!TotalPages
|
Switch to the Preview tab and run the report. You will now have a footer
on each page that looks something like 'Page 1 of 3'.
Some other globals variables are:
- ExecutionTime – this tells you how long it took to run the report
- ReportServerUrl – this allows you to verify that you are getting your report
from the correct source
- UserID - this shows under which User ID the report was run
You can use these global variables to build some basic diagnostics into your reporting.
You could also add these variables to the report footer and use a parameter to hide
or show them. That way, even in production, your users can see a tidy, clean report,
but you can see the same report with all the extra information on it.
|