I have a ssrs report that is grouped by cust#.
Each cust# totals shows on 1 line of the report.
Right now, if user wants to sort column A (total AR $), they have to wait for the report to be built then click the little Interactive sort icon.
Is there a way on a report grouped by cust# to have column A automatically sorted in ascending sequence without user having to click the column sort icon.
The report must still be built grouped by cust#, but have the report automatically be sorted by Column A (descending).