Sorting Records before a group

[JanCampbell]

I am using Crystal 8.5 to report from a Pivotal database.

I am grouping my report by COMPANY.companyid but want to see the records in alphabetical order of company name, not ascending order of company id. Is this possible?

Thanks
Janice

 

[JanCampbell]

A colleague has resolved this for me as follows:

Insert a summary on company name (eg. Maximum) for the companyid group
Use the TopN function to return ALL records.

This worked.