Adding All Columns to a One View Report

Instead of adding columns to a report individually, you can add all of the columns in the grid to the report simultaneously.

Note: You might want to use this option if the Find/Browse form has only a few columns in the grid, or if you have a customized grid with only a few columns selected but you need all the columns for reporting. Oracle recommends that you avoid using this option in One View Reporting applications when all the grid columns are displayed.

To add all columns to a One View report:

  1. Access a One View Reporting-enabled form.

  2. Select a grid format.

  3. On the Find/Browse form, locate the sample data for the report.

  4. From the One View menu, select Manage Reports.

  5. Select a personal or reserved report.

  6. In the side panel, click the Report Definition tab.

  7. Click the Add All Columns icon.

    All columns are added to the report definition and appear under Selected Columns.

  8. Click either the Save or Save As icon to save your changes.

    Note: The Save option replaces the data model of an existing report while retaining the report definition and the report layouts. The Save As option creates a new report with a new report definition, data model, and report layout.