Master/Details Doesn't Do Left Outer Join

Sandy Pham · Post by **Sandy Pham** » Tue Jul 08, 2008 4:35 pm

My master/detail report only shows the rows for master records that have detail records. In other words, the master/detail seems to only do a JOIN when it should do a LEFT OUTER JOIN. How can I make master records without detail records show on the report?

Brendan · Post by **Brendan** » Tue Jul 08, 2008 5:30 pm

Hi Sandy,

You need to set the "Print If Detail Empty" property to true on your Master Databand if the master band has no related child records but you still need to show the master record. I think it's false by default