Mater-Detail with missing detail items
Posted: 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?
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?