Book Image

Oracle APEX 4.2 Reporting

By : Vishal Pathak
Book Image

Oracle APEX 4.2 Reporting

By: Vishal Pathak

Overview of this book

<p>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. <br /><br />"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.<br /><br />"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.<br /><br />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.</p>

Related Content you might be interested in

Current Title:

Small book image
Oracle APEX 4.2 Reporting
Vishal Pathak
Aug, 2013 | 428 pages
No titles found
Table of Contents (17 chapters)
Oracle APEX 4.2 Reporting
Oracle APEX 4.2 Reporting
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Know Your Horse Before You Ride It
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
2
Conventional Reporting in APEX
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
3
In the APEX Mansion – Interactive Reports
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
4
The Fairy Tale Begins – Advanced Reporting
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
5
Flight to Space Station: Advanced APEX
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
6
Using PL/SQL Reporting Packages, Jasper, and Eclipse BIRT
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
7
Integrating APEX with OBIEE
Integrating APEX with OBIEE
Understanding Oracle fusion management architecture
Understanding OBIEE
Integrating OBIEE with APEX
Understanding BI Publisher
Integrating BI Publisher with APEX
Summary
8
All About Web Services and Integrations
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
9
Performance Analysis
Performance Analysis
Tuning pointers for development
Discussions on HTML, JavaScript, and client-side tools
Discussions on database tools for performance tuning
Summary
Appendix
Appendix
Steps to create PACKT_SCHEMA
SQL Injection
Cross-site scripting
Database and web interaction in DAD and Listener configurations
APEX behind the scenes
Index
Index

Using APEX views to create a classic report on saved IRs

In this section, we create a classic report that gives us links to access the saved reports of an IR. We can query the information about saved reports from the apex_application_page_ir_rpt view. This view holds the metadata of IR reports. One row of this report corresponds to one of the saved IRs. Log in as SKING/SKING and run the third page of the reference application. Screenshot has been shown as follows and the heading of the classic report is highlighted for your convenience:

The Reports on IR classic report lets us select one of our saved reports. Its function is similar to the Reports dropdown. We are using the report_id column of apex_application_page_ir_rpt to help us uniquely identify each saved report. We are assigning this report_id value to a page item and this page item is put in the Report ID Item textbox of the Advanced section of the Report Attributes page of the IR. The entire query can be found in the Formatting an...

Previous Section
End of Section 8
Next Section