Combine groups into one group

Question

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?

Cozmo2 · Accepted Answer

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

EddieLotter · Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.