SSRS: Customized Footer

Integrating custom information into the footer of reports.

When deploying multiple reports for user consumption, it’s helpful to users if they have helpful information when traversing the data and that data remains in a consistent location in every report.

To illustrate how to accomplish this goal, I’ll begin where the Calculation – Field Formatting article ended by adding two pieces of information within the footer of the report.

First, I’ll add a footer to the report.
Next, I’ll add two textbox controls into the footer.

In the first textbox, I’ll add an expression that displays the time at which the report is executed.

1-global-collections

In the second control, I’ll display to the user the current page and out of the total pages of the report.

2-global-collections

Now when execute the report, the report execution time and the current page number out of the total number of pages is displayed at the footer of every page in the report.

3-global-collections

Download Report
(right-click, Save As)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s