Monday, March 12, 2012

EXPERTS HELP

How can I download a report model from report server into a folder programmatically?

from sqldbatips.com - > reporting services scripter -> help file

[this is a free tool ]

you can then unpick the script it creates and use it as you wish

4.2.2 Scripting a Report Model

To script a report model simply select it in the Catalog Explorer Tree view, select the required Scripting Options and output folder and click the Script button. Depending on the options selected the following files will be generated (in this example I have selected the sample Adventure Works report model)

Adventure Works.smdl - This is the actual report model definition (SMDL) Adventure Works.smdl.rss - This is the RSS script that will load the Adventure Works report model and set any properties.The contents of the script depend on the following options Update Existing Model, Backup Model Definition RS Scripter Load All Items.cmd - This is the batch file used to run the generated script. This file is generated if Generate Load CMD File is selected|||

Thanks, Adolf

However, I am referring to the other way round. The script uploads report models from a file location c:

\source towards the report server ex. http://myserver/reportserver.

What I want is from server http://myserver/reportserver, I would download the .smdl into a folder location c:

\source.

|||

It may be worth posting on the sqldbatips site/email them.

The scripting tool has the ability to copy out resources (rdl files etc) when running it for use with the scripts, so it is obviously possible.

No comments:

Post a Comment