Masterdata is not shown when related Detaildata is empty
I have two external datasets. Masterdata is connected to Detaildata via an ID.
The report is working but all items of Masterdata that do not have a counterpart in Detaildata are not printed in the report.
First I wonder why I do not have to tell FR which is the unique ID that connects the two datasets. In this case it is not called 'ID' but 'EqID'.
Obviously FR can find the connecting field itself?
How can I make the Detaildata work like a SQL 'left outer join', i.e. allowing to show all records of Masterdata?
Using a child band is not an option as I need multi-columns, which are not available in a child band.
The report is working but all items of Masterdata that do not have a counterpart in Detaildata are not printed in the report.
First I wonder why I do not have to tell FR which is the unique ID that connects the two datasets. In this case it is not called 'ID' but 'EqID'.
Obviously FR can find the connecting field itself?
How can I make the Detaildata work like a SQL 'left outer join', i.e. allowing to show all records of Masterdata?
Using a child band is not an option as I need multi-columns, which are not available in a child band.
Comments
How can I set a Master-Detail link between datasets?