Group on multiple fields
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. :)