Click here to Skip to main content
13,197,342 members (52,763 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Dear All

I am new to SSRS and I am trying to deploy a newly created RDL file. I am trying to deploy the RDL file, but the problem coming is I developed the RDL file in one database(datasource) and I am trying to deploy the RDL file in another database(Datasource)

For eg:

The RDL file was created in DEVELOPMENT Database(datasource) and the RDL file is to be deployed in LIVE database (datasource). Both have the Stored Procedure that was used to generate the RDL design.

Please help.
Posted 22-Jun-12 4:33am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Follows the steps:
1.Open the Report Project (RDL) file in your Live Computer.
2.Click on View--->Report Data
3.R.Click on Your Data Source like DataSource1---->Data Source Property---->General--->Click on Edit---->Connection Properties
4.Set the Connection For Current Database
5.After Connection is done then go to Solution Explorer
6.R.Click on the Report Project2(Name of Report)--->Properties---->Report Project2 Property Page will appear.
7.Set the Target Server Url="http://localhost/ReportServer[^]" .Here you can set your Report deployment path.i.e "" or "http://KAMAL-PC/ReportServer" according your server name.

8. Deploy the the Report Project3---> It will deploy your report and give a Deployment path-->Copy this path like (http://localhost/ReportServer[^])
9. Then go to your .aspx page coding part where u Call the report
10.Set the Deployment Current Server path like(http://localhost/ReportServer[^])

11. Finally the Report will run.
ANILDEVKJ 25-Jun-12 1:28am
Dear Kamalakanta

Can I do it without changing the datasource in the RDL file all the time, because we will be creating more than 20 RDL file everyday and its a tedious work changing the datasource in each and every RDL file.
I was using the crystal reports before, and I was able to design the report in one database and just add the rpt file to another server and it used to work fine if the same SP exists in the live database also.
Kamalakanta Nayak 2 25-Jun-12 3:51am
Hi,ANIL you just changed Connection string of that Datasource1 but i am not saying to create new datasource1.
ANILDEVKJ 25-Jun-12 6:48am
Dear Kamalakanta

I understood that we can just modify the datasource rather than creating a new one, but even that is not a possibility in our line of work as we are using a SAAS model there are different databases that we need to connect to the same rdl file. We cannot create different rdl file for each client of us in the server.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171020.1 | Last Updated 22 Jun 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100