Databases Reference
In-Depth Information
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 deining 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 ile that we create to build a template.
Creating the report query
The irst 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 in
Report Query Name
(anything is ine), then select
Output Format
from the list, and click on
Next
as shown in the following screenshot:
