Sunday, March 11, 2012

Deploying Reporting Servoces Reports to the Production Server

Hi,
I am new to Reporting Services. I have installed RS and SQL Server200 on my dev machine. I have created a few .rdl files and deployed them. The TargetServerURL property of my project is set tohttp://localhost/ReportServer. and TargetFolder is "ScoreCardReports".
I have used the reports in my Asp.net app by the RS Webservice (Web Reference URL is :http://localhost/ReportServer/ReportService.asmx.). I used the Render mehtod the get the images from the reports.
Now I will deploy my Asp.net app by creating the msi installer created by the setup & deployment project.
But how to package the .rdl and .rds files so that the app works on the production server ? That will be a windows2003 server.
Please help.The way we deploy to prod is to have the change control person log ontothe prod reporting services, and use the "upload file" option,selecting the .rdl file to import.
|||

I have solved the problem by executing the rs.exe in a bat file. I have created the .rss file containing all the commands to create the reports folder and deploying the reports to the target server. The path of the file has been passed as a parameter to the RS command.

The person to setup the whole application should now only run the .bat file and all the reports will be deployed to the server at one click.

|||

Hi Boss Th Question what u asked is little bit complex.

What u need to generate an .rss file by writing code in VB.Net

use this .rss file with a small command & create a batch file

So whenever u run that batch on a particular server the Reports what u have developed will be deployted on tto the Particular Production Server

No comments:

Post a Comment