Is there a way to save report history snapshots that are from ad-hoc reports? We wish to save copies of ad-hoc reports for others to view. These reports all have multiple parameters each time they are run (no defaults). They are also long-running reports, so when one person runs the report with certain parameters, we want others to be able to view it at a later time.

Export to Excel and save...?Bonediggler

They want to be able to view the reports from the History tab though.

Thanks for your posting. If I dont misunderstood you would like to take this snapshot of your report for later viewing purpose, if that is the case then Please follow these steps I am assuming that you are using SQL Server 2008 Go to your report which you would like to take the snapshot Right click the report and go to manage now you can see the following screen go to snapshot option Click on radio button Report-specific schedule and then create a schedule that how often you would like to take the snapshot now you have done The report will run the time specified by you and you can see that going to report history Screenshot for your help If you have any question please let e know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

This report takes several different parameters that change every day though. What we want is that when someone runs the report with whatever parameters they choose that the report is available for others to see under History. What we are after is something that mimicks Crystal Info, in that when you run a report with whatever parameters you choose, the report output is stored right in Crystal Info for others to see.

Hello dachrist, I consider that you want to get all history information for a report executed by everybody. From my experience, there are no places to store the job history in the report server database. All the history about the job is stored in the MSDB database. I cannot find out the mapping between the job and subscription. If you have further questions about this issue, please tell me freely. Regards, EdwardEdward Zhu TechNet Community Support

Hello dachrist, I consider that you want to get all history information for a report executed by everybody. From my experience, there are no places to store the job history in the report server database. All the history about the job is stored in the MSDB database. I cannot find out the mapping between the job and subscription. If you have further questions about this issue, please tell me freely. Regards, Edward Edward Zhu TechNet Community Support Hi There Thanks for your posting. I dont know whether this is useful for you or not, but the following query will give you a relationship between MSDB and report server database about all the job Many thanks Syed Qazafi Anjum Select * FROM ReportServer.dbo.[Subscriptions] Subscriptions INNER JOIN ReportServer.dbo.ReportSchedule R ON Subscriptions.SubscriptionID = R.SubscriptionID INNER JOIN msdb.dbo.sysjobs J ON Convert(nvarchar(128),R.ScheduleID) = J.name INNER JOIN msdb.dbo.sysjobschedules JS ON J.job_id = JS.job_id Please also have a look http://bidn.com/blogs/marcoadf/bidn-blog/340/subscriptions-how-to-manage-them