Master Detail Problem
I have a report with two data sets..
Left side returns 10 records.
Right side returns too many records (detail).
Example
Data Set 1 - Table A with a where clause to return 10 records
Data Set 2 - Table A no where clause, linked to Data Set 1 (master)
The above returns 10 records in both data sets no problems yet.
If in Data set 2 i then intoduce a second table TABLE B joined to TABLE
Athat will result in many more records in a standard SQL statement why is it
within the DataSet in the ReportBuilder solution I now get duplicates. I
seem to get 6 * the amount of data I should expect.
I have checked this out in IBExpert and get the correct results there...
Any pointers???
Cheers
Mark
Left side returns 10 records.
Right side returns too many records (detail).
Example
Data Set 1 - Table A with a where clause to return 10 records
Data Set 2 - Table A no where clause, linked to Data Set 1 (master)
The above returns 10 records in both data sets no problems yet.
If in Data set 2 i then intoduce a second table TABLE B joined to TABLE
Athat will result in many more records in a standard SQL statement why is it
within the DataSet in the ReportBuilder solution I now get duplicates. I
seem to get 6 * the amount of data I should expect.
I have checked this out in IBExpert and get the correct results there...
Any pointers???
Cheers
Mark
This discussion has been closed.