For example, if we are grouping on {StsSt_CurrentStatus} and we want to combine all Status values that begin with C into a Current Student group, we can use one of the two solutions below:
  1. Use Group Options on the {StsSt_CurrentStatus} group
    1.  Right-click on the Group Header section for {StsSt_CurrentStatus} and select Change Group
    2.  From the second drop down, select "in specified order"
    3.  On the Specified Order tab, click the New button
    4.  In the Group Name box enter "Current Student"
    5.  In the drop down on the left, select "Starts With"
    6.  In the box on the right, enter "C"
    7.  Click Add
    8.  Click OK
    9.  Go to the Others tab
    10.  Select the "leave others in their own groups" option
    11.  Click OK
    12.  Refresh the report

  • Use a formula as the group field
    1.  From the Field Explorer, right-click on Formula Fields and select New
    2.  Enter a name for the student, such as "Student Status", and click OK
    3.  Enter the formula:
        if {StsSt_CurrentStatus} startswith "C" then "Current Student" else {StsSt_CurrentStatus}
    4.  Click Save and Close
    5.  Right-click on the Group Header section for {StsSt_CurrentStatus} and select Change Group
    6.  From the first drop down, select the new formula field created above
    7.  Click OK
    8.  Refresh the report