how to display date in the text format in reports

[Former Member]

Hi Experts,

I want to show date as text in the reports. Ex. instead of 01.2009 i want JAN 2009.

What steps i must take to correct this?

Thanks in advance!!!

Regards,

Niranjan Chechani

[Former Member]

Hi,

if i got your question correct you want to see the date in text format JAN 2012 rather than 01.2012 in data part.

if yes then please enforce the 0calmonth to display Name insted of Key.

how to do it.

- Query designer --> Query --> 0Calmonth --> properties --> Display properties --> Display As "Text"

or in the report right click on 0calmonth column and choose 'calmonth/year' --> Display as --> Name.

in case you want to have the entries in 0calmonth as column headers please use a text variable with replacement path. most of the answers given above would fullfill your need.

Regards,

A Prashant Kiran

[jagadeesh_mandepudi2]

Hi

You can achive this by using Text Variable with Replacement path using variable i.e. if you want to display column headers with dynamically changing time char then go to keyfigure properties description area there you can create Text variable with replacement of calmonth.

Jagadeesh

[Former Member]

Hi,

You can use Text Variable to display the calmonth in text. Use replacement path to populate the value

[vinay_lohakare5]

Hi,

Please check the below link:

http://scn.sap.com/thread/1978626

http://scn.sap.com/thread/2123850

I hope it helps you.

Thanks,

Vinay.

[Former Member]

HI Niranjan,

You can achieve this by Creating Text Variable.Create RKF with Calmonth and restrict with Variable i.e current month or previous month.Then Create local formula use the RKF and create Text Variable with replacement Path and Reference Char as Calmonth and Replace Variable with Infoobject and Replace with lable.You will get desired Display.

Thanks

Tarak