How to fire off a report and save it as pdf...

Using vb.net, does anyone know or has anyone fired off a sql report, save it as PDF to a defined path?

I am knew to sql reporting services and the help files are not very helpfile.

Any sample code would be helpful.

Thanks

Hello,

Have a look at the sample code on this page:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Specify the export format you want (in your case "PDF") as a parameter to the Render method.

-Chris

|||

I looked at the sample code, how ever, not sure where the references are to things like

"ReportExecutionService" and some of the other objects.

WHich .net items do I need to import?

Daryl

|||In your project you need add a web reference to the reportexecution service. this will create a proxy class that you an instantiate in code to call the web service|||does it matter that I am NOT building a web application? Building a Desktop vb.net exe.|||no it doesn't matter|||

I cannot find this reference. I looked in windows and system...

|||

Right-click your project and select "Add Web Reference"