Creating reports and dashboards | Stimulsoft community forum

Posted: **Sat Aug 30, 2014 4:47 am**

hello every body ,
i have reports that saved in database (sql) ,i want to change connection string during run time i am using procedure as below but when test the code report displayed without data

Code: Select all

 Public Shared Sub PreviewReport(ByVal obj As Object, ReportID As Integer, ByVal Parameter As String)
        Dim report As New StiReport
        report.Load(New MemoryStream(GetReport(ReportID)))
        report.Dictionary.Databases.Clear()
        report.Dictionary.Databases.Add(New Stimulsoft.Report.Dictionary.StiSqlDatabase("Receipt", HelperD.SqlCon.ConnectionString))
        report.Save(New MemoryStream(GetReport(ReportID)))
        report.RegData("Receipt", obj)
        report.Compile()
report("TRXNUMBER") = Parameter
        report.Render(False)
        report.Show()

how to solve this issue ?

Posted: **Mon Sep 01, 2014 6:28 am**

Hello,

Can you please send us your report template for analysis.

Thank you.

Posted: **Mon Sep 01, 2014 10:24 am**

please check it

Posted: **Mon Sep 01, 2014 12:36 pm**

Hello,

In your report the database connection name is "Connection" but you add new connection with "Receipt" name. The names must be identical. Please try to use the following code:

Code: Select all

Dim report As New StiReport
report.Load(New MemoryStream(GetReport(ReportID)))
report.Dictionary.Databases.Clear()
report.Dictionary.Databases.Add(New Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", HelperD.SqlCon.ConnectionString))
report.Save(New MemoryStream(GetReport(ReportID)))
//report.RegData("Receipt", obj)
report.Compile()
report("TRXNUMBER") = Parameter
report.Render(False)
report.Show()

Also you can try to change the connection string, without clear and adding:
((StiSqlDatabase)report.Dictionary.Databases["Connection"]).ConnectionString = newConnectionString;

Thank you.

Posted: **Mon Sep 01, 2014 12:56 pm**

thank you very much Aleksey,
now every thing is ok.
your support highly appreciated

Posted: **Tue Sep 02, 2014 4:07 am**

Hello,

We are always glad to help you!

Creating reports and dashboards | Stimulsoft community forum

when change connection string Report displayed Empty

when change connection string Report displayed Empty

Re: when change connection string Report displayed Empty

Re: when change connection string Report displayed Empty

Re: when change connection string Report displayed Empty

Re: when change connection string Report displayed Empty

Re: when change connection string Report displayed Empty