Crystal reports foreach loop in the formula field
===

Please help me to get the count of profile Ids foreach category in crystal report formula field. 

I need to display Like : 2 people registered for Electrical Category

This my Sql Query result in the report. 
ProID  CATID    Desc
1	2	Inspection
1	4	Fabric Maintenance
1	6	Electrical
1	10	General Qualifications
3	6	Electrical
3	10	General Qualifications
4	1	QA /QC Vendor Inspection
6	1	QA /QC Vendor Inspection
11	1	QA /QC Vendor Inspection
12	1	QA /QC Vendor Inspection
12	2	Inspection
12	3	Coatings Inspection
12	10	General Qualifications

Thanks in advance