Parent Columns and Child Columns don't have type-matching co
Re: Parent Columns and Child Columns don't have type-matchin
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.
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.
Re: Parent Columns and Child Columns don't have type-matchin
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.
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 167 times
Last edited by simgschw on Thu Feb 19, 2015 8:35 am, edited 1 time in total.
Re: Parent Columns and Child Columns don't have type-matchin
Hello.
We need some additional time to make some tests.
We will let you know about results soon.
Thank you.
We need some additional time to make some tests.
We will let you know about results soon.
Thank you.
Re: Parent Columns and Child Columns don't have type-matchin
Hello,
Please try to set the EngineVersion property for the report to EngineV2.
Thank you.
Please try to set the EngineVersion property for the report to EngineV2.
Thank you.
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
I set the EngineVersion to the suggested value but it resulted in the same error when rendering the report.
I set the EngineVersion to the suggested value but it resulted in the same error when rendering the report.
Re: Parent Columns and Child Columns don't have type-matchin
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.
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.
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
I'm sorry ... I corrected the report and removed some constraints and indexes from the sql script.
Thank you.
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 167 times
-
- Befund Mikro Hanusch.mrt
- (52.99 KiB) Downloaded 283 times
Re: Parent Columns and Child Columns don't have type-matchin
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.
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.
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
please try it again.
please try it again.
- Attachments
-
- Befund Mikro Hanusch.mrt
- (52.86 KiB) Downloaded 277 times
Re: Parent Columns and Child Columns don't have type-matchin
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.
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 (85.28 KiB) Viewed 3746 times
-
- Capture.PNG (59.39 KiB) Viewed 3746 times