Problem with Master - Detail connection
Problem with Master - Detail connection
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.
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.
Re: Problem with Master - Detail connection
Hello,
Please send us your report for analysis.
Thank you.
Please send us your report for analysis.
Thank you.
Re: Problem with Master - Detail connection
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
Re: Problem with Master - Detail connection
Hello,
Try to set the DataRelation property for DataBand2 component.
Also please send us a test data for your report.
Thank you.
Try to set the DataRelation property for DataBand2 component.
Also please send us a test data for your report.
Thank you.
Re: Problem with Master - Detail connection
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.
NOTE: This happens in your Flash based designer and not in the Stimulsoft .Net Designer which works ok.
Re: Problem with Master - Detail connection
Hello,
Please check the last prerelease build and let us know about the result.
Thank you.
Please check the last prerelease build and let us know about the result.
Thank you.
Re: Problem with Master - Detail connection
Sorry but we downloaded the last prerelease version and does not seem to work either.
Thank you
Thank you
Re: Problem with Master - Detail connection
Hello,
Please send us your report with test data and a step-by-step guide how to reproduce the issue for analysis.
Thank you.
Please send us your report with test data and a step-by-step guide how to reproduce the issue for analysis.
Thank you.