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

Getting Started with C++ Programming

Write a program in C++ to print My First Program on output Screen"

#include<iostream.h> #include<coniog.h> int main() { clrscr(); cout <<"My First Program "; return 0; }

 

 

Write a program in C++ to print Addition of Two Numbers"

#include<iostream.h> #include<coniog.h> int main() { int integer1,integer2,sum; cout<<"Enter integer1\n"; cin>>integer1; cout<<"Enter integer2\n"; cin>>integer2; sum=integer1+integer2; cout<<"sum of 20+30 is ::"<<sum; return 0; } /*If user want to print the output as Sum of integer1 + integer2 = Sum then our cout statement will look like cout<<"sum of"<< integer1 << "+" << integer2 << "is ::"<<sum; */

 

 

Write a program in C++ to print Area of Circle (equation is : pi(r * r)"

#include<iostream.h> #include<coniog.h> #define pi 3.14 int main() { float area,r; clrscr(); cout<<"Enter the value for r::"; cin>>r; area=pi*r*r; cout<<"Area of "<<r<<"is"<<area; getch(); }

 

 

Write a program in C++ to input 5 subject marks and caluclate average of it."

#include<iostream.h> #include<coniog.h> int main() { int s1,s2,s3,s4,s5,sum; float avg; clrscr(); cout<<"Enter Subject 1 Marks::"; cin>>s1; cout<<"Enter Subject 2 Marks::"; cin>>s2; cout<<"Enter Subject 3 Marks::"; cin>>s3; cout<<"Enter Subject 4 Marks::"; cin>>s4; cout<<"Enter Subject 5 Marks::"; cin>>s5; sum = s1+s2+s3+s4+s5; cout<<"\n\n Total Marks is ::"<<sum; avg = sum/5; cout<<"\n\n The Average is ::"<<avg; }

Programming Fundamental and Logic Development

This Blog will help you to start with Programming

Step 1: First You Need Turbo Compiler.Click on the following link to download Turbo Compiler.

https://drive.google.com/file/d/1eNYvBqtjbV6sUFLoYksu_XITz3LwOnT9/view?usp=sharing

 

Step 2:Click on Above Link and you will see page as follows

 

This will download Turbo C.

 

Step 3:Now you required WinRar Zip to extract this folder. You can find the link on following page.

https://www.win-rar.com/download.html?L=6

Step 4: Now go to folder then right click and Click Extract Here. Your file will be extracted.

 
Step 5: Now Click on Setup.exe and done.

If u face any issue then just type your questions in the comment section.