SSRS Snapshot question
Hi,
I just want to do a ssrs snapshot test. This is what I did.
Create a report, drag a textbox, make the expression = Now(), it shows the current time. Then I did the deployment. In report->Property->Processing Options=>Check "Render this report from a report snapshot" and "Create a report snapshot when you
click the Apply button on this page. I saw this snapshot in Report history. But when I click this snapshot, the textbox is supposed to show the time when I generate the snapshot. But it always shows the current time.
Is there anything I did wrong? Please help! Thank you.
Rui
May 14th, 2012 8:55am
Hi Rui,
In Reporting Services, the Now() or Today() function always returns the current date/time. When a report is rendered from a snapshot or a report cache, the Now () function may not match the rest of the report data. This is by design. So, what you have done
to generate a snapshot is absolutely right and the report also behaves normally.
Be different from the Now() function, the built-in field "=Globals!ExecutonTime" always returns the date/time that the report starts running. So, you can use the ExecutonTime field instead to verify the snapshot.
Reference:
Using Built-in Globals and Users References
If you have any questions, please feel free to let me know.
Regards,
Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 12:05pm