Learn about column types supported by column toggle and reflow reports.

Create a column toggle report in Page Designer.

To create a column toggle report.

1. Create a Blank page using the Create Page Wizard.
2. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
3. Click the Layout tab in the central pane.
4. In the Gallery, click the Regions tab. Right-click Column Toggle and select Add To, and select the appropriate location (for example, Body).

   Tip:

   You can also select the Column Toggle region in the Gallery and drag it to the appropriate location in the Layout tab.
5. Page Designer indicates what to do next. If there are errors, the Show Messages icon displays in the Page Developer toolbar.
   1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
   2. Select an error to highlight the associated attribute in the Property Editor.
6. Select the New region (if not already selected).

   Next, edit the Region attributes in the Property Editor (or right pane).

7. Identification, Title - Enter a region title. The region title only displays when it is defined in the region template.
8. Source - Configure the Data Source for the region:

   What appears next depends upon the attributes you select. For this example, the report is built on a local database on EBA_PROJECTS table.

   Tip:

   To learn more about an attribute and view examples, select the attribute in the Property Editor and click the Help tab in the central pane.
   1. Location - Select the location of the data. For example, select Local Database.
   2. Type - Select how the data is queried. For example, select Table/View.
   3. Table Name - Enter the case-sensitive table or view name. You can type in the name or pick from the list. For example, select EBA_PROJECTS.
9. Edit any additional attributes as needed.
10. View the page, click Save and Run Page.

    The toggle columns report appears.

    End users can control what columns display by clicking the Columns button.

Create a list view report in Page Designer.

To create a list view report.

1. If needed, create a Blank page using the Create Page Wizard.
2. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
3. In the Gallery, click the Regions tab. Right-click List View and select Add To, and select the appropriate location (for example, Body).

   Tip:

   You can also select the List View region in the Gallery and drag it to the appropriate location in the Layout tab.
4. Page Designer indicates what to do next. If there are errors, the Show Messages icon displays in the Page Developer toolbar.
   1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
   2. Select an error to highlight the associated attribute in the Property Editor.
5. Select the New region (if not already selected).

   Next, edit the Region attributes in the Property Editor (or right pane).

6. Identification, Title - Enter a region title. The region title only displays when it is defined in the region template.
7. Source - Configure the Data Source for the region:

   What appears next depends upon the attributes you select. For this example, the report is built on a local database on EBA_PROJECTS table.

   Tip:

   To learn more about an attribute and view examples, select the attribute in the Property Editor and click the Help tab in the central pane.
   1. Location - Select the location of the data. For example, select Local Database.
   2. Type - Select how the data is queried. For example, select Table/View.
   3. Table Name - Enter the case-sensitive table or view name. You can type in the name or pick from the list. For example, select EBA_PROJECTS.
8. Configure the report Attributes:
   1. In the Property Editor, click the Attributes tab.
   2. Settings - Configure the attributes such as the following:

      • Features - Select the features to include with list view report. Depending upon what you select additional attributes may appear. For example, select Enable Search.

      • Text Column - Select the database column that contains the main content for the list view entry. For example, select NAME (required).

      • Supplemental Information Column - -Select the database column that contains supplemental information for the list view entry. For example, select DESCRIPTION.

      • Counter Column - Select the database column that contains the value to display in the count bubble. For example, select BUDGET.

9. Edit any additional attributes as needed.
10. View the page, click Save and Run Page.

    The list view report appears.

Create a reflow report in Page Designer.

To create a reflow report.

1. If needed, create a Blank page using the Create Page Wizard.
2. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
3. In the Gallery, click the Regions tab. Right-click Reflow Report and select Add To, and select the appropriate location (for example, Body).

   Tip:

   You can also select the Reflow Report region in the Gallery and drag it to the appropriate location in the Layout tab.
4. Page Designer indicates what to do next. If there are errors, the Show Messages icon displays in the Page Developer toolbar.
   1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
   2. Select an error to highlight the associated attribute in the Property Editor.
5. Select the New region (if not already selected).

   Next, edit the Region attributes in the Property Editor (or right pane).

6. Identification, Title - Enter a region title. The region title only displays when it is defined in the region template.
7. Source - Configure the Data Source for the region:

   What appears next depends upon the attributes you select. For this example, the report is built on a local database on EBA_PROJECTS table.

   Tip:

   To learn more about an attribute and view examples, select the attribute in the Property Editor and click the Help tab in the central pane.
   1. Location - Select the location of the data. For example, select Local Database.
   2. Type - Select how the data is queried. For example, select Table/View.
   3. Table Name - Enter the case-sensitive table or view name. You can type in the name or pick from the list. For example, select EBA_PROJECTS.
8. Edit any additional attributes as needed.
   For example, to facilitate a better display in a smaller window, you may want to edit the Column attributes, Heading, Alignment and Layout, Column Alignment attributes.
9. View the page, click Save and Run Page.

   The reflow report appears.

   When there is not enough space available to display the report horizontally, the report responds by collapsing the table columns into a vertical value pairs layout where each column displays on a separate row as shown in the following example.