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

How to add a chart to a report


It's actually quite easy to use the BI Publisher Template Builder plugin for Microsoft Word and BI Publisher as the PDF rendering engine for Application Express.

The Template Builder plugin can be downloaded from http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html.

Report layouts can be developed by using the BI Publisher Word Template Builder. Using the Template Builder, you can create a chart and report definition, and save this as an RTF file, which can be uploaded back into Application Express.

Tip

It's important to understand however, that this is not a printer-friendly version of your web page. So if you have, for example, a Flash chart region and a report region on your page, you can't simply print this as a PDF.

The PDF printing feature in Application Express generates XML data of your report's result set, using an XSL-FO report layout (or RTF template). This XML data is then transformed into PDF (or other supported output format...