cancel
Showing results for 
Search instead for 
Did you mean: 

converting 0calday to get month values - Jan,Feb,March etc

Former Member
0 Kudos

In my bex report , i want to display the months from 0calmonth or 0monyear object.

I have values like 012205,02225 etc..And i want values like Jan,Feb...

I have tried by using characteristics but the values are not in correct sorting..

I have uploaded jan,feb,march..etc but when i view in report it shows april,augutst..in alphabetical

ascending order or descending order like July, June...

Please suggest me which object should I use to get out as months Jan,feb,march..etc..from my value..

There is no constraints that I should use only 0calday or another objects...

My report should display for this year 2005 for this month Jan,Feb...... These are production report values...

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sid,

You may just create a structure in rows giving the month names to selections.

Best regards,

Eugene

0 Kudos

hi,

not sure understand your question correctly,

try in bex query designer, right click '0calmonth',

display as = 'text' ?

hope this helps.

Former Member
0 Kudos

Hi,

Thanks for your reply.

I will explain in detail.

I want to display prodution values for every month for a year.

I want the month values like Jan,Feb,Mar,April to be in row and production values in column.

But i have values like 10/01/2005,01/02/2005 etc.From this dates i have to extract the month values like jan,feb etc..

Regards,

sid

former_member188325
Active Contributor
0 Kudos

hi,

do you have 0calmonth in your query?

thanks

Former Member
0 Kudos

Hi,

Yes I have have 0calmonth in my query..

Regards,

Sid

former_member188325
Active Contributor
0 Kudos

Hi,

then try this out:

Drag and drop 0CALMONTH into rows.remove 0CALDAY from Query designer...

go to properties of 0CALMONTH--->set 'display' as Text..

execute the Query..

Thats what you are looking for?

thanks