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

I am working on a SQL Reporting Services Report (in VSNet 2005) which calculates a different data. There is a count on the number of subscribers in a certain set of columns. So I have many such columns: "1 Employer", "2-9 Employers", "10-19 Employers" and so on.

I have the problem that in SQL reporting services, the column matrix alphabetically, I am ending the "10-19" column after the "1 Employer" column but before "2-9"

Is there any way to fix this? Or is there a trick to sort the column labels properly?

Thank you.

We report a lot of SSRS and it was always an issue with MDX. This is a method that we do:

Set sorting in grouping and sorting properties to sort according to this expression:

= Iif (field! dataset field . Value = " columnname ", "zzz", field! dataset field . Value)

Where "zzz" can be a number or maybe you need help sorting and then the direction will appear as an ascending or ascending base on this expression. Take it.

Hope that helps something.