I still have an issue sorting the months. I have changed the (Oracle) conversion of months to ‘Month’ 09=>‘September’. Now in the Custom sort list there is
AUGUST
SEPTEMBER
OCTOBER
NOVEMEBER
August
September
October
November
How do I get rid of the all caps version? Removing the sorting and applying doesn’t help. There is no LOV in the Universe. In the result there are no uppercase months anymore. So I guess BO ‘remembers’ somehow in the document the list of values. Is there a possibility to remove it completely?
I tried posting this reply some time ago, but for some reason my message kept bouncing back to me…
what I suggested was the following: why don’t you use an alerter to convert the month numbers to text ? sorting on the month will still use the original, numeric value.
however, since you chose to convert the numbers to text on another level, you may want to ignore the above. to get rid of the all-caps strings, I would try to purge the report via the data manager, then run it again.
I still have an issue sorting the months. I have changed the (Oracle) conversion of months to ‘Month’ 09=>‘September’. Now in the Custom sort list there is
AUGUST
SEPTEMBER
OCTOBER
NOVEMEBER
August
September
October
November
How do I get rid of the all caps version? Removing the sorting and applying doesn’t help. There is no LOV in the Universe. In the result there are no uppercase months anymore. So I guess BO ‘remembers’ somehow in the document the list of values. Is there a possibility to remove it completely?
I am unclear from your description about the origin of the uppercase. Not sure if it’s as simple as refreshing the LOV file to get rid of these uppercase months…
If you still had uppercase values in the database, you could try using the Initcap() funcion of Oracle to convert the uppercase months so that they capitalize the first character only…
Javed Maqsood
I still have an issue sorting the months. I have changed the (Oracle) conversion of months to ‘Month’ 09=>‘September’. Now in the Custom sort list there is
AUGUST
SEPTEMBER
OCTOBER
NOVEMEBER
August
September
October
November
How do I get rid of the all caps version? Removing the sorting and applying doesn’t help. There is no LOV in the Universe. In the result there are no uppercase months anymore. So I guess BO ‘remembers’ somehow in the document the list of values. Is there a possibility to remove it completely?
When specifying a month sort BO doesn’t put the months in the right order. I assumed that was becasue of the all uppercase of the months. I used the to_char function with ‘MONTH’ insteda of ‘Month’. So in the Univers I switch ed to useing ‘Month’. Now, however, the reporter displayes not only September but also SEPTEMBER when editing the sort. When I select Months from the Custom sort the months appear in any order but not chronologically. I therefore had to swithc to a manual specifed sortorder. Now ofcourse I will not be bothered with the all uppercase items, as they are not there anymore.
Q: how to get rid of the superflouos items in the sort list?
hans
Hans,
I am unclear from your description about the origin of the uppercase. Not
sure if it’s as simple as refreshing the LOV file to get rid of these uppercase months…
I still have an issue sorting the months. I have changed the
(Oracle)
conversion of months to ‘Month’ 09=>‘September’. Now in the Custom
sort
list there is
AUGUST
SEPTEMBER
OCTOBER
NOVEMEBER
August
September
October
November