Showing posts with label reportdatasource. Show all posts
Showing posts with label reportdatasource. Show all posts

Friday, February 24, 2012

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