Problem with Master - Detail connection
Posted: Thu Sep 20, 2012 11:35 am
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.