Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to specify an order for the columns in a matrix?

Tags:

People also ask

How do you arrange Data in a matrix table?

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.

How do you sort a matrix by a column in descending order?

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.

What is an order of a matrix?

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.