I have a report that has a paramter called Event Type that is passed in. Depending on the event type, I want to sort the records by different columns. The Columns are Occurrences, Duration, Average Duration. For example, a Work Event should be sorted by Average Duration, a Downtime Event should be sorted by Duration, and an Exception Event should be sorted by Occurrences.
Is there a way to do this inside Crystal Reports or with a formula?
Please let me know.