In this tutorial, I will show you how to highlight the rows using the Highlight
function from the Action
menu at runtime.
Highlighting Rows in Report Based on Condition in Oracle Apex
To demonstrate this example, I am using the following Product Detail report:
Now suppose we have a requirement to highlight the rows having a list price > 100
. To do this follow these steps:
Click on the Actions
menu to open, then point to Format > Highlight
. The following dialog will open, then specify the condition and settings according to your requirement, as shown in the below image:
After setting all the properties, click on the Apply
button, and then immediately, the report will take effect as per the condition. Below is the screenshot:
So our report condition is being applied correctly, and in the same way, you can apply more conditions to this report.
But you can see the above condition name displayed with a Star
icon and Close
button. If the user clicks on the Close
button, the report highlight will be removed.
If you do not want to show this condition box above the report, use the following CSS trick. Follow these steps:
To hide the conditional region, open your report in Oracle Apex page designer and specify the Static ID
for the report, as shown in the below image:
Now add the following CSS code into the Inline CSS section of the page:
div#productReport_control_panel { display: none; }
But please note, I specified the Static ID productReport
, so I used the ID for div#productReport_control_panel
in the CSS code above. It means whatever is the Static ID, you will append the string _control_panel
to it. For example, if you will specify the report Static ID, then the CSS code would be:
div#myReport_control_panel { display: none; }
Now our report will display without the report condition control panel as shown in the below image:
This is looking much better, right?
But our job to create a report based on the condition is not finish yet.
Because this report is currently visible to you only, to make this report changes permanent and to visible every user, you need to save it as the Primary
Report. To do this, follow these steps:
Click on the Actions Menu > Report > Save Report
option. Then select the Default Report Settings
option, as shown in the below image:
After selecting the above option, it will show you the two options Primary
and Alternative
. Select the Primary
option and click on the Apply
button.
Now it is done, and your conditional report will be visible to every user of Oracle Apex.