Skip to content

Latest commit

 

History

History
52 lines (38 loc) · 2.18 KB

run-a-reporting-services-script-file.md

File metadata and controls

52 lines (38 loc) · 2.18 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords
Run a Reporting Services Script File
View examples of how to run a Reporting Services script file from the command prompt using the Reporting Services script environment (RS.exe).
maggiesMSFT
maggies
03/01/2017
reporting-services
tools
conceptual
updatefrequency5
scripts [Reporting Services], running

Run a Reporting Services Script File

[!INCLUDEssRSnoversion] script files are run from the command prompt using the [!INCLUDEssRSnoversion] 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.

Sample Command Lines

  • Run Script.rss in the script environment designating the target report server. Windows Authentication is applied by default:

    rs -i Script.rss -s https://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 https://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 https://servername/reportserver -l 30  
    
  • Run Script.rss in the script environment specifying a global script variable called report.

    rs -i Script.rss -s https://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 https://servername/reportserver -b  
    

See Also

Technical Reference (SSRS)