Sage 100

Does anybody know if there is a way to conditionally group in Crystal? For example, based upon the value of a string parameter, group the report on Item Number vs Customer Number. I thought there was an easy way, but it's not apparent to me, since I can't seem to group based upon the value of a formula.

Oops, asked too soon. Figured it out.

care to share the answer?

I used a parameter with value selections of ""Customer number"" and ""Item Number"". Then made a formula that equaled either CustomerNo or ItemCode, based upon the value of the parameter. Just used if, then, else. Then just used the ""custom"" group and selected my formula as the group by field.

Sorry, correction. In Group Expert, I clicked on the Options button and it allowed me to group on the formula.