oracle-apexoracle-apex-19.1

Oracle apex (19.1) - hide interactive report panel when table is empty


I got an interactive report with a "collapsible" template.

When the table is empty there is an empty panel that takes up a lot of space. In Classic report this space does not exist when the table is empty. I can't find a way that interactive report will behave the same way (we don't want to use Classic report). I need a simple generic solution since we have a lot of tables.

The interactive report looks like this: enter image description here

And I want it to look like this (as Classic report): enter image description here


Solution

  • You could apply an after-refresh dynamic action that checks for the existence of the nodatafound area, and hide/treat the region in some way:

    $(this.triggeringElement).find('.nodatafound').length == 1
    

    Or you could apply a different amount of padding to the .a-IRR-noDataMsg class

    .a-IRR-noDataMsg {padding: 5px;}
    

    enter image description here