Is there a way to run an SSRS report and create a PDF of the report as well as an Excel version of the report without having to run the report twice? We have Advanced Print Routing but don’t see an obvious way to create the rule.
Accounting is wanting this for their Monthly reports.
Might be a bigger change than you want but you can do this with Data Directive using Auto Print.
The following link shows how to launch a Print Program via code. You could just double it up. Once to print the PDF and another to create the Excel file
You’d want to change the line:
soa.ReportData.SalesOrderAckParam[0].AutoAction = "PREVIEW";
Fixed the link
Thanks for your answers.
I’ll try and get back on what worked.