Month Names display order incorrect in reports (using Cube data)

• sugaz007

  Old Hand

  Points: 310

  More actions

  October 23, 2009 at 2:06 pm

  #212879

  Hi,

  I have created a simple report connecting to an analysis services cube.

  The report displays month names & sales information for each month. In the cube the month names display in correct order i.e jan, feb, mar....dec

  But in the report it display in alphabetical order.

  Any idea how to correct it?

  I can add a calculated column in the dataset for the month number.

  Thanks

  Suga

• GSquared

  SSC Guru

  Points: 260824

  More actions

  October 23, 2009 at 2:29 pm

  #1070257

  You'll need a numeric column for the month number and have the report sort on that.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon