I have two tables, lets say for example "Customers" and "Orders".
The relation between these tables are the primary "ID" field in Customers with "CustID" in Orders.
What i want to know is how do i generate a report to display the Customer details then underneath all that customers orders. Then the next customer and his orders.
Also to show Customer even if they don't have any orders.
I use ADO.net database connection in crystal where i load a schema file. I have 2 tables added to the report which are customers and orders.