Link to home
Start Free TrialLog in
Avatar of xtrout
xtrout

asked on

SSRS Snapshots in a report

Hello Experts,

I am looking to build a report using links to snapshots. As a backstory, we recently redployed some automated reporting and archived our old reports. In those old reports, there were monthly snapshots of the data. We would like to make these snapshots available to our end users until enough time has passed that they wont need them anymore. My question is this... How do I go about using the ReportServer database and ReportServerTempDB to create a report to list the old snapshots? Ideally we don't want to have our end users having to look through every archive folder to get the snapshots so I though I might be able to build something that would display them in list form or parameter fed report. Any ideas or examples out there?

Thanks,
Clint
Avatar of sureshbabukrish
sureshbabukrish
Flag of India image

Avatar of xtrout
xtrout

ASKER

Thanks sureshbabukrish, but I know how to create a snapshot. What I need is a good souce on how to copy snapshots to another report or create a report that would display snapshots. We archived some reports with historical data. Now we have some new reports and we would like to move the old snapshot under the new report.
ASKER CERTIFIED SOLUTION
Avatar of xtrout
xtrout

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of xtrout

ASKER

closing question