How to sort SQL Server Report Builder Matrix Descending?

1
votes

I have a report with the following columns:

  • Machine
  • Shift
  • Reason
  • MinutesDown

My sql statement for the datasource sorts by shift descending. In the Query Designer I get results sorted as I would expect. When I insert a matrix (see images below) the shifts are not sorted descending. How do I manipulate my report to put the shifts in the order that I would like them to appear ?

Matrix Wizard

enter image description here

1
reporting-servicesssrs-2008report-builder2.0

1 Answers

1
votes

Once you have created the matrix, bring up the Shift row group properties, something like:

enter image description here

In the Group Properties, set the sorting as Z to A:

enter image description here