Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Oct 24, 2007 5:02 am**

How can i set the Connection Info of my report ?

I got the following code to load the report

Dim stireport1 As New Stimulsoft.Report.StiReport
stireport1.Load(path) ' where path is the path of the report

how can i now set the connection of the report ?. in the report is saved trusted connection to a server.
i need to set manually another server for the data etc. ?

thx for you help

Posted: **Wed Oct 24, 2007 8:30 am**

Hi,
If you need to change the connection string for an SQL Server Database at runtime in the report you can do the following:

Code: Select all

Stimulsoft.Report.Dictionary.StiSqlDatabase sqlDB = report.Dictionary.Databases["MY_DB_NAME"] as Stimulsoft.Report.Dictionary.StiSqlDatabase;
if(sqlDB != null)
{
    sqlDB.ConnectionString = "My Connection String";
}

Where "MY_DB_NAME" is the name of the Connection source in your report.

Posted: **Thu Oct 25, 2007 7:50 am**

Thx, that worked fine.

Creating reports and dashboards | Stimulsoft community forum

How to set the Connection Info of the Report ?

How to set the Connection Info of the Report ?

How to set the Connection Info of the Report ?

How to set the Connection Info of the Report ?