need to get April, May, June.. in place of 1, 2, 3 4....of posting period

[Former Member]

Hi gurus

I have done a report wherein the revenues are displayed for each month of the financial year. I have selected the posting period for the respective months. In the display of the report the months are being displayed for 1, 2, 3...so on and so forth for the months starting from April to march. But the user wants the months to be displayed in April, May, june...so on.

Is there any way i can handle this.

requirement is pretty urgent.

your answers will be rewarded.

vijaykumar

[Former Member · Accepted solution]

Hi,

For every period in the column heading use a txt variable, processingtype - customer exit, not ready for input. In the exit populate necesssary text to be displayed. It will serve your requirement.

Hope this helps you.

[Former Member · Accepted solution]

Hi AVR

I have done the way you have asked me to do, but the system is asking for the month, whereas i am planning to get the months in text like april, may...to be displayed in the query.

please help me.

thanks

vijaykumar

[Former Member · Accepted solution]

Hi,

I understand...in the exit code depending upon the period entered by the user you should populate data to the text variable.

I hope you r using the text variable in the new formula. The data in the new selection is to be referred to new formula in which you will be getting texts.

Another option is maintain texts for periods in master data.

Hope this helps you.....

[Former Member · Accepted solution]

Hi,

Make sure that there is text for each period in the system(I hope we need to maintain it manually)

With rgds,

Anil Kumar Sharma.P

[Former Member]

Hi,

Just right click the calender month and Select "Display as text".

Hope this will resolve the issue.

Regards,

Tulasi

[Former Member]

Vijay Kumar,

Did you solve your problem? If not tell me I used this in my recent project. You need to create one text variable and use this variable with description of header and put youe fyv in filter section of query designer. please make sure that you have maintained the text for fyv in r/3. If you need further help write to forum i can explain in detail.

Thanks/Hari

[Former Member]

Hi Hari,

I have the same issue in my reports. Please send me step by step analysis

[Former Member]

Hi,

for getting Jan, Feb, Mar for 1, 2, 3 periods, you have to write code in customer exit variable. i am not sure about the table name, but in one table the month numbers and text will there. you can make use of that table and get the text instead of numbers.

Hope this helps.

Sathya

[Former Member]

Hi,

Question:

What you have taken in Keyfigures column?

If you have taken cumulative values you better change it to periodic values.

hope it helps