Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««45678

Dynamic Connection Strings in Reporting Services 2005 Expand / Collapse
Author
Message
Posted Monday, November 28, 2011 9:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 24, 2013 5:50 PM
Points: 49, Visits: 407
ok.
step 1: create one simple report for one database and run it.(check whatever you want is there or not)
step 2: then create one parameter 'SelectDatabase'. now go to parameter properties-> available values-> specify values->;(add your databases name here[how many you want])
step 3: go to datasource properties and paste this ="Data Source=ServerName;Initial Catalog="+Parameters!SelectDatabase.Value
Step4: Save and Run your report . Now you have to select database. Select it and run report.

Let me know if you have some problem.

Thanks
Post #1212591
Posted Thursday, April 5, 2012 6:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 21, 2012 1:13 PM
Points: 2, Visits: 11
Microsoft's solution to this problem is the introduction of "Expression-based Connection Strings" (see this article for reference) which unfortunately does not apply to shared data sources.

Fortunately, by using a tool, some report design standards, and a Report Definition Customization Extension (RDCE), it is possible to change the Data Source References on the RDL file to point to the right Server-Database pair.

You can check this article:

Dynamically Pointing to Shared Data Sources on SQL Reporting Services using a Report Definition Customization Extension (RDCE)
Post #1279282
« Prev Topic | Next Topic »

Add to briefcase «««45678

Permissions Expand / Collapse