DeonM
asked on
Generate a Crystal Report multiple related tables
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.
Thanks
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER