Reflow Report in Oracle APEX

In my older article, to achieve the reflow behaviour I had to customize the template to create a Responsive Classic Report. Now we have the declarative region type dedicated to this.

Creating a reflow report involves organizing your content in a way that dynamically adjusts to different screen sizes and orientations. Reflow reports are particularly useful when creating reports for devices with varying screen sizes or for printing purposes.

Here’s a general guide on how to create a reflow report, using Oracle APEX as an example.

1. Create a Reflow Report:
2. Go to the Oracle APEX App Builder
3. Create a new page
4. Create a Region and select Reflow Report in Type
5. In source: select data using table/view or query
6. Save and run

Create Reflow Report

Strip and Strok

Column Show Hide

Reflow Report on smaller devices

Heading Options

Report headings

Available options include:

1. Column Names: It generates headings based on a query of the column names.
2. Column Names (InitCap): It generates headings, which are converted to initial capitalization, based on a query of the column names.
3. Custom Headings: It enables you to enter your own headings. The headings are initially defaulted, based on a query of column names.
4. PL/SQL Function Body: It creates headings based on a PL/SQL Function returning a colon-delimited list of names.
5. None: The report is displayed without report headings.