Skip to Main Content

IR

YearAscendingN 10N 10 P FmtN 20N 20 P FmtN 30N 30 P FmtNN P Fmt
19800
1
0
0%
1
0
100
0
19812
2
6
60%
10
20
20
60
19821
1
0
0%
2
50
50
0
19830
1
0
0%
1
0
100
0

Info

An extension of the standard Apex Reports column formatting functionality "Graphical formatting for percentages, whole numbers between 0 and 100" (i.e. percentage bars). More info by Martin D'Souza on the standard Apex functionality: http://www.talkapex.com/2009/06/displaying-percentage-bar-in-apex/

The package used here adds the option to show more than 1 percentage per bar in a column, and also adds options for custom CSS formatting.
At the suggestion of Nguyen Thanh Tu, I have added the option to add a text label inside the bar.

In the example above, the columns are formatted as follows:
  • N 10 P : Standard number formatting for percentage bars (PCT_GRAPH:cccccc:ff0000:150)
  • N 20 P Fmt : Uses the new function to mimick the standard formatting
  • N 30 P Fmt : Uses the new function to showcase some fancy (and rather hideous, in this case...) formatting, and shows the text label option
  • N P Fmt: Uses the new function to combine the other 3 peecentages into 1 bar, and shows the text label option per percentage
Note:
This works fine for Apex version 4.2 through 19.2. Older/newer versions may use slightly different classes and css to format the divs. Study the html produced by Apex and change the package accordingly.

Code

Page

Name
Page ID
Name

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source

Package

Package
Name
Source

Package Body

Package Body
Name
Source