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