If you want to do your users a service, standardize on displaying certain things on your reports. This slab is a cheat sheet for doing just that.
One of the goals of a well thought out report system is to help everyone get to “one version of the truth”. To that end, it is a good idea to display a standard list of items. Here’s my basic list:
A Report Identifier:
This is important because it allows people to easily communicate about a particular report. For instance, your sales director may want to talk to the CFO about something on a given report. It’s a lot easier to “report XYZrpt015″ that a fully qualified URL. What your standard is is up to you, but I recommend a two or three char system identifier (i.e., ACC for Accounting, or WMS for warehouse management) and a number.
The location of where to find the report:
=Replace(Globals!ReportServerUrl,"localhost","ServerName") & Globals!ReportFolder & "/" & Globals!ReportName
Notice the use of the Replace function; I do this because The ReportServerUrl has Localhost in it, and if you have multiple SSRS installations… you get the idea.
Tip: set the Action of this textbox to Link. Not terribly useful by itself, but when exported, the link will work.
Date Printed:
Printed: [&ExecutionTime]
Page Numbers:
Page [&PageNumber] of [&TotalPages]
Parameters:
I recommend you list all params on your report. It provides insight into what this report is about, and in certain situations, allows the report to be run again with the same params.
