Hi,

I am using the shared data source to create the report(SQL Server Reporting Services 2005). It is using the static connection string. During the deployment I have to change the server name, database etc... And also I want to give the option to client to configure the connection. The best place I want to store the connection string is web.config file. Can you please let me know how to use connection string stored in the web.config to create reports?

Thank you