Oracle APEX 4.2 Reporting

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.
Preview in Mapt

Oracle APEX 4.2 Reporting

Vishal Pathak

1 customer reviews
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.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$23.10
RRP $32.99
Save 29%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$23.10
$54.99
$29.99p/m after trial
RRP $32.99
RRP $54.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Oracle APEX 4.2 Reporting Book Cover
Oracle APEX 4.2 Reporting
$ 32.99
$ 23.10
Oracle APEX 4.0 Cookbook Book Cover
Oracle APEX 4.0 Cookbook
$ 35.99
$ 25.20
Buy 2 for $35.00
Save $33.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781849684989
Paperback428 pages

Book Description

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.

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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
Chapter 9: Performance Analysis
Tuning pointers for development
Discussions on HTML, JavaScript, and client-side tools
Discussions on database tools for performance tuning
Summary

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

Authors

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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
Chapter 9: Performance Analysis
Tuning pointers for development
Discussions on HTML, JavaScript, and client-side tools
Discussions on database tools for performance tuning
Summary

Book Details

ISBN 139781849684989
Paperback428 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Oracle APEX Best Practices Book Cover
Oracle APEX Best Practices
$ 29.99
$ 21.00
Oracle APEX 4.0 Cookbook Book Cover
Oracle APEX 4.0 Cookbook
$ 35.99
$ 25.20
Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
Oracle APEX Cookbook : Second Edition Book Cover
Oracle APEX Cookbook : Second Edition
$ 35.99
$ 25.20
Oracle E-Business Suite Financials R12: A Functionality Guide Book Cover
Oracle E-Business Suite Financials R12: A Functionality Guide
$ 41.99
$ 29.40
Oracle Application Express 4.0 with Ext JS Book Cover
Oracle Application Express 4.0 with Ext JS
$ 32.99
$ 23.10