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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics