how to specify connection string for detail report

[tomas]

Hello TElerik,

My web application enables a user to choose database at runtime. I have a more connection strings in a web.config.

Selected connection string key is stored in a session.

I can read this key during loading a page with a report web viewer.

My main report is accepting connection string parametr using its constructor, but I dont know, how to specify this for a details subreports.

Can you advice me how to solve this?

Thank you very much.

Tom

[Elian]

Hi Tom,

We would recommend to you to use Report Parameters. The Report Sources support parameters passing. Once you pass the connection string to the main report as parameter, it can easily propagate the parameter to its sub-reports (see: How-To: Creating Master-Detail Reports Using SubReports). 

In order to intercept the parameters inside the inner report (the one that serves as a sub-report), you can do the following:

1. Attach to the ItemDataBinding event of the report
2. In the ItemDataBinding event use the processing parameters
   

   private void Report1_ItemDataBinding(object sender, System.EventArgs e)
   {
       //Take the Telerik.Reporting.Processing.Report instance
       var report = (Telerik.Reporting.Processing.Report)sender;
   
       // Transfer the value of the processing instance of ReportParameter
       // to the parameter value of the sqlDataSource component
       var connectionString = report.Parameters["ConnectionStringParameter"].Value;
   
       // Set the SqlDataSource connection string
       ...
   }

Hope this helps.

Kind regards,
Elian
the Telerik team