- Oracle APEX 4.0 Cookbook
- Table of Contents
- Oracle APEX 4.0 Cookbook
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Creating a Basic APEX Application
- Introduction
- Creating an APEX 4.0 application
- Creating a simple form page
- Creating a simple report
- Implementing an interactive report
- Creating a chart
- Creating a map chart
- Creating a navigation bar
- Creating a list of values
- Including different item types
- Protecting a page using an authorization scheme
- Securing an application with Authentication
- Control the display of regions and items with Dynamic Actions
- Creating a computation
- Creating an automated row fetch with a page process
- Putting some validation in a form
- Creating a report with PL/SQL Dynamic Content
- 2. Themes and Templates
- 3. Extending APEX
- Introduction
- Adding JavaScript code to your application
- Creating a tag cloud with AJAX
- Creating visual effects with JavaScript libraries
- Enhancing your application with the Google API
- Including Google maps
- Embedding multimedia objects in your application
- Creating a region selector
- Sending mail via APEX
- Uploading and downloading files
- 4. Creating Websheet Applications
- 5. APEX Plug-ins
- 6. Creating Multilingual APEX Applications
- 7. APEX APIs
- 8. Using Webservices
- 9. Publishing from APEX
- 10. APEX Environment
- Introduction
- Setting up a development environment using subscriptions
- Debugging an APEX application
- Debugging an APEX application remotely
- Deploying an application with SQL Developer
- Setting up version control with APEX and SVN
- Setting up a production environment using an Apache proxy
- Setting up the APEX Listener on Weblogic
- 11. APEX Administration
- 12. Team Development
- Index
In this chapter, we will cover:
- Exporting to a comma separated file
- Creating a PDF report
- Creating a report query
- Creating a report layout using Oracle BI publisher
- Linking the report layout to the report query
- Calling a report from a page
Using APEX it is possible to create reports which can be displayed on the screen. However, as a user, you would also like to print the report on paper or at least get the output in some kind of digital format such as PDF or Microsoft Excel. APEX supports a number of formats your reports can be exported to. This needs a little setup work. Furthermore, you can use your output in BI Publisher. In this chapter, we will show you how to export reports and how to interact with BI Publisher.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.