How TO Report Column background color in Oracle Apex.

 


For Interactive Report
================

Step-1 : Create Interactive Report

--> SQL Query : 

SELECT EMPLOYEE_ID,FULLNAME,F_DEPT(DEPARTMENT_ID) DEPARTMENT,BASIC_SALARY,GROSS_SALARY
FROM EMPLOYEES

Step-2 : You must set Static id specific column

Column 1: rep_col_diffcolor_1  (As like : BASIC_SALARY)

Column 2: rep_col_diffcolor_2  (As like : DEPARTMENT)

Step-3 : inline :


.a-IRR-table tr td[headers*="rep_col_diffcolor_1"]

{

    background-color: #99ccff;

}

.a-IRR-table tr td[headers*="rep_col_diffcolor_2"]

{

    background-color: #bfc4c9;

}



For Classic Report
=============



Step-1 : Create Classic Report

--> SQL Query : 

SELECT EMPLOYEE_ID,FULLNAME,F_DEPT(DEPARTMENT_ID) DEPARTMENT,BASIC_SALARY,GROSS_SALARY
FROM EMPLOYEES

Step-2 : Select your column, where you want set background color (My choice "EMPLOYEE_ID" & "BASIC_SALARY")


--> inline :

.t-Report tr td[headers*="EMPLOYEE_ID"]

{

    background-color: #bfc4c9!important;

}

.t-Report tr td[headers*="BASIC_SALARY"]

{

    background-color: #99ccff!important;

}


Post a Comment

Previous Post Next Post