Wednesday, 16 December 2015

Progress Bar in Reports in APEX5

APEX can create "Percentage Bars" within a report. This can be achieved using HTML Code in your Report SQL Query.

Steps:

1- Create your report:


Create an Interactive or Classic Report using SQL query :

SELECT CASE
          WHEN COLUMN <= 30
             THEN    '<div class="a-Report-percentChart" style="background-color:#000000;width:100%;"><div class="a-Report-percentChart-fill" style="width:'
                  || COLUMN
                  || '% ; background-color: 330099;"></div><span class="u-VisuallyHidden">'
                  || COLUMN
                  || '</span></div>'
                  || COLUMN
                  || '%'
          WHEN COLUMN BETWEEN 30 AND 50
             THEN    '<div class="a-Report-percentChart" style="background-color:#000000;width:100%;"><div class="a-Report-percentChart-fill" style="width:'
                  || COLUMN
                  || '% ; background-color:CC0000;"></div><span class="u-VisuallyHidden">'
                  || COLUMN
                  || '</span></div>'
                  || COLUMN
                  || '%'
          WHEN COLUMN BETWEEN 55 AND 70
             THEN    '<div class="a-Report-percentChart" style="background-color:#000000;width:100%;"><div class="a-Report-percentChart-fill" style="width:'
                  || COLUMN
                  || '% ; background-color:#99eb47;"></div><span class="u-VisuallyHidden">'
                  || COLUMN
                  || '</span></div>'
                  || COLUMN
                  || '%'
       END AS "Progress bar"
  FROM Table


Note: 
 Use CASE Statement to display different colors for the bars based on percentage.

2-Set the Report Bar column to Standard Report Column

3-Output:

In this report we're using the employees percentage of salary within their department




















Note: 
If you want same color for the bar then use the same query without CASE Statements.

2 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete