If your APEX application has many Interactive Reports (IR) it can be tedious to configure IR features for each report, and their columns, such as filtering, highlighting etc.
Since APEX resides within the database there's a quick way to manage all of your IRs. Please note this is not supported by Oracle so please be aware of this.
First login to the database as SYS or SYSTEM.
Update Interactive Report options: You can modify more options by looking at the table definition for wwv_flow_worksheets
UPDATE apex_030200.wwv_flow_worksheets -- Where apex_030200 is your current APEX instance SET allow_report_saving = 'Y', -- Configure options as required show_finder_drop_down = 'N', show_display_row_count = 'Y', show_search_bar = 'N', show_search_textbox = 'Y', show_actions_menu = 'Y', show_select_columns = 'N', show_sort = 'N', show_filter = 'Y', show_control_break = 'Y', show_highlight = 'Y', show_computation = 'N', show_aggregate = 'N', show_chart = 'Y', show_flashback = 'N', show_reset = 'Y', show_download = 'Y', show_help = 'N' WHERE flow_id = :app_id AND page_id = :app_page_id -- Remove this predicate to push changes for all IRs
Update Interactive Report Columns:
UPDATE apex_030200.wwv_flow_worksheet_columns SET allow_sorting = 'Y', allow_filtering = 'N', allow_ctrl_breaks = 'Y', allow_aggregations = 'N', allow_computations = 'Y', allow_charting = 'Y' WHERE flow_id = :app_id AND page_id = :app_page_id;