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

Saving changes in MDX

Hi,

I have written a report in Reporting Services 2005 which gets its data from a cube.

I want to edit the mdx generated by the Mdx builder in RS 2005, so I click on the "design mode" button to do this.

However, when i make the changes, i cannot save it. How can I do this?

Thanks,

Ashleys.

The only time it seems that you can't save the mdx changes are when they are not syntactically correct. Paste the same query into management studio and see if it runs w/o errors (and if you have @.parameters in the query, use actual valuse for them instead).

sql