Combine groups into one group

[Cozmo2]

I have a report that groups by program code. The values in program code are Undergrad, UndergradTr, UndergradIntl.

I want the Undergrad in one group and all the rest in a different group.

Any thoughts?

[EddieLotter]

As always, I recommend doing the heavy lifting on the database side so that the report gets a simple result set to work with.

In Microsoft's TSQL you can accomplish this as follows:

SELECT programcode, CASE WHEN ((programcode = 'UndergradTr') OR (programcode = 'UndergradIntl')) THEN 'UndergradOther' ELSE programcode END AS GroupingProgramCode

FROM programs

GROUP BY CASE WHEN ((programcode = 'UndergradTr') OR (programcode = 'UndergradIntl')) THEN 'UndergradOther' ELSE programcode END

This will produce a result set with only two groups, as long as program code only has the three values you mentioned.

Note that I include the original program code in case you need to display the actual value somewhere in the report.

[Cozmo2 · Accepted solution]

Thanks for the reply. My client has decided to go a different way.

[EddieLotter]

That's fine, but please close this thread by marking your post as the answer.