Book Image

Oracle APEX Best Practices

Book Image

Oracle APEX Best Practices

Overview of this book

Have you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it."Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you'll need. "Oracle APEX: Best Practices" is where practical development begins!
Table of Contents (14 chapters)
Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 in Report Query Name (anything is fine), then select Output Format from the list, and click on Next as shown in the following screenshot:

Enter the query and click on the Next button. See the following screenshot:

To end the report query, click on...