Page 1 of 2

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 6:43 am
by Marcel
Hi,

I'm trying to add a relationship from datasource Product to datasource Code.
When I preview my report I receive the following exception: "Cannot add constraint to DataTable 'Product' which is a child table in two nested relations."

Anybody an idea how to solve this problem?

Thanks in advance.
Marcel

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 7:42 am
by Alex K.
Hello,

We couldn't reproduce this bug.
Please send us your .MRT file for analysis.

Thank you.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:19 am
by Marcel
I have created a basic mrt file with the problem. How can I send this to you?

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:23 am
by Alex K.
Hello,

We couldn't reproduce this bug.
Which version of Stimulsoft Reports.Net do you use?
Can you please describe your task in details? And, if possible, send us a report sample.

Thank you.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:25 am
by Marcel
I'm using version 2010.1.700.

Attached a basic .mrt file with the problem.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:42 am
by Alex K.
Hello,

Does this error occur when adding a relation or when report rendering?

Thank you.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:43 am
by Marcel
Hi,

I can add the relation without problems.
The problem occur when I try to render the report.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:45 am
by Alex K.
Hello,

Can you, please provide data for your report?

Thank you.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 8:49 am
by Marcel
I have attached a xml file to the same post as the mrt file.

Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.

Posted: Wed Aug 18, 2010 2:48 pm
by Alex K.
Hello,

Please check whether you sent us the correct data. We cannot render a report by the reason of absense of some fields which are used in relations
(Column 'Collo_Id' does not exist in Data Source 'Collo' and relation 'Collo' can't be created!)

Thank you.