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.
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
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.
Thanks for the reply. My client has decided to go a different way.
That's fine, but please close this thread by marking your post as the answer.