I currently have a report where data pulls from a table labeled clients for things such as patient name, address, etc. However, I would also like to get a count of orders that the client has made. These orders are stored in a separate table and not counted, but linked by a client id number. My question is how could i get a count of the number of order rows in a separate table for each client.
Crystal Reports 2008, SQL Server 2005
November 5, 2009 5:36 PM
November 5, 2009 8:16 PM