Textbox containing a date expression changes in snapshots ?


My report contains a TextBox with an expression "=Now()" in the Page Header
in order to display the date and time the report was generated.

Now, when I open a snapshot of the report the value in the TextBox changes
to the current date and time, instead of preserving the value that was there
at the time the snapshot was generated.

I thought snapshots were static.

1. What exactly remains static for snapshots ?

2. Can or do parameters also change ? The reason I am asking is because I am
also displaying the paraemter values in the Page Header and I don't want
those values to change.

3. Is there a workaround ? I would like to preserve the date and time and I
don't want it to change every time someone generates the report from the

4. I also have two other textboxes on the Page Header which are VB.NET code expression which calculate dates. Will these change ?

Thank you for your help !
Who is Participating?
rickchildConnect With a Mentor Commented:
1.  The following is stored as part of a snapshot:

- Data result set
- Report Definition (the code in the .rdl)
- Parameter Values
- Embedded objects such as images

2. Regarding parameters see the quote below from this link, but it looks like the parameters do not change.


You can create a snapshot for a report using one set of parameter values.
If a parameterized report supports multiple values for a single parameter (for example, an EmployeeID parameter that takes an employee-specific value), only one of those values is stored with the snapshot.
If a user requests the report using a different parameter value, the value is ignored.
The snapshot that the user sees is based on the parameter value that is stored with the snapshot.

3. You could try using this instead of =Now()


Also if that doesn't work the date and time of snapshot is stored with the snapshot in the database, as you can see the "When Run" in report manager next to the report.  Not sure exactly where this is stored, but a workaround may involve running a trace, opening that page to see which Stored Procedure is used by the server to pull this date, and using it in the report as a data source.

4. Unsure sorry, may need to test.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.