Friday, March 30, 2012

Saving the server report at a default location automatically

I have created a server report that has been deployed on a server. I have written some code in VS 2005 that displays the report in a report viewer and automatically prints the report.

Now, instead of printing the report, I want to save it at some default location. However, it shows me a Save dialog box for which the manual interference is required. I want to run the report with several parameters, one by one, and want to automate it.

Can anyone tell how to give the default location or get the handle for save dialog box?

Thanks in advance!!!

Have you looked into setting up a schedule for the report and utilizing the delivery functionality that is already built into the product?

If that is not an option for you, and you just want to export the report programmatically, you can use the SOAP APIs to render the report and save it to disk.

Check out this article from SQL Books Online. It details the approaches you can use from Reporting Services:

http://msdn2.microsoft.com/en-us/library/ms157214.aspx

No comments:

Post a Comment