[mevans5415Participant]

Is there a way to have the report auto sort in ascending order for column and row field names no matter how many are added.

Example #1
BEFORE
Payment Charge Adjustment Transfer Total
PostedDate
09/02/2020 (145.00) 200.00 (20.00) (35.00) 0.00
09/03/2020 (135.00) 250.00 (40.00) (75.00) 0.00
09/01/2020 (35.00) 100.00 (50.00) (15.00) 0.00

AFTER
Adjustment Charge Payment Transfer Total
PostedDate
09/01/2020 (50.00) 100.00 (35.00) (15.00) 0.00
09/02/2020 (20.00) 200.00 (145.00) (35.00) 0.00
09/03/2020 (40.00) 250.00 (135.00) (75.00) 0.00

Example #2
BEFORE
Payment Charge Adjustment Transfer Total
PostedDate Clinician
09/02/2020 Jim Madis (145.00) 200.00 (20.00) (35.00) 0.00
09/02/2020 Brian Scott (145.00) 200.00 (20.00) (35.00) 0.00
09/03/2020 Alex Smith (135.00) 250.00 (40.00) (75.00) 0.00
09/03/2020 Adam Mavis (135.00) 250.00 (40.00) (75.00) 0.00
09/01/2020 Trevor James (35.00) 100.00 (50.00) (15.00) 0.00
09/01/2020 Mark Edwards (35.00) 100.00 (50.00) (15.00) 0.00

AFTER
Adjustment Charge Payment Transfer Total
PostedDate Clinician
09/01/2020 Mark Edwards (50.00) 100.00 (35.00) (15.00) 0.00
09/01/2020 Trevor James (50.00) 100.00 (35.00) (15.00) 0.00
09/02/2020 Brian Scott (20.00) 200.00 (145.00) (35.00) 0.00
09/02/2020 Jim Madis (20.00) 200.00 (145.00) (35.00) 0.00
09/03/2020 Adam Mavis (40.00) 250.00 (135.00) (75.00) 0.00
09/03/2020 Alex Smith (40.00) 250.00 (135.00) (75.00) 0.00

[Author]

Posts