Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle APEX Best Practices

You're reading from   Oracle APEX Best Practices Make the most of Oracle Apex with this guide to best practices. It will help you look at the bigger picture when building applications and take more elements into account such as security and performance.

Arrow left icon
Product type Paperback
Published in Nov 2012
Publisher Packt
ISBN-13 9781849684002
Length 298 pages
Edition 1st Edition
Arrow right icon
Toc

Table of Contents (14) Chapters Close

Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1. Prepare and Build 2. Leveraging the Database FREE CHAPTER 3. Printing 4. Security 5. Debugging and Troubleshooting 6. Deploy and Maintain Database Cloud Service and APEX 4.2 Index

How to create a report that can deliver output in different formats


Apache FOP is only capable of PDF printing. The other printing format options (Word, Excel, and HTML) are available if the BI Publisher configuration is been used or if you are using Oracle Reports in combination with Application Express. Oracle Reports is capable of creating reports in multiple formats.

This example describes how to create a report with different output formats.

The first step is to create a simple report and to enable report printing as described earlier in this chapter under the header Simple print test.

The second step is to create the select list item based on a static list of values. Let your users select the kind of report output type to be used. You can do so by creating an item with the select list type.

Display value

Return value

PDF

PDF

Word

RTF

Excel

XLS

HTML

HTM

XML

XML

The select list item has a list of values attached as follows:

Static2:PDF;PDF,Word;RTF,Excel;XLS,HTML;HTM,XML;XML...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image