Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Count Child Records Post Reply Post New Topic
Author Message
9727604
Newbie
Newbie


Joined: 23 Feb 2011
Online Status: Offline
Posts: 1
Quote 9727604 Replybullet Topic: Count Child Records
    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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.