The sort order for a month data item might not sort correctly in certain situations. The problem is most likely to occur if the data item that represents the month is a date value that is formatted with the MONNAME format. When this data item is used in a crosstabulation table with an applied filter, the order is not always predictable.

In the following example, the results have been filtered to show results after the date 01MAY08. Notice that the months in 2009 are sorted incorrectly. Specifically, the months of January, February, March, April, and May appear after December.

One workaround to this problem is to create another data item using the MONTH(mydate) expression, where mydate is the name of your data item. The result of the expression is a number representing the month. In order to get the month name, you can apply a user-defined format to the data item. Below is an example of what the user-defined format named mon would look like:

Operating System and Release Information