Tell me more ×  My stored procedure returns a result set like
this.  enter image description here  I am using a Matrix Control
in a RDLC Report. So the report looks like this.  enter image
description here  You can see the month is not staring from Jan
in the report. I would like to display the Columns as in the
order of JAN,FEB,MAR.....etc. Can any one help me out with this?
share|improve this question add comment  2 Answers  Set Sorting
in the Grouping and Sorting Properties to sort by this
expression:  =iif(Fields!DataSetField.Value = "ColumnName",
"zzz", Fields!DataSetField.Value)  Where "zzz" could be a number
or whatever you need it to be to help the sort and then select
Direction as either Ascending or Descending base on this
expression.  share|improve this answer add comment   1. you
could modify your store procedure to also resulting month as 1 -
12   2. or maybe add a calculate field that result 1 iif months
== "jan" and so on...  then you can specified sort by (the new
integer tipe field) at colom