Script Samples (Reporting Services)



The following samples represent scripts written for Reporting Services using Microsoft Visual Basic .NET. Script samples typically address a single feature or technology and are task-based. You can use script files with the Reporting Services SOAP API to access most of the management and administration operations available on your report server.

Important:
These samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples.



The following table describes the sample scripts.

File Description
AddItemSecurity.rss Demonstrates how to use a script to set item security policies in the report server namespace.
CancelRunningJobs.rss Demonstrates a sample administration script that cancels jobs that are running on a report server.
ConfigureSystemProperties.rss Demonstrates a script that can be used to set system-level, report server properties.
PublishSampleReports.rss Demonstrates a script that publishes the sample reports to a report server.


Requirements

Before you run sample scripts, the following conditions must be met:
  • The sample reports and the script files must first be installed to your hard drive using Reporting Services Setup or the separate sample installer.
  • You must have permission to run the rs utility from the computer on which a report server instance is installed.
  • You must have access to the report server that you are accessing with your script.
  • You must have appropriate permissions on the root folder of the report server you are accessing. For more information about permissions and user roles, see Using Role-Based Security.

Location of the Script Files

When you install the samples to the default installation directory, scripting samples are located by default in C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples.

Note:
If the samples have not been installed, see Installing Samples.



Running the Sample Scripts

You can run the sample scripts in the Reporting Services script environment.
To run this sample
  1. Open a command prompt: On the Start menu, click Run, type cmd in the text box, and then click OK.
  2. Navigate to the directory that contains your sample script. For example, if your sample script is installed in the default directory, type the following at the command prompt: * cd C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples *
  3. At the command prompt, enter the following to see a list of command prompt options available for use with the rs utility: * rs -? * Note: If you receive a message that rs is not a recognized command or batch file, you may need to add the location of rs.exe to your Windows environment variable PATH.
  4. At the command prompt, type the appropriate command to run the sample script file. For example, to run PublishSampleReports.rss type the following command, while replacing the given server URL with the report server you are accessing: * rs -i PublishSampleReports.rss -s http://myserver/reportserver *

Modifying the Script File

You can open any of the .rss files using a text editor.
© 2007 Microsoft Corporation. All rights reserved.

Last edited Nov 6, 2008 at 11:11 PM by bonniefe, version 18

Comments

dg_to May 9, 2012 at 10:18 PM 
The script samples did not install.