Skip to content

Latest commit

 

History

History
54 lines (38 loc) · 2.16 KB

File metadata and controls

54 lines (38 loc) · 2.16 KB
title Run a Reporting Services Script File | Microsoft Docs
ms.date 03/01/2017
ms.prod reporting-services
ms.prod_service reporting-services-native
ms.technology tools
ms.topic conceptual
helpviewer_keywords
scripts [Reporting Services], running
ms.assetid 0de4995c-85ec-4d4c-aaef-fbd30edfb20f
author maggiesMSFT
ms.author maggies

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)