Conditional Sorting on Report
I have two types of records that are grouped based on a numeric field called Outbound/Inbound Report Sort: if condition 1 matches then I assign number 1 and if not, I assign number 2. After that, I would like to sort all Outbound/Inbound Report Sort=1 from low to high based on a date field called Pick Up Date but also sort all Outbound/Inbound Report Sort=2 from high to low.
This is the desired result:
------------------------------
Luis Alberto Quintanar
------------------------------
This is the desired result:
------------------------------
Luis Alberto Quintanar
------------------------------
