Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Dynamic Connection String

Author  Topic  jevans Starting Member 1 Post Posted - 2006-05-22 : 13:22:36 I have a web application using the ReportViewer control. I have a requirement to be able to dynamically set the connect string at run time that is used for the report data. This is a server baised report - not local. From SQL Server 2005 BOL I did find the following: Reporting Services provides data extensions to support the following data source types: SQL Server, Analysis Services, Oracle, ODBC, OLE DB, and XML. Developers can create data processing extensions to support additional types of data sources. The connection information stored in a data source varies depending on the data source type. Examples of different kinds of connection strings are provided further on in this topic. You can specify a data source in the following ways: As embedded information stored within a report (this is referred to as a report-specific data source). As a shared data source, which is defined separately in Report Designer and saved on the report server as a separate item when reports are published. As an expression that is used to select the data source at run time. The topic goes on to explain that you pass the connect string as a report parameter which is fairly easy to do. The missing link - for me - is how do you get the report server to use that parameter as the connect string?? Thanks, Jim