-1

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.

Improve this question
2
  • What happens when a user clicks the button ? Is it a page submit or a dynamic action with a region refresh ? Commented Jun 24 at 6:57
  • Hi Koen, When a user clicks the button, it is a DA with a region region refresh. Commented Jun 24 at 16:37

1 Answer 1

Reset to default
1

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.
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you Koen for your response. It works like a charm. I confirm that it resolved my query.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.