Month Year sorting

building reports desktopintelligence
1

I created report with below fields

Month-Year | failed ratio | accpted ratio

report sorts alphabetically for month but my requirement is to sort it month wise like Jan-2009, feb-2009

is there any best way to do it, i tried custom sort but this report get generated for last 12 month every month.

regards

sachin

sachinonnet (BOB member since 2008-10-03)

2

Hi Sachin,

I think custom sort is the only proper option.
As far as I am aware you can type manual values as well (even if they don’t exist in the database)

Or you could create a formula that concatenates number of month and year i.e. 01-2008 / 02-2008 / 01-2009
After this is done you can sort by the this column and make it “invisible”.

Regards
Rim

rimgeurts (BOB member since 2007-06-18)

3

Hi Sachin,
Rim is right. But just one change in the suggestion, instead of arranging the field as MM-YYYY try using YYYY-MM. The reason being if you use it exactly as Rim suggested, the 01-2009 will be before 12-2008 in case it gets sorted alphabetically. If you use a Date type variable then it should work fine. But otherwise, just use the YYYY-MM format and you dont have to worry about whether it uses character sort or date sort.
Also I’m sure you’re aware that if you are using WebI then it will not be possible for you to hide the column directly. So you will need to minimize the column width and match the font color with the background in order to make it invisible.

Regards,
Ashish K.

ashishk :india: (BOB member since 2005-03-10)

4

Also you can check this.

aniketp :uk: (BOB member since 2007-10-05)