Crystal Reports: Customize Group Name

This is one of the features of version 8 (and later) that we’ve found very useful. You can group by a field, but display a different value in the Group Name and Group Tree. For example, group your orders by Customer Code, but display the Customer Name in the heading.

Yes, you could always do this with a formula, but the nice thing version 8 (and higher) does is to display the customized group name in the group tree. The other place this is really useful is in a cross-tab report, where you can display a custom value in the row or column heading.

You can use a field from your database or write a complex formula to calculate the string you’d like to display. It could even be the original field, just displayed with a different format.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.