Dynamic Connection String For ReportDatasource

Hi,

Is there any way to Dynamically change(Based on User login) Connection String for a report data source from code behind. In My application each user may have different data base. I am using a single shared data source for all the report. Please give me a solution.

Thanks

Sonu

You can use a report parameter and have the user choose from a list of different datasources and then you can use an expression for the connection string using the value of this report parameter.

Hope this helps.

|||

Hi,

Since I am using shared data source for reports I cannot write expression for connection string. So I cannot use parameter.

Thanks

Sonu