Previous Install Taskpad View Report Manual Install Install Linked Report Generator Next

Install Reporting Services Scripter

FineBuild can install and configure Reporting Services Scripter (RS Scripter) as part of the SQL Server install process. If you do not want to include RS Scripter in your FineBuild install, then do not download it.

RS Scripter was written by Jasper Smith, a SQL Server MVP. It was chosen to be included in FineBuild because it enables scripting of Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another.

RS Scripter works with all SSRS components up to SQL Server 2008, but does not process Report Parts or any other components introduced from SQL Server 2008 R2 onwards. The original web site that hosted RS Scripter is no longer available and a copy captured by Web Archive is used below.

RS Scripter archived home page http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/showarticle.asp?ID=62
RS Scripter archived download http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/samples/code/RSScripter/RSScripter.zip
RS Scripter archived documentation http://web.archive.org/web/20120220094708/http://www.sqldbatips.com/samples/code/RSScripter/readme.htm
RS Scripter introduction http://siddhumehta.blogspot.com/2009/10/how-to-automate-ssrs-reports-deployment.html
RS Scripter report deployment http://ranimsbi.blogspot.com/2010/12/using-rs-scripter-to-create-deployment.html

FineBuild RS Scripter Install

Automated installation of RS Scripter is performed by Process Id 4RB and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
InstRSScripter FULL Yes Yes Yes Yes Yes
InstSQLTools No No No No No
InstRSScripter WORKSTATION Yes Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes Yes
InstRSScripter CLIENT Yes Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes Yes


FineBuild also uses the following parameters to help install RS Scripter:
Prameter Default Value Description
RSScripterZip RSScripter.zip Name of file holding RS Scripter install media

RS Scripter will be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/InstSQLTools:Yes
RS Scripter cannot be installed by FineBuild on a Windows Core operating system because it is supplied in zip file format.

The FineBuild install for RS Scripter includes the following:
  • Perform a RS Scripter install
  • Add a menu item for RS Scripter to the Reporting Services menu.

Manual RS Scripter Install

The following steps show what you would have to do to install RS Scripter manually. FineBuild does all of this work for you automatically.

Install RS Scripter

1) Navigate to the Additional Components folder. Right-click on RSScripter.zip and select Extract All
RS Scripter Explorer.png
2) Extract all files to C:\Program Files\RS Scripter.
RS Scripter Extract.png

Setup Menu Item

1) Navigate to C:\Program Files\RS Scripter, right-click on RSScripter.exe and select Copy.
RS Scripter Shortcut Copy.png
2) Navigate to the SQL Server Reporting Services menu folder on 2) and select Paste Shortcut.
RS Scripter Shortcut Paste.png
3) Right-click on the menu shortcut and rename it to RS Scripter.
RS Scripter Shortcut Rename.png
Copyright © 2011 - 2013 Edward Vassie. License and Acknowledgements
Previous Install Taskpad View Report Top Install Linked Report Generator Next

Last edited Aug 6, 2013 at 8:08 PM by EdVassie, version 17

Comments

kroberts Jul 12, 2013 at 11:56 AM 
Download link not working, getting a 504 Gateway Timeout