Thursday, May 25, 2017

Sorting report data

  • Bind the data set to the report.

  • Add the data to a matrix.

  • Result would be like below. It shows the month names in alphabetical order. But the month names should be in month order.

  • For resolve this, add a new field to the data set as "MonthSort". And set the expression for that field as below.

  • Sort the "Month" field by "MonthSort".



  • Then the result will be like this.