Page 1 of 1

Mater-Detail with missing detail items

Posted: Sun Feb 04, 2007 9:08 pm
by remus
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?

Mater-Detail with missing detail items

Posted: Mon Feb 05, 2007 2:55 am
by Brendan
I believe you need to set the "Print if Detail Empty" property on the Detail Band that contains the Contact information.

Mater-Detail with missing detail items

Posted: Mon Feb 05, 2007 5:53 am
by Mark Smith
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.




Mater-Detail with missing detail items

Posted: Fri Feb 09, 2007 4:02 am
by Edward
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.