Hi Bill,
As often, there are several approaches you can take to solve this.
You could use a dataset calculated field (a field that you create within the report designer) that uses an expression such as:
=switch(your_field=”Open”, “A”, your_field=”PAR”, “B”, your_field=”Closed Pending”, “C”, your_field=”Closed”, “D”)
You would then use this new field for grouping – though you would display your original field.
If you are using a final “SqlQuery” statement within your query, you could add a column using a CASE construct in order to achieve the exact same result as explained above. You would then use this new field for grouping – though you would display your original field.
Finally, your idea of using an expression instead of a field for grouping should work as well. In that case, you should be able to use the exact same expression that is written above.
Let me know if I did not clarify enough.
Regards,