Oracle APEX Hide/Show No Data Found Message

I have a requirement to hide the No Data Found message on an Interactive Report when page is initially loaded then show back the message if there is no data.

I have search items (Say PX_Search_Item_1, PX_Search_Item_2) on the region and a button Search and underneath an Interactive Report based on the search items. Initially we need to hide the No Data Found message but when Search button clicks, there is no data then show back the No Data Found or any custom message.

Would it be possible? Your help and support would be appreciated.

The IR attribute "When No Data Found" does support page item syntax but that value needs to be set before rendering. There are 2 possible implementations of your question. One is that the search button submits the page and another is that the search button triggers a dynamic action that refreshes the IR region only.

search button with page submit

• Create page item PX_NO_DATA_FOUND
• Set the IR attribute > Message > When No Data Found to value &PX_NO_DATA_FOUND.
• Create a computation on PX_NO_DATA_FOUND with processing point "After Submit" to set the static value "No Data Found"

search button with dynamic action to refresh IR

This can be done with some javascript

• Set the IR attribute > Message > When No Data Found to value <div id="ir_ndf"><div>
• Create a dynamic action for event "After Refresh" with selection type "Region" and your IR report region
• Set a true action of type "Execute Javascript Code" and code $('#ir_ndf').text("No Data Found");. Make sure the "Fire On Initialization" attribute is set to off.