Custom connection string for Parameter values

[Andrew Nixon]

Hi,

I have a solution where some data is passed in a parameter to the report and the report decides which database to retrieve it's data from based on those values. This works fine for the report's datasource as I use the NeedDataSource event to connect the report to the appropriate db at runtime. 

How do I do this for parameters which are bound to SqlDataSource's?

The queries for the parameters seem to be executed too early and I can't find a 'needdatasource' event for the sqldatasource to give the appropriate connection strings.

Thanks

Andrew

[Massimiliano Bassili]

This is a tricky question and a tricky answer would be "the same way as you do with asp:SqlDataSource control". Seriously now, you should use a report parameter to pass the value you need directly to the database parameter. Or if you're a "code guy", you could do this with code like shown in the docs: Using Parameters with the SqlDataSource component.

Cheers!

[Andrew Nixon]

That works fine if I just want to change the data I get back from the database, I need to change the actual database to which I connect.

Thanks

Andrew

[Massimiliano Bassili]

This sounds quite counter intuitive as the SqlDataSource components are there to help you bind the reports quick and easy during design time and it makes little sense to me to change their settings in runtime, although you can access them through this.SqlDataSource .... binding through NeedDataSource sounds like the way to go in such scenario.