Hi,
I have a sales report that includes sales information for different vendors. I have vendor as a dropdown parameter, which includes the option "All vendors".
What I want to do now, is to generate one pdf for each vendor, keeping the date parameters for each. It's of course too time consuming to produce one pdf at a time by going through all the vendors (there are ~150 vendors), and splitting the pdf generated by choosing "All vendors" is difficult because the length of the report for each vendor differ.
Can I use SSIS to solve this? Any help is greatly appreciated.
Btw, I'm using SQL Server 2005
Regards,
Kremfjes
As the adage goes "when life gets tough, the programmer writes a program". I'd write a small app to call down to the Report Server Render API to meet this requirement. Alternatively, you can set up a data-driven subscription to generate the reports and send them to a file share or e-mail.
No comments:
Post a Comment