CODEWITHSUNDEEP
ssrs-2008reportingservices-2005reporting-servicesssrs-grouping
Ritesh
Ritesh

Reputation: 401

Can not sort month-year column?

I have a date column. I created Month-Year column in my report using the following expression, but I am not able to sort month-year wise.

=MonthName(Month(Fields!new_sitevisiteddateutc.Value))& "-"& Year(Fields!new_sitevisiteddateutc.Value)

I would like to have MAY-2009 JUNE-2009 JANUARY-2011 MARCH-2011, however I am getting JUNE-2009 MARCH-2011 MAY-2009 JANUARY-2011.

Can someone help me with this?

Upvotes: 1

Views: 2895

Answers (1)

benni_mac_b
benni_mac_b

Reputation: 8877

In the table properties you can add multiple sorting fields and thier order.

Sort by year first and then month.

  1. =Year(Fields!new_sitevisiteddateutc.Value)
  2. =Month(Fields!new_sitevisiteddateutc.Value)

enter image description here

Upvotes: 3

Related Questions