Interactive Report Regions

Interactive Report Regions are a new feature in APEX 3.1 and provide many new features over Classic Report Regions. Interactive Reports provide users with the ability to customize reports at runtime, ensuring that they can tailor a report to suit their own needs. Users can add or remove columns, apply sorting, perform conditional highlighting, and filter report results. Users can also add calculated columns, control breaks, and even generate charts based on report data. Once a report has been customized, the display changes can be saved and re-applied again at a later stage. Interactive Report results can also be exported to other formats for printing or viewing.

In the following screenshot, we can see an example of an Interactive Report Region:

You will start to notice a number of differences compared to a Classic Report Region. The main difference is the Search Bar at the top of the report results. The Search Bar enables us to enter search criteria to filter...