troubleshooting Question

Generate a Crystal Report multiple related tables

Avatar of DeonM
DeonM asked on
Crystal Reports.NET Programming
2 Comments1 Solution531 ViewsLast Modified:
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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros