change connection string of an mrt dataset from vb.net code

[brillox]

Hi,

I have designed a report based on a connection string of my locla SQL database; my problem is ... how can I change the connection string of the mrt dataset from the VB.Net code before moving the application on the productions erver ?

[Stephan1]

Hi Brillox,

were using this piece of code for changing the Connection.

Dim sqlDB As Stimulsoft.Report.Dictionary.StiSqlDatabase
sqlDB = stireport1.Dictionary.Databases("Databasename_in_MRT")

If Not IsDBNull(sqlDB) Then
sqlDB.ConnectionString = constr
End If

Hope this helps,

Stephan