May 17, 2011 at 11:04 am
Is there a way to have RS 2008 R2 just go through and run each report and save an error if there is an error or save the PDF for a proper outcome?
Scripting things out would be neat, a tool that handles it would be fine. I'm just trying to automate some testing.
May 17, 2011 at 11:31 am
You could create a report subscription for each report and save to file share as PDF. If you have Enterprise Edition, you can set up a data driven subscription and feed in different report parameters including the output file name and location. Any report execution errors will be displayed in the subscription screen and then you can further research them in the log file. Unfortunately you have to create a subscription for each report, so if you have a lot of reports this could be a lot of work.
Anyone have an idea to create a report subscription template and easily apply it to each report either via scripting or in T-sql directly using the ReportServer db?
Thanks,
MWise
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply