Conditional Formatting on Oracle Apex Interactive Report

Topic Introduction: Sometimes we need to format data by any condition in Oracle Apex Interactive Report from the front end or by End-user mood clicking the Action button. In this situation, if we add any conditional formatting format option show the above report under the Arrow sign. if we want to hide these conditions we need to apply CSS on the page inline.

Today we will discuss how to apply Conditional formatting and hide applied condition options from Oracle Apex Interactive Report.

Conditional Formatting on Oracle Apex Interactive Report

1. Create an Interactive Report 

2. On runtime mood & select the Action option of Report

3. Select Format ==> Highlight

Name: if want to give the name of the formatting give the name

Highlight type: Row/Cell

Highlight Style

Background Color: Specify Color using the Color picker Pen icon

Text Color: Specify Color using the Color picker Pen icon

Highlight Condition

Column: Select a column by which you want to give a condition.

Operator: Select the conditional operator by which you want to give conditions such as =,<,>, etc.

Expression: Give Condition expression or value

Remove the action bar from the report where the applied formatting showing

1. Give a Static ID of the Interactive Report Region (formateTest)

2. Write below CSS to page Inline

#formateTest_control_panel{

    display: none;

}