Sorting on nongrouping filed

[bouser69]

Hi there

Could any one please help me. I do have this situation.
I grouped on 5 fields but wanted to sort on another field. This non grouping field is non measure object. How could I do sort on this field even grouping on 5 fields?

I am using Crystal XI. Thanks in advance

 

[lbass]

Groups always take precedence over sort fields, so you would either have to insert a group on the field you want to sort by and then make it your group #1, or possible use a group sort based on a summary of this field (maybe a maximum if a string). It would be easier to respond if we could see a sample of your data.

-LB

 

[bouser69]

Thanks lbass

It worked with the function Maximum