Is it possible in CR to group on multiple fields? I want a new group header when ever either of two different fields changes. My Primary Key consists of two fields (Order Number and Client, since different Clients could have the same Order Number).

When I insert a new group, it only allows me to pick one field to group on. If I have to, I'll add a calculated field that combines the two fields and group on that, but that sounds like a kludge to me. I'd rather do it the "right" way before I try to force it to work. :)

-----
leep

USE HIDE COLUMN - IDENTITY FIELD EXAMPLE

Create formula field, which will contain those two fields together and create a group by that formula field. I guess this is the right way to resolve this problem.

Vadim