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

[simgschw]

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?

[Alex K.]

Hello,

We couldn't reproduce this bug.
Please check the last version.

Thank you.

[simgschw]

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.

[HighAley]

Hello.

You create a relation on SupplierID and CategoryID. But there is no record with CategoryID=1 and SupplierID=5.

Thank you.

[simgschw]

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.

[HighAley]

Hello.

We have reproduced the issue.
We need some time for analyzing.
We will keep in touch with any news.

Thank you.

[HighAley]

Hello.

We have made an improvement.
It will be available in our next prerelease build that will be available today later.

Thank you.

[simgschw]

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?

[HighAley]

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.

[simgschw]

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?