DataSource ConnectionString Runtime

[iomega55]

Hi:
We have 2 team T1 and T2, T1 only reports and T2 .aspx, web services, etc.

At this moment T1 delivers *.mrt files, so T2 loads and uses them inside .aspx. T2 defines which parameters will be sent to reports, so T1 designs reports based on those parameters. As you can see we dont use embebbed reports.

If T1 uses a different connectionstring, T2 eachtime is changing manually the connectionstring for each report according to T2 backend requeriments.

Can you mention if there is a way for changing the connectionstring at runtime?

Thanks.

[Vital]

Tes you can:

Code: Select all

report.Dictionary.Databases.Clear();
report.Dictionary.Databases.Add(new StiSqlDatabase("NameOfConnection", "New Connection String"));

Thank you.