Problem with Master - Detail connection

Stimulsoft Reports.WEB discussion
Post Reply
klent
Posts: 13
Joined: Thu Sep 20, 2012 11:05 am

Problem with Master - Detail connection

Post by klent »

Hi.

I have a Data Set Suppliers(Master) and a second data set Invoices(Detail).
I create new relation, Parent Datasource:Suppliers, Child Datasource:Invoices.
The two data sets are connected with a common field(Supplier_id)in the Parent column and in the child column.
Then i create two DataBands in the report design,DataBand1(Master) and DataBand2(Detail).
In the 'master component' property of the DataBand2 i set the DataBand1 but the 'data relation' property is not assigned.
My actual data are 2 Suppliers, the first has 3 invoices and the second has 10 invoices.
But when i run the report i get the name of first supplier with 13 invoices and the second supplier with 13 invoices as well.
Please tell me what I do wrong.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem with Master - Detail connection

Post by Alex K. »

Hello,

Please send us your report for analysis.

Thank you.
klent
Posts: 13
Joined: Thu Sep 20, 2012 11:05 am

Re: Problem with Master - Detail connection

Post by klent »

Ok I attach the Test.mrt file. Note that the field relating the two datasources is SYNAL_CODE.
Attachments
TestReport.mrt
(20.22 KiB) Downloaded 202 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem with Master - Detail connection

Post by Alex K. »

Hello,

Try to set the DataRelation property for DataBand2 component.
Also please send us a test data for your report.

Thank you.
klent
Posts: 13
Joined: Thu Sep 20, 2012 11:05 am

Re: Problem with Master - Detail connection

Post by klent »

When I try to set the 'Data Relation' property of Databand2 , the 'Data Source' property of Databand2 looses its asignment. When I reassign the 'Data Source' property of Databand2 , i click to somewhere else in the designer , when I click back to Databand2 the 'Data Relation' of Databand2 is lost.

NOTE: This happens in your Flash based designer and not in the Stimulsoft .Net Designer which works ok.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem with Master - Detail connection

Post by Alex K. »

Hello,

Please check the last prerelease build and let us know about the result.

Thank you.
klent
Posts: 13
Joined: Thu Sep 20, 2012 11:05 am

Re: Problem with Master - Detail connection

Post by klent »

Sorry but we downloaded the last prerelease version and does not seem to work either.

Thank you
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem with Master - Detail connection

Post by Alex K. »

Hello,

Please send us your report with test data and a step-by-step guide how to reproduce the issue for analysis.

Thank you.
Post Reply