Is it possible to define a datasource which has a dynamic connection string based on a report parameter
Specifically I'm interested in using the XML data source, but I would like to use one data source for an unlimited number of files (instead of having a separate data source for each xml file). I was thinking that maybe I could just pass a parameter into the Render() web service method and have the connection string substitute the correct filename into the connection string.
Is this possible
Parameterized Connect String
Hot Topic
- Cursor versus Temporary Table
- Using DSO for parallel partition processing
- Dynamic Percentile Lines
- Agent Proxy accounts not listed
- Getting rid of 0 and 'NaN' values in my report?
- is it possible to have variant condition clause in procedure?
- Looking for simple sample
- Measure expressions and currency conversion
- Data flow task reports different row count than actual rowcount
- The media set has 2 media families but only 1 are provided.
SQL Server
- Querying XML with FOR XML Explicit then saving as Text
- Retrieving IP address of current client's connection
- How to view MDX query from Excel report
- Is there a way to Import Tables From Microsoft Access 2003 with SQL Server 2005 Express?
- Migrating Legacy Maintenance Plans to SSIS?
- How to build a report from a cube in SSRS 2005
- The AcquireConnection method call failed with error code 0xC0202009.
- Database Diagram error on SQL 2005
- Replication with fifteen subscriptions
- SQL Server Express and the 1 Processor limit
Parameterized Connect String
MichaelEber
This topic in RS BOL talks about connection strings for xml datasets: http://msdn2.microsoft.com/en-us/library/ms159741.aspx
-- Robert
Rob-Nick
SysDev
Yes, you can make your connection string an expression (including using parameters) in RS2005. There were some bugs in this area in the June CTP but it should be OK in the final build.