I need to automatically run the report on button click and save pdf to some location. Is there any way to export SSRS 2000 report directly to PDF and save ? Thanks, Meghna.

Check the following :- http://msdn.microsoft.com/en-us/library/aa256629%28v=sql.80%29.aspx You can achieve this with URL Access parameters. As an example http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=PDF&rc:Parameters=false&Year=2002

How to specify file name and location to save PDF file automatically.

How to specify file name and location to save PDF file automatically.

For auto save, see the following article. The URL access parameter method will prompt you for a filename. The easiest way is probably a subscription that delivers to the file system. The thread has a couple of methods of doing it. http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/a09d26ad-776a-447c-ab1a-ab59e1f8f667

For auto save, see the following article. The URL access parameter method will prompt you for a filename. The easiest way is probably a subscription that delivers to the file system. The thread has a couple of methods of doing it. http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/a09d26ad-776a-447c-ab1a-ab59e1f8f667