Click here to Skip to main content
Search within:




Next

SSRS- different datasource in RDL and in report server
Sign Up to vote bad
good
See more: SSRS
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
ANILDEVKJ343
Add a Solution


1 solution

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 "http://220.224.25.220/ReportServer" 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.
  Permalink  
Posted 22-Jun-12 5:41am
Kamalkant(kk)1.4K
Comments
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.
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Christian Graus 545
1 Ron Beyer 316
2 Tadit Dash 233
3 samadhan_kshirsagar 229
4 OriginalGriff 198
0 Sergey Alexandrovich Kryukov 7,061
1 Prasad_Kulkarni 3,815
2 OriginalGriff 3,557
3 _Amy 3,370
4 CPallini 3,034


Advertise | Privacy | Mobile
Web02 | 2.6.130619.1 | Last Updated 22 Jun 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid