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.
Related tutorials:
- Oracle Apex Interactive Report Tutorial
- Create Delete Row Button for Interactive Report in Oracle Apex