Sunday, April 26, 2020

How to hide Interactive Report Control Panel in Oracle APEX

So, you've created a beautiful Interactive Report and to make it even better and cater to user requirements, you added a bunch of filters, formatting for highlights and perhaps some control breaks as well.

Now your report looks even better and much more readable for users .. but now there's a big section on top of the IR showing all the controls/settings you incorporated and they don't want to see it as they are never going to modify it (or you don't want them to modify it so as to retain the fix format for your report).

But how can we do this ? We don't see any out of box option that will let us hide the Control Panel of an Interactive Report.

This is where again the power of humble CSS comes in handy. Let's see how we can achieve this.

So, let's take an example of below IR. By default, it will look like this after applying all the controls. You can see the Control Panel section appearing on top of IR -

To hide the Control Panel -

- Navigate to your IR

- Under Advanced section, enter a Static ID (EMPREPORT in this case)

- Now, let's navigate to Page (Page2: Employees in this case)

- Scroll down in Property Pane until you locate CSS section

- Under Inline section, enter below code (replace EMPREPORT with your IR's Static ID) -




- Save

Now when you run this report, you'll see the Control Panel section is no more visible and IR still retains all the settings you've incorporated -



Post a Comment