Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Reporting Services

Parameterized Connect String

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?

[512 byte] By [KenHarris] at [2007-12-16]
«« PleaseUrgentCrystal Report Grouping
»» {SOLVED} how to know if item is selected in ListView
# 1

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.

BrianWelcker at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
How would you write a xml connection string using report parameters?
AndersRoman at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3

This topic in RS BOL talks about connection strings for xml datasets: http://msdn2.microsoft.com/en-us/library/ms159741.aspx

-- Robert

RobertBrucknerMSFT at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
SQL Server
SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified