O'Reilly logo

Oracle APEX Best Practices by Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a report with BI Publisher

There are four steps for creating your APEX application report with BI Publisher:

  1. Create the report query.
  2. Design the report layout.
  3. Upload the layout.
  4. Link the report to your application.

You can print a report region by defining a report query as a shared component. Unlike SQL statements contained in regions, report queries are not validated to ensure they are formatted correctly and the objects they reference exist. With report queries, the query is used to generate the file that we create to build a template.

Creating the report query

The first step is to create the report query. Click on Shared Components and then click on Report Queries under the Reports section to create a query:

Enter a name for the query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required