Free Sample
+ Collection

Oracle APEX 4.2 Reporting

Vishal Pathak

Building complex reporting solutions is simplified using Oracle APEX and this remarkable tutorial. Written for intermediate to advanced users of APEX, it includes real-life business scenarios to make the lessons relevant and easily assimilated.
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849684989
Paperback428 pages

About This Book

  • Provides an introduction to the APEX architecture and is a step-by-step guide to setting up the APEX environment on Weblogic
  • Integrations of the reports with the most popular reporting technologies and generation of exotic and typical reports alike
  • Packed with complex APEX applications to help you learn newer ways of fulfilling reporting requirements in APEX

Who This Book Is For

"Oracle APEX 4.2 Reporting" is for you if you design or develop advanced solutions in APEX or wish to know about the advanced features of APEX. If you wish to have a 360 degree view of reporting technologies or work in a complex heterogeneous enterprise, this is a must-have.

Table of Contents

Chapter 1: Know Your Horse Before You Ride It
What is really new in the new avatar of APEX?
APEX configurations
Installing APEX engine and Listener
Creating APEX workspace
Understanding the APEX URL
Decoding the APEX page submissions
APEX behind the scenes
Other web interfaces
A pessimist's view of APEX
Chapter 2: Conventional Reporting in APEX
Creating database objects and installing the reference application
Implementing external table authentication
Displaying environment properties using the USERENV namespace
Displaying the CGI environment variables
Implementing a classic report search functionality
Enabling sorting and CSV download
Implementing group reports
Additional methods of formatting
Implementing a matrix report
Data highlighting using Dynamic Actions and jQuery
Advanced formatting using APEX templates
Understanding dynamic query region in APEX
Implementing hierarchical reports
Understanding methods to upload files in APEX
Understanding download methods
Implementing soft deletion with AJAX and APEX templates
DML operations and report filtering using DA, JavaScript, and page processes
Implementing a tabular form
Implementing a master detail report and displaying complex types
Implementing time series reports
Implementing data-level security
Chapter 3: In the APEX Mansion – Interactive Reports
About the reference application
Important features of the interactive report
Other configurable attributes of an IR
Using Dynamic Actions (DA) to add custom functions in the Actions menu
Using CSS in IR
Understanding the process of any customizations in IR
Using APEX views to create a classic report on saved IRs
Creating multiple IR on the same page
Authorizing user groups to view report columns
Creating Interactive Report Dashboard
Understanding Dynamic Interactive Reports
Chapter 4: The Fairy Tale Begins – Advanced Reporting
About the reference application for this chapter
Using LDAP authentication
Creating sparkline reports
Creating a report with slider
Creating HTML charts
Creating Google visualization charts
Creating Flash charts
Creating a calendar
Creating a report with images
Creating a dialog box
Creating a context menu
Creating a wizard and using hierarchical queries and regular expressions
Chapter 5: Flight to Space Station: Advanced APEX
Creating HTML image maps
Creating PL/SQL Server Pages (PSP)
Understanding and using loadjava utility
Creating funnel charts using FusionCharts
Creating tag cloud
Creating plugins
Creating websheet application
Configuring the mail
Downloading APEX application without web server
Understanding Oracle OLAP cubes
Understanding Oracle's advanced queuing
Understanding other APEX features
Understanding background jobs in APEX
Knowing about important functions from the API
Chapter 6: Using PL/SQL Reporting Packages, Jasper, and Eclipse BIRT
APEX reporting using PL/PDF and PL_FPDF
Process to create RTF, XLS, CSV, and HTML documents
APEX reporting using fop and Cocoon
Creating Jasper reports
Creating reports using Eclipse BIRT and integrating with APEX
Chapter 7: Integrating APEX with OBIEE
Understanding Oracle fusion management architecture
Understanding OBIEE
Integrating OBIEE with APEX
Understanding BI Publisher
Integrating BI Publisher with APEX
Chapter 8: All About Web Services and Integrations
Understanding reports on web services and collections
Understanding and implementing BPEL
Integration with SAP crystal reports
Migrating from MS Access to APEX
Migrating from Oracle Forms and Reports
Integration with Google API
Integration with Oracle R Enterprise
Chapter 9: Performance Analysis
Tuning pointers for development
Discussions on HTML, JavaScript, and client-side tools
Discussions on database tools for performance tuning

What You Will Learn

  • Get to grips with the APEX architecture, its configurations, and how to set up an APEX environment on Weblogic
  • Explore the uses of the very old Classic reports and learn to implement almost all possible reporting requirements using Classic reports
  • Understand and work with a number of technologies that can be freely used with APEX to help you reduce your licensing cost
  • Discover how to do a lot of new things using a combination of JavaScript, HTML, and Interactive reports
  • Get to know the advanced features of APEX along with a few Oracle 11g database features
  • Learn about a number of techniques to tune an APEX application that will improve your customer satisfaction

In Detail

The biggest challenge in the reporting world is to reduce the overall project cost by picking a tool that minimizes effort and time and to ensure an enriching user experience. Oracle APEX, a 4GL technology, with its unique features such as low implementation time and flexibility, aids us in creating performance-tuned applications with minimum hassle.

"Oracle APEX 4.2 Reporting" is a unique blend of fascinating solutions and intriguing integrations which gives you a 360 degree view of the reporting solutions available to you on the market. It showcases advanced APEX solutions that will empower you to fulfill all kinds of tricky requirements of the reporting world. Live applications support the discussions in the text, enabling you to perform your own experiments on prebuilt applications to take your learning to new heights.

"Oracle APEX 4.2 Reporting" will help you build a well-founded understanding of Oracle APEX along with most of the reporting technologies used today. It is written with the idea of being as practical as possible so that you reap the benefits from day one.

Starting with a brief introduction to the architecture of APEX and installation to enable you to see the applications provided with the book in action, we then move on to the uses of Classic and Interactive reports and explore the advanced features of APEX. We will also explore the most widely used reporting solutions, which is then followed by a brief discussion on BPEL, which is like the glue that can gel any number of tools together. Oracle 4.2 APEX Reporting concludes with several ways of tuning an APEX application, as good performance is the heart of customer satisfaction.


Read More