As my web application is used by different clients the connection strings for each client is different so I am sending the connection string for the data source as one of the report parameter. So how do I assign this connection string to the report datasource when the report is run.
First I tried the below code in report constructor but it did not work.
// Required for telerik Reporting designer support
this.sdsQuotationAmounts.ConnectionString = ReportParameters["connectionstring"].Value.ToString();
this.sdsQuotationInfo.ConnectionString = ReportParameters["connectionstring"].Value.ToString();
// TODO: Add any constructor code after InitializeComponent call
If I use the custom report resolver the report parameters are not accessible, so how to solve this requests by sending the connection string as report parameters.