Adding a New One View Report

Access a One View Reporting-enabled form.

Note: You cannot add a new One View report if you are using a List View grid format. You must switch to a Table view grid format in order to be able to add a new One View report. For more information on grid formats, see "Grid Formats" in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide. (Tools Release 9.2.0.5)
  1. Define the sample data for the report by using a query or by entering values in the filter fields and QBE column headers of the find browse form.

  2. On the JD Edwards EnterpriseOne form, click any QBE column header with a plus (+) sign to add it to the data model for the report.

  3. From the One View menu, select Create New Report.

  4. On the Report Definition tab in the side panel, select a naming convention for the data model.

  5. Select a default row set option for running the report.

  6. Click Find to populate the grid.

  7. On the Report Definition tab, click the Save icon.

  8. Enter a name for the new report and then click OK.

    The BI Publisher Layout Editor appears in a pop-up window.

  9. In the Layout Editor, click Add New Layout.

    The Create Layout page displays the template selections.

  10. Select a template for the report.

  11. In the Report Title field, enter a title for the report.

  12. Enter titles for other sections of the report, such as charts and tables, as required.

  13. In the Data Source side panel, select columns from the Rowset section and drag them to the desired areas of the report.

    Note: Decimal placement in decimal fields can vary based on customer implementation. An example is Unit Price. To ensure that the format of a report matches the format of a decimal field in a JD Edwards EnterpriseOne interactive application, you should assign the decimal precision to the column in the Layout Editor.
  14. Click the Save icon.

    The Save Layout window appears.

  15. Enter a name for the layout in the Layout Name field.

  16. If desired, click the Interactive Preview icon to view the report.

  17. Close the Layout Editor by clicking the X in the top-right corner to return to JD Edwards EnterpriseOne One.

    Note: Do not click the Sign Out link, or you will have to sign into BI Publisher manually to run One View reports during the same session.

    The new report appears under Personal in the One View menu.

For information about Oracle's BI Publisher Layout Editor, see "Creating BI Publisher Layout Templates" in the Oracle® Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher.