Parent Columns and Child Columns don't have type-matching co
Parent Columns and Child Columns don't have type-matching co
Hi,
I have a report which needs a relation between a csv-datasource and a xml-datasource. I added this relation but when rendering the report I get following exception:
Parent Columns and Child Columns don't have type-matching columns.
I prepared a report for you to reproduce this issue. I used the Master-Detail report from your sample and added the csv datasource DataSource1. Before you start reproducing the exception you have to exchange the Master-Detail and adapt the path of the csv datasource(csv_datasource.csv).
Steps to reproduce exception:
1. run the demo application
2. select Master-Detail report
3. click button "Design Report" so that the report is opened in the designer
4. Add the relation like shown in attachment relation
5. open preview and the exception will be thrown
Why is this happening and what can I do to avoid this?
I have a report which needs a relation between a csv-datasource and a xml-datasource. I added this relation but when rendering the report I get following exception:
Parent Columns and Child Columns don't have type-matching columns.
I prepared a report for you to reproduce this issue. I used the Master-Detail report from your sample and added the csv datasource DataSource1. Before you start reproducing the exception you have to exchange the Master-Detail and adapt the path of the csv datasource(csv_datasource.csv).
Steps to reproduce exception:
1. run the demo application
2. select Master-Detail report
3. click button "Design Report" so that the report is opened in the designer
4. Add the relation like shown in attachment relation
5. open preview and the exception will be thrown
Why is this happening and what can I do to avoid this?
- Attachments
-
- attachment relation
- relation.png (29.84 KiB) Viewed 6004 times
-
- csv_datasource.csv
- CSV datasource
- (240 Bytes) Downloaded 259 times
-
- Master-Detail.mrt
- extended Master-Detail Report
- (39.22 KiB) Downloaded 373 times
Re: Parent Columns and Child Columns don't have type-matchin
Hello,
We couldn't reproduce this bug.
Please check the last version.
Thank you.
We couldn't reproduce this bug.
Please check the last version.
Thank you.
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
as you suggested, I checked the latest version but it did not help either.
I made a video to help you to reproduce my issue.
So please have another try because this problem is very urgent.
as you suggested, I checked the latest version but it did not help either.
I made a video to help you to reproduce my issue.
So please have another try because this problem is very urgent.
- Attachments
-
- video.zip
- Video
- (17.39 MiB) Downloaded 251 times
Re: Parent Columns and Child Columns don't have type-matchin
Hello.
You create a relation on SupplierID and CategoryID. But there is no record with CategoryID=1 and SupplierID=5.
Thank you.
You create a relation on SupplierID and CategoryID. But there is no record with CategoryID=1 and SupplierID=5.
Thank you.
- Attachments
-
- Relation.png (38.99 KiB) Viewed 5993 times
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
maybe it is my fault that you have not yet identified the problem but I corrected the csv file as you suggested(please replace the report and csv file like shown in the video before).
Not matter if there is matching data in the relation, the problem is still Parent Columns and Child Columns don't have type-matching columns.
Please concentrate on this error.
maybe it is my fault that you have not yet identified the problem but I corrected the csv file as you suggested(please replace the report and csv file like shown in the video before).
Not matter if there is matching data in the relation, the problem is still Parent Columns and Child Columns don't have type-matching columns.
Please concentrate on this error.
- Attachments
-
- csv_datasource.csv
- CSV Datasource
- (249 Bytes) Downloaded 265 times
-
- Master-Detail.mrt
- Report
- (39.51 KiB) Downloaded 369 times
-
- Datasource1
- screenshot_datasource1.png (24.65 KiB) Viewed 5993 times
-
- Products
- screemshot_products.png (42.96 KiB) Viewed 5993 times
Re: Parent Columns and Child Columns don't have type-matchin
Hello.
We have reproduced the issue.
We need some time for analyzing.
We will keep in touch with any news.
Thank you.
We have reproduced the issue.
We need some time for analyzing.
We will keep in touch with any news.
Thank you.
Re: Parent Columns and Child Columns don't have type-matchin
Hello.
We have made an improvement.
It will be available in our next prerelease build that will be available today later.
Thank you.
We have made an improvement.
It will be available in our next prerelease build that will be available today later.
Thank you.
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
I tried with the new assembly and it worked. I have another report which has a same problem.
The report has a fix set of datasources from a database connection Xanthos. In addition I dynamically add a datasource ME_4097704_Kultur_mit_MHK1_1
and a report component using this datasource. The dynamic datasource also has a relation relME_4097704_Kultur_mit_MHK1_1ToMaterialEingangKultur.
When rendering the report I get following error:
Parent Columns and Child Columns don't have type-matching columns
Rendering works fine when the dynamic datasource has no relation.
I can't offer you a report to reproduce this issue. Maybe you just can analyze the xml of the report(open mrt-file in notepad++) and the log output(I've enable your logging).
In the report-file you can notice that the types of parent columns and child columns do match.
Is there a way to get extended logging information while debugging?
I tried with the new assembly and it worked. I have another report which has a same problem.
The report has a fix set of datasources from a database connection Xanthos. In addition I dynamically add a datasource ME_4097704_Kultur_mit_MHK1_1
and a report component using this datasource. The dynamic datasource also has a relation relME_4097704_Kultur_mit_MHK1_1ToMaterialEingangKultur.
When rendering the report I get following error:
Parent Columns and Child Columns don't have type-matching columns
Rendering works fine when the dynamic datasource has no relation.
I can't offer you a report to reproduce this issue. Maybe you just can analyze the xml of the report(open mrt-file in notepad++) and the log output(I've enable your logging).
In the report-file you can notice that the types of parent columns and child columns do match.
Is there a way to get extended logging information while debugging?
- Attachments
-
- mikrobefund.mrt
- Report => open it with notepad editor and not with stimulsoft designer
- (71.21 KiB) Downloaded 404 times
-
- reportlogging.log
- Logging file
- (7.78 KiB) Downloaded 239 times
Re: Parent Columns and Child Columns don't have type-matchin
Hello.
Please, check the types of the columns in the relation.
Do they have the same type in your database?
Maybe the data could not be converted to int.
Thank you.
Please, check the types of the columns in the relation.
Do they have the same type in your database?
Maybe the data could not be converted to int.
Thank you.
Re: Parent Columns and Child Columns don't have type-matchin
Hi,
I checked column types of relations and datasources and in any case datatype is System.Int32.
This can be proved in attached screenshots.
The Database is of type Oracle. In the database the columns are of type NUMBER.
I want to have more logging info while debugging. How can I achieve this?
I checked column types of relations and datasources and in any case datatype is System.Int32.
This can be proved in attached screenshots.
The Database is of type Oracle. In the database the columns are of type NUMBER.
I want to have more logging info while debugging. How can I achieve this?
- Attachments
-
- Relation
- screenshot_relationoverview.png (17.15 KiB) Viewed 5888 times
-
- Datasource ME_4097704_Kultu_mit_MHK1_1
- screenshot_datasource_ME_4097704_Kultur_mit_MHK1_1.png (10.92 KiB) Viewed 5888 times
-
- Datasource MaterialEingangKeim
- screenshot_datasource_MaterialEingangKeimKultur.png (20.92 KiB) Viewed 5888 times