I'm working on a report for health benefit deductions in Crystal Reports 2011, grabbing fields from SQL views. The view I'm stuck on, is called emp_groups.group_code. Here's a screenshot of the fields in the view.


What I want to do, is create a formula that grabs all the groups the employee is in from this view(they can be enrolled in 1 up to all of the groups. And then put it in my report. I'm a Crystal Syntax newbie and thought a select statement would work, but it only grabs the first group someone is enrolled in. (ie: a person may be enrolled in LUNLRN,PHYEX,&WGHTLOSS but only LUNLRN shows up for me after this select statement)

select {emp_groups.group_code}
   Case "COACHEDU":
      "Coach"
   Case "HRA":
      "HRA2012"
   Case "LUNLRN":
      "Lunch&Learn"
   Case "PHYSICAL":
      "Phyiscal"
   Case "PHYEX":
      "Exercise"
   Case "WGHTLOSS":
      "WeightLoss"
   Default :
      "";

any help is appreciated, thanks! :)

I tried the code lockwelle provided, but it still just pulls the very first item from the table that the person is enrolled in.

Appreciate the help

Edited by bullsfan03 - 25 Jul 2012 at 2:03pm

I was thinking that this would be in the Details section and that all of the groups would be available.  I didn't reset as the group string just because primarily I forgot...I was thinking to just provide syntax for the immediate question.