I think this is simple, but...
Main report: CustomersDB as record source
SubReport: OrdersDB as record source
Linked fields: CustomerID
Everything works as expected except the report displays all the customers from CustomerDB even if they do not have any orders.
How do I filter the report so that only customers with orders will print. Also, what about filtering on orderdate?
Many thanks,
John