Parent Columns and Child Columns don't have type-matching co

Stimulsoft Reports.NET discussion
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Parent Columns and Child Columns don't have type-matchin

Post by HighAley »

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.
simgschw
Posts: 73
Joined: Mon Jan 07, 2013 1:34 pm

Re: Parent Columns and Child Columns don't have type-matchin

Post by simgschw »

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.
Attachments
Sql_scripts.zip
(6.54 KiB) Downloaded 164 times
Last edited by simgschw on Thu Feb 19, 2015 8:35 am, edited 1 time in total.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Parent Columns and Child Columns don't have type-matchin

Post by HighAley »

Hello.

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

Thank you.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Parent Columns and Child Columns don't have type-matchin

Post by Alex K. »

Hello,

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

Thank you.
simgschw
Posts: 73
Joined: Mon Jan 07, 2013 1:34 pm

Re: Parent Columns and Child Columns don't have type-matchin

Post by simgschw »

Hi,

I set the EngineVersion to the suggested value but it resulted in the same error when rendering the report.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Parent Columns and Child Columns don't have type-matchin

Post by Alex K. »

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.
simgschw
Posts: 73
Joined: Mon Jan 07, 2013 1:34 pm

Re: Parent Columns and Child Columns don't have type-matchin

Post by simgschw »

Hi,

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


Thank you.
Attachments
Sql_Scripts.7z
(2.99 KiB) Downloaded 164 times
Befund Mikro Hanusch.mrt
(52.99 KiB) Downloaded 279 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Parent Columns and Child Columns don't have type-matchin

Post by Alex K. »

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.
simgschw
Posts: 73
Joined: Mon Jan 07, 2013 1:34 pm

Re: Parent Columns and Child Columns don't have type-matchin

Post by simgschw »

Hi,

please try it again.
Attachments
Befund Mikro Hanusch.mrt
(52.86 KiB) Downloaded 273 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Parent Columns and Child Columns don't have type-matchin

Post by Alex K. »

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.
Attachments
Capture2.PNG
Capture2.PNG (85.28 KiB) Viewed 3688 times
Capture.PNG
Capture.PNG (59.39 KiB) Viewed 3688 times
Post Reply