Tuesday, June 2, 2015

Deploy SSRS Report using RS utility (rs.exe)

To deploy the report Automated, we have to follow some steps given below.

Prerequisites:

1. Get the .exe files from local or Online. https://msdn.microsoft.com/en-us/library/ms162839.aspx
2. DOS needs to be installed.

Step 1: Go to the folder where you save this .exe files. (Here you can see 3 types of file- .exe, .exe.cofig, .cmd)
 
Step 2: Now Copy the .rdl file from your report solution and paste these in a same folder.
Step 3: Right click on "UserSSRSS.exe.config" file and "Edit" it through notepad. Edit as per picture given below.

Step 4: Now Right click on ".cmd" file and "Edit" it through notepad. Edit as per picture given below.
 
here PAD1 is the variable for report path.

Step 4: Now go to CMD and follow the picture in below.

Here you need to give the cmd file name follow by DB server name and DB name. Then Press Enter button.

Output: Now you can get a screen like this. "Deploy Report Completed"



No comments:

Post a Comment