views:

129

answers:

2

I have a SSRS report which is the snapshot or another report. It runs every day @ 6 am. I want to add a header at the top of the report(snapshot), which indicates when the snapshot was taken so that the user knows when the snapshot was taken.

Does anyone know how can i do that?

A: 

if I truly understand your question :

you can add date or time of report processing by adding a textbox on header and write this expression as its value :

=TimeOfDay()

or

=Now()
masoud ramezani
A: 

Ususally you would use Globals!ExecutionTime to display this, but from my research, headers and footers are calculated when the report is rendered. A work around for this is to place the textbox (make it hidden) with Globals!ExecutionTime in it on the report body and then place another textbox in the header or footer which references that textbox like this: ReportItems!ReportBodyTextBoxName.Value.

Answer found on the following site:

http://www.manning-sandbox.com/message.jspa?messageID=52186

William Todd Salzman