I was recently developing an Oracle Apex 4 application with charts and found that the chart legend was always shown as uppercase text regardless of what was in the chart settings.
In Oracle Apex 3.1 all chart legends were converted to inital capitals so regardless of what text was entered the legend text always showed the first letter in capitals and the rest lower case. This behaviour was changed in APex 4 so I was surprised to find that all the legends were showing as upper case in this APex 4 application when the text entered was a mix of lower and upper case.
Fortunately this was a simple one to fix and the answer was that the text was not enclosed in double quotes. As soon as this was done the legend text for the Apex Chart was displayed correctly as mixed case rather than all upper case.
select null,
to_char(created_date,'MM-YY') Date,
sum(decode(TYPE,'SERVICE', 1,0)) Service ,
sum(decode(TYPE,'MAIN', 1,0)) Main
Showed on the chart legend as SERVICE, MAIN but the code below showed correctly.
select null,
to_char(created_date,'MM-YY') "Date",
sum(decode(TYPE,'SERVICE', 1,0)) "Service" ,
sum(decode(TYPE,'MAIN', 1,0)) "Main"
Shows legend as required as Service and Main
Musings, tips and hints about computing, mobile phones and general technology comments. Help and advice about the latest virus and malware as well as ways to avoid Trojans that will steal your online banking details. As soon as we spot a new scam/virus email then we post it here to warn others about them.
Showing posts with label apex uppercase legend chart text. Show all posts
Showing posts with label apex uppercase legend chart text. Show all posts
Monday, 11 November 2013
Subscribe to:
Posts (Atom)