Print Page | Close Window

Count Child Records Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12412 Printed Date: 28 Apr 2024 at 5:35pm Topic: Count Child Records Posted By: 9727604 Subject: Count Child Records Date Posted: 23 Feb 2011 at 6:06am Hi, I'm pretty new to Crystal Reports and I need some help on what I believe should be a basic enough report. I'm using Crystal through VS 2010. I have a MySql db which i can connect to. I basically need a report to display the number of interns hired in 3 different internship programs and then display a total of the 3 programs. I have a host table and the primary key is a foreign key in an internship table and each internship record has a program discriminitor column to determine the program. So all I need is to display the number of internships per program per host in a given period. The report headers would be as follows Host Name      Program 1 Total    Program 2 Total      Program 3 Total     Total I just cant figure out what CR functionality to use to get a total of child records in a DB. Any help is greatly appreciated

Print Page | Close Window