Master Detail Bands with LEFT JOIN
Hi
How can I create a master detail band using a left join link?
An example.
The master object has 2 records. For the first record exist in the Object Detail 2 records. For the second master record, there are no records in the detail object.
With the MasterFields Property.
With the Master Fields property, only the first master record with the detail records will appear. The 2nd Master data is not displayed.
How do I solve this problem?
Best Regards Ren?©
How can I create a master detail band using a left join link?
An example.
The master object has 2 records. For the first record exist in the Object Detail 2 records. For the second master record, there are no records in the detail object.
With the MasterFields Property.
With the Master Fields property, only the first master record with the detail records will appear. The 2nd Master data is not displayed.
How do I solve this problem?
Best Regards Ren?©
Comments
bands have no relation to joins they are only place holders on the design page
the control the movement through the records of the dataset to which they are connected or
to the rowcount prop setting(no dataset).
and the names master and detail subdetail should be considered as data of level1, level2,level3
and so on.
master rec1
detail1 for masterec1
all subdetails for detail1
detail2 for master1
Or are you asking about how to connect internal queries or tables together.
I've probably used the wrong names. Sorry.
I use a TfrxADOQuery and TfrxADOTable. In Page1 TfrxADOQuery is linked MasterData1 and TfrxADOTable with DetailData1.
In TfrxADOTable I created the property MasterFields with the index fields Tabelfield1 = Tabelfield2.
My problem is that this combination represents a 1:1 relation.
However, to display all the data, I need a left join field link.
How can I represent a left join in FastReport?
About the property "Master Fields" this is not possible.
Thanks for your help