Group Sort Order Formula for Specific Group

[littleress]

I have created a case that puts fields into groups based on types. Right now all of them are order in club #, which is fine for the main group. But I want to be able to tell it if the group is equal to X then it needs to order by type and then club # rather than just club #... is this possible??
Thanks in Advance!

 

[Madawc]

Should be. Something like

If {?TypeAlso} = "Y"
then ToText({type}) & "/" & {Club}
else {Club}

Replace {club} with @YourFormula as the group field. The 'ToText is only needed if Type is numeric.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10