reporting services - Can I run all the reports in a given folder from Report Server? -
having issue running reports here. have folder on report server contains several reports, reports added , deleted on weekly basis in folder.
i know how run given report, ideally i'm looking running reports in folder, possible?
thank in advance.
mike
this has different answers depending on whether need enter parameter values of these reports in order run them.
if don't, or if parameter values predictable (for example, every report takes date range, it's same range of them, last 90 days), use 2 ssrs web services.
for example, use report management service (i believe it's called reportingservices2005) names of reports in folder, , report execution service (reportexecution2005) provide parameters , execute each report. report execution service can return report output in choice of format (pdf, html, excel, etc.)
once had output of report, direct printer, save file share, or email attachment whoever needed go to.
here's link doing 90% of want do: http://nickturner.wordpress.com/2010/03/31/creating-ssrs-report-as-a-pdf-programatically/
if every report needs human enter parameters, comes down making easier human do. same idea of retrieving names of reports apply, you'd display each report in turn in reportviewer control, , once report run, change report reportviewer points to.
Comments
Post a Comment