Adding Selection Criteria to the Report Layout

If you want to display the selection criteria used to get the report results, you can add this information on your report.

Note: If working with a shared report, you must reserve the report so that the Edit Layout icon will be available. You cannot edit a shared report without reserving it first.

Access a One View Reporting-enabled form.

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

  2. Select the personal or reserved report that you want to modify.

  3. On the side panel Layout tab, click the Edit Layout icon.

  4. In BI Publisher, select the Edit option for your report.

  5. In the BI Publisher Layout Editor, insert a List where you would like to display the selection criteria on your report.

  6. From the Data Source pane, under the Grid01\Criteria folders, select either "Report Criteria" or "Report Criteria with Table Names" and drag it into the list box that you just created.

    Both options will display the report criteria. However, the second option will also display the name of the table for that particular report criterion.

  7. Format the list as desired.

  8. You need to remove the filter so that the data on the report is not affected. To remove the filter, click on the section outside the list box and then choose Configure events under Interactivity. This provides a dialog box to check or uncheck the filter. Uncheck the filter to turn it off and click OK.

  9. Select Save.

    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.

For more information, see "Editing Reports" in the Oracle® Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher.