Masterdata is not shown when related Detaildata is empty

stewag25

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.

gpi

wrote:

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?

You should set Master-Detail link between datasets

wrote:

How can I make the Detaildata work like a SQL 'left outer join', i.e. allowing to show all records of Masterdata?

MasterData1.PrintIfDetailEmpty = True

stewag25

MasterData1.PrintIfDetailEmpty = True works, thank you.

How can I set a Master-Detail link between datasets?

gpi

wrote:

How can I set a Master-Detail link between datasets?

Google "Delphi master detail"