Crete report with code vb.net

[jserret]

Hello,


I need to create the structure attached to this post with code in vb.net

Is possible?


Could you send me an example of how to add new DataSources containing sql using code?

Thanks.

[Lech Kulikowski]

Hello,

You can find sample code in the following topic:
viewtopic.php?f=13&t=4873&p=152401

Thank you.

[jserret]

Hello,

Thank you very much, but I have another problem.

I have made the thread code but Data does not appear, I believe that the Datasource and Database are incorrectly connected, I attach capture where it seems that it is not well linked.

[Lech Kulikowski]

Hello,

Please send us a sample project which reproduces the issue for analysis.

Thank you.

[jserret]

Hello,

Please send us a sample project which reproduces the issue for analysis.

Thank you.

I use this code.

report.Dictionary.Databases.Clear()

Dim newConnectionString As String = "DEMO"

report.Dictionary.Databases.Add(New Stimulsoft.Report.Dictionary.StiOracleDatabase("directOracle", "directOracle", newConnectionString))
Dim sql As String = "select * from hola"

Dim DS1 As StiSqlSource = New StiSqlSource("directOracle", "ETACIV", "ETACIV", sql, True, False)

DS1.Columns.Add("ETCNOM", "ETCNOM", System.Type.GetType("System.String"))

report.Dictionary.DataSources.Add(DS1)


This is the resulting MRT. I have changed the sql and the Data Source connector for confidentiality

[Lech Kulikowski]

Hello,

Your data source is StiSqlSource but should be StiOracleSource. Please check your code.

Thank you.