Getting a recent snapshot report
How to get a snapshot report based on the Historyid programmaticallyPrawin
August 5th, 2011 6:42am
I am unable to get the recent snapshot report programmatically in .net using SSRS
the recent snapshot report wiil be displayed using the HistoryID.
Please suggest me some ideas as i am a newbie to SSRSPrawin
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2011 12:05pm
Hi Prawin Kumar Sreeram.
Did you mean to build a report in SSRS referring certain data from the snapshot or displaying the recent snapshot?
If that is the case, I am afraid that, you won’t be able to use a snapshot directly as a data source. The information in a
report snapshot is stored in ChunkData table in ReportServer database. However, there is a workaround to get it to work with XML data extension in SSRS 2005.
More details, please refer the this thread:
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/9e5fb93b-8f27-4a7a-b209-0933d0158375
Thanks,
Lola
Please remember to mark the replies as answers if they help.
August 8th, 2011 2:26am