on 05-22-2006 7:30 AM
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...
Hi Sid,
You may just create a structure in rows giving the month names to selections.
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
not sure understand your question correctly,
try in bex query designer, right click '0calmonth',
display as = 'text' ?
hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.