Mater-Detail with missing detail items

remus · Post by **remus** » Sun Feb 04, 2007 9:08 pm

I have successfully created a master-detail report using you examples.
However, your example with the beverages assumes that all beverages are in a category.

The data I have is in 2 tables Customers and CustomerContacts
THere are 300 Customers in the Customer table. However only some of those customers have additional Contact records in the CustomerContact table.

I am trying to create a Customer List report which shows all 300 customers (in the Master Band) and then list all the contacts associated with that customer in the Detail Band.

When I run the report it only lists the customers that have associated records in the contact table. Any customers that do not have any contact information in the contact table are being filtered out by the relation between the 2 datasources.

What am I doing wrong? What type of report should I be creating to solve my problem: Master-Detail, Sub-report, or Heirarical?

Brendan · Post by **Brendan** » Mon Feb 05, 2007 2:55 am

I believe you need to set the "Print if Detail Empty" property on the Detail Band that contains the Contact information.

Mark Smith · Post by **Mark Smith** » Mon Feb 05, 2007 5:53 am

It's the way the behaviour of the master band changes just because a detail band is present.

This catches my users out almost 100% of the time, so I changed the default to True.

Post by **Edward** » Fri Feb 09, 2007 4:02 am

Mark wrote:It's the way the behaviour of the master band changes just because a detail band is present.

This catches my users out almost 100% of the time, so I changed the default to True.

We've changed the default value of the PrintIfDetailEmpty to True.

Thank you.