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

Stimulsoft Reports.NET discussion
Marcel
Posts: 6
Joined: Wed Aug 18, 2010 6:36 am
Location: The Netherlands

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

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post by Alex K. »

Hello,

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

Thank you.
Marcel
Posts: 6
Joined: Wed Aug 18, 2010 6:36 am
Location: The Netherlands

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

Post by Marcel »

I have created a basic mrt file with the problem. How can I send this to you?
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post 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.
Marcel
Posts: 6
Joined: Wed Aug 18, 2010 6:36 am
Location: The Netherlands

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

Post by Marcel »

I'm using version 2010.1.700.

Attached a basic .mrt file with the problem.
Attachments
553.Order.xml
(6.82 KiB) Downloaded 494 times
552.Order.mrt
(109.03 KiB) Downloaded 555 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post by Alex K. »

Hello,

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

Thank you.
Marcel
Posts: 6
Joined: Wed Aug 18, 2010 6:36 am
Location: The Netherlands

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

Post by Marcel »

Hi,

I can add the relation without problems.
The problem occur when I try to render the report.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post by Alex K. »

Hello,

Can you, please provide data for your report?

Thank you.
Marcel
Posts: 6
Joined: Wed Aug 18, 2010 6:36 am
Location: The Netherlands

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

Post by Marcel »

I have attached a xml file to the same post as the mrt file.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post 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.
Post Reply