Interactive Report and Show Hide Columns

Dave Oz

User wants a radiogroup across the top of an IR and based on the choice they make in the radio group they want the columns displayed in the report to change. This would be similar to how a user saves their own private reports with the layout they desire.

For example, across the top of an IR there are 2 choices provided in the radiogroup displayed as a pill box - choice TN and choice AR. The report initially loads with columns FirstName, MiddleName, LastName, PhoneNumber, and State.

When they click "TN" the data refreshes and only records with state = TN are displayed. Likewise, when they click AR the data refreshes and only records with state = AR are displayed.

The request is that when AR is selected, in addition to only seeing State = AR records, only the LastName and PhoneNumber should be displayed.

The report data is refreshing because I have a dynamic action on the Change of the radiogroup that executes a True action of Submit page.

Is this possible within my current design, or is a separate report layout needed?

APEX 18.2

AlexH-Oracle

Hey Dave - One think you could do is try to set-up a Dynamic Action on the IR. Set it to "After Refresh" and you will have actions available to hide a column in that report. Make that conditional based on AR and TN.

Another way you might try this is to set-up a couple of saved reports on the IR, then using a page submit send the necessary parameters for this to happen: https://docs.oracle.com/en/database/oracle/application-express/18.2/htmdb/linking-to-interactive-reports.html

Scott Wesley

You could hide those columns based on the radio item value.

ie - on change of radio, refresh IR, (no need to submit page), include item on page items to submit in the region property, and have server side condition on column.

You could also use the radio item value to determine which rows to select.

This applies to IR or classic reports.

But if you want to leverage saved reports, that's a different level of thinking.