I am trying to create a report that will list all the parts that belong to a customer, but it's only showing 1 item per customer. Is there a way to specify the join type. i would like to use a right outer join so it will show all the items by a customer.
My master table is "Customer" and my Detail table is "CartInformation" with a linked field by CustomerName. I think its similar to Danny's Report Guru Webinar, but its not giving all the information.
Thanks in advance