locked
Dynamic Connection String For ReportDatasource RRS feed

  • Question

  • 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

     

    Friday, May 25, 2007 9:59 AM

All replies

  • 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.

    Friday, May 25, 2007 12:16 PM
  • Hi,

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

     

    Thanks

    Sonu

     

    Friday, May 25, 2007 1:56 PM