Customize Interactive Report in Oracle APEX. (Color Rows if row have Specific Values)

-

 This blog will demonstrate steps to display column value with different color based on calculations.

Following is output of what we want to achieve.



Step1: Create an Interactive Report based on SQL Query.I have used following query.You can use your own as per your requirement.

select
    EMPNO,
    ENAME,
    JOB,
    DEPTNO,
    SAL,
    case when SAL < 3000 then 'red'
        when SAL between 1000 and 2000 then 'blue'
        when SAL > 3000 then 'green'
    end text_color
from EMP EMP


    Step2: Now go to Columns under Report and select Text_Color.

  Step3: Now set Type = Hidden Column

 

 Step4:  Now you have to set following code in each column under Column Formatting (HTML Expression)

 

<span style="color:#TEXT_COLOR#;font-weight:bold;">#SAL#</span>

Add same code in all the columns and you're done with report.

 

Have a Happy Learning

Regards
Digvijaysinh Virpura




Comments

Post a Comment

Popular posts from this blog

Custom Authentication in Oracle APEX

-
Image
 Custom Authentication in Oracle APEX  This blog demonstrate the steps for Custom Authentication in Oracle APEX. Step1: We Need a table Login.      CREATE TABLE   "LOGIN"    (            "LOGIN_PK" NUMBER(7,0) NOT NULL ENABLE,                 "ENTITY_OWNER_FK" NUMBER(7,0) NOT NULL ENABLE,                 "ENTITY_FK" NUMBER(2,0) NOT NULL ENABLE,                 "USERNAME" VARCHAR2(20) NOT NULL ENABLE,                 "PASSWORD" VARCHAR2(20) NOT NULL ENABLE, "EMAIL" VARCHAR2(50),   CONSTRAINT "LOGIN_PK" PRIMARY KEY ("LOGIN_PK") ENABLE,         ...
Read more

"Navigating the Oracle APEX Frontier: A Transformative PhD Expedition"

-
Image
My five-year journey of pursuing a Ph.D. in Oracle APEX has been filled with both challenges and invaluable learning experiences. I decided to write this blog to share my insights and to help those who are considering a Ph.D. and are in search of a compelling research topic.   Where did the idea come from? It all started with a simple Online Test Application on a Local Area Network (LAN) using Oracle APEX . The idea of pursuing a Ph.D. in Oracle APEX first came to me in 2011-12.During that time, I developed an application to conduct online MCQ tests for students, designed to run on the LAN. Using a standard computer with minimal configuration, I installed Oracle APEX and set up the application so that students could access the MCQ test on the intranet, allowing us to generate results instantly. ...
Read more

Display Dynamic TextField in APEX based on Table Columns.(APEX_ITEM.TEXT)

-
Image
This blog will demonstrate steps to display TextField dynamically based on Table Columns in Classic Report and insert data into database. Oracle APEX has a large collection of API in which APEX_ITEM.TEXT is used in this example while if you want to explore in detail just click on following link. https://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_item.htm#AEAPI192 Step1: Create a Classic Report based on SQL Query. In this demo i have used a Emp table. So my query look like as follows.     select EMP.EMPNO as EMPNO,               EMP.ENAME as ENAME     from EMP EMP and Result will look like as shown in following figure. Now If we need to display a textbox against each employee name we need to add one dynamic APEX_ITEM.Text. So now our query will change as follows. select  EMP.ENAME as ENAME,    APEX_ITEM.TEXT(01,null,NULL,2,NULL,'Emp_Salary') AS Salary,    APEX_ITEM.HIDD...
Read more