Display message only when there is no data found

Set the report's no data found message

and then set the report to be conditional on the parameters being populated

that way the "no data found" message won't be seen until after the parameters are set and submitted

I'm not a master of APEX, but I have used a number of reporting tools for Oracle over the years.  In all of them, it is always MUCH harder to report on what is NOT in the database, than on what IS in the database!  Database reporting tools are designed to report on what IS in the database.

Sdstuber's suggestion looks to me like a good idea, if APEX has that feature.

Hi sdstuber

Will definitely try that.

Thank you,
R

sdstuber,

I have given a message under "no data found" part of the report
I gave serverside condition as one of the parameters is not null, but still it displays the message.

Thanks,
R

export your page and post it here

Hi, the problem with the serverside-condition should be, that the report is not actually delivered to the client if the parameter page item is empty. What you could do, is create a hidden page item. In an on-change dynamic action of your parameter page item, fill this page item with "No data found"-message if the parameter page item is NOT NULL. Then, set this hidden page item as No-Data-Found-message in the region attributes (the format is &PAGE_ITEM_NAME.).

Thank you Markusld. I have found my own solution and working as expected.