Scripting (Reporting Services SSRS)
Reporting Services supports a wide range of development scenarios through script.
Administrators can write script in Microsoft Visual Basic to automate how they deploy and manage a report server installation. Administrators can also generate and run Transact-SQL scripts that create, configure, and update a report server database. Administrators can also use the record and playback script features in SQL Server Management Studio to automate routine maintenance tasks.
Developers can create custom applications that include script. You can run script that makes calls to the Report Server Web service. Almost any operation that you can write in managed code can also be written in script.
Reporting Services supports Microsoft Visual Basic .NET script as the script language that can be processed by the RS.exe utility.
To write the script, you can use Visual Studio or a code editor. To run the script, you must use the RS.exe utility. This is a script host that runs on the report server.
To learn how to write script and use the tool, see SQL Server Reporting Services Product Samples.