Export (0) Print
Expand All

Run 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.exe Utility (SSRS). For more script samples, see SQL Server Reporting Services Product Samples.

  • 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
    

Community Additions

ADD
Show:
© 2014 Microsoft