title: Crystal reports foreach loop in the formula field
body: <p>Please help me to get the count of profile Ids foreach category in crystal report formula field. </p>
  
  <p>I need to display Like : 2 people registered for Electrical Category</p>
  
  <p>This my Sql Query result in the report. </p>
  
  <pre><code>ProID    CATID      Description
  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
  </code></pre>
  
  <p>Thanks in advance</p>