Export (0) Print
Expand All

Running a Reporting Services Script File

Reporting Services script files are run from the command prompt using the Reporting Services script environment (RS.exe). RS.exe has many command prompt arguments available for you to use. For more information about the command prompt options, see rs Utility.

  • Run Script.rss in the script environment designating the target report server. Windows Authentication is applied by default:
    rs –i Script.rss -s http://servername/reportserver
    
  • Run Script.rss in the script environment specifying a user name and password for authenticating the Web service calls:
    rs –i Script.rss -s http://servername/reportserver -u myusername -p mypassword
    
  • Run Script.rss in the script environment specifying a server time-out of 30 seconds:
    rs –i Script.rss -s http://servername/reportserver -l 30
    
  • Run Script.rss in the script environment specifying a global script variable called report.
    rs –i Script.rss -s http://servername/reportserver -v report="Company Sales"
    
  • Run Script.rss in the script environment specifying that the Web service operations in the script file are run as a batch.
    rs –i Script.rss -s http://servername/reportserver -b
    

Reference

Reporting Services Web Services Class Library
Report Server Web Service Library
ListChildren

Other Resources

Script Samples (Reporting Services)
rs Utility

Help and Information

Getting SQL Server 2005 Assistance

Community Additions

ADD
Show:
© 2014 Microsoft