CODEWITHSUNDEEP
sqlsortingreporting-servicesssrs-2008
CodingIsAwesome
CodingIsAwesome

Reputation: 1966

SSRS 2008 Matrix - How do I sort this simple dataset?

I have a dataset which has [Names], [Level Achieved], and [Month Achieved].

I want the result to look like:

[Month Achieved] -> Displayed across the top in order from Jan - Dec
[Names] down the left side
[Level Achieved] under each month.

Using the wizard I choose a matrix, set the columns to [Month Achieved], rows to [Name] and details to [Level Achieved]

Yet the months are being displayed unsorted. How do I sort the columns so they are in order?

Upvotes: 0

Views: 2416

Answers (1)

Jamie F
Jamie F

Reputation: 23809

After you complete the wizard, in the bottom of the Design view, you should see a pane for Column Groups. Right click on the month column group and select Group Properties.

In the resulting window you can select the Sorting section, where you can change or add the fields by which this group will be sorted. In your case, you might need to use a formula (the fx button) such as

 =SWITCH(Fields!Month_Achieved.Value = "January", 1,
         Fields!Month_Achieved.Value = "February", 2,
         Fields!Month_Achieved.Value = "March", 3,
 .
 .
 .
         Fields!Month_Achieved.Value = "December", 12)

This is if you are actually returning the Month names from your dataset and not a DateTime value for the month.

Upvotes: 2

Related Questions