Creating reports and dashboards | Stimulsoft community forum

Hello.

The cause is not in the report template. These types are for processing data by report engine, but the error comes from the ADO.NET. ADO.NET don't see the types in report template, it retrieve data from database as is, store it in tables and create relations. The error comes from this last stage. The data types should be same in your database. You should check your data.
Please, send as a sample project which reproduces the issue.

Thank you.

Hi,

I created a sample project for you.

You have to create your own oracle database before you run the sample. In attachements there is a sql script which you should execute to create the needed tables for my sample. The schemaName is p3rel11.


Then you can run the sample project.

Hello.

We need some additional time to make some tests.
We will let you know about results soon.

Thank you.

Hello,

Please try to set the EngineVersion property for the report to EngineV2.

Thank you.

Hi,

I set the EngineVersion to the suggested value but it resulted in the same error when rendering the report.

Hello,

Not all necessary tables used in the query presents in the sent sql script file. Can you please prepare a simple report with minimum count of tables and columns, which reproduce the issue and sent it for us for analysis.

Thank you.

Hi,

I'm sorry ... I corrected the report and removed some constraints and indexes from the sql script.


Thank you.

Hello,

Please check the sent files.
In the MaterialEingang datasource in the query you use table "material" (... FROM materialeingang INNER JOIN material ON materialeingang.idMaterial = material.id ). But this table not present in the sql script file.

Thank you.

Hi,

please try it again.

Hello,

Please, check the types of the columns in the relations. The columns in datasources have a different datatypes - long and decimal, please try to change it.

Thank you.