Menu
In the table or matrix, click the column headings you want to sort. You see an up or down arrow next to the heading showing that the field is sorted in ascending or descending order. Click the arrow to reverse the sort order. You can sort text, numbers, dates, and times.
You need to create a sort column and then use 'Modeling' / 'Sort by Column'. Make sure 'Alias Sort' is a whole number. Then highlight 'Alias' and go to Modeling / Sort by Column and choose Alias Sort. You matrix should sort in a descending manner.
The order of the matrix is defined as the number of rows and columns. The entries are the numbers in the matrix and each number is known as an element. The plural of the matrix is matrices.
I'm working on a SQL Reporting Services report (in VS.Net 2005) which displays a count of different data in a matrix. The columns have a count on the amount of customers in a certain set. So I have several columns like these: "1 employer", "2-9 employers", "10-19 employers" and so on.
The problem I have is that SQL Reporting Services sorts the columns in the matrix alphabetically. So I end up having the "10-19" column after the "1 employer" column but before the "2-9".
Is there any way to fix this? Or maybe a trick to change the labels of the columns to that they sort right?
Thanks.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With