Skip to Content
0
May 18, 2016 at 09:14 PM

Conditional sorting

261 Views

Hello,

I have a Crystal Report that accepts an incoming parameter indicating how the report should be sorted. If the parameter comes in as "company", then the report needs to be sorted A-Z by company, with page breaks after each individual company. If the parameter comes in as "revenue", then the report needs to sort by revenue in descending order instead of sorting/grouping by company.

My first thought was to create a formula to serve as a group, by which I could sort my results. If the parameter came back as "company", the grouping value would be the Company field, otherwise, it would be the Revenue. The problem seems to be that I can't have one sort in ascending order while the other sorts in descending order, at least from the Record Sort expert.

Any ideas on how I might accomplish this?

Thanks!