Bi-level grouping

[workuser]

Is it possible to have a footer in a reprot group by two fields simultaneously?



I have a reprot with order date, order id, name, id, and product. I have a subrepot that lists various details about the orders. I would like to connect these reports by the order id. However, since an order can contain multiple products I cannot simply group on the order id but need to have the product included as well. From what I can see I can have multiple groupings but can not group by more than one field on the same level.

[June7]

Can be done by concatenating the two fields to construct a value to group on.

[workuser]

Yay!! This totally answered my question.