Skip to content

Latest commit

 

History

History
54 lines (40 loc) · 2.07 KB

File metadata and controls

54 lines (40 loc) · 2.07 KB
title Run a Reporting Services Script File | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology reporting-services-native
ms.topic conceptual
helpviewer_keywords
scripts [Reporting Services], running
ms.assetid 0de4995c-85ec-4d4c-aaef-fbd30edfb20f
author maggiesMSFT
ms.author maggies
manager kfile

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 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  
    

See Also

Technical Reference (SSRS)