Automatically Generating PDFs With Reports Requiring Parameters

Hi,
I'm working on many reports that are generated using SQL Server
Reporting Services SP 1 from an ASP.NET 1.1 web application. One of the
things the users would like to do is have the report automatically
generate a PDF when they click on the View Report button after entering
the parameters for the report. Parameters could be a date, a city, a
state, etcetera. However, they would like to avoid having to choose the
format and click the Export link. Is there a way to manipulate the
functionality of the View Report button such that it does this
automatically? Thank you for any insights you can provide.
JabooHow are you accessing the reports?
1) Report Manager
2) URL parameters
3) Web Service
Kulgan.sql

Auto generate multiple pdfs

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.