CODEWITHSUNDEEP
reporting-servicesssrs-2008report-builder2.0
Bill Greer
Bill Greer

Reputation: 3156

How to sort SQL Server Report Builder Matrix Descending?

I have a report with the following columns:

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

Upvotes: 1

Views: 2069

Answers (1)

Ian Preston
Ian Preston

Reputation: 39566

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

Upvotes: 1

Related Questions