Monthly Archives: November 2013

Reporting Tips & Tricks – Table of Contents

Oracle-Apex-Reporting-Tips-Tricks-George-Bara_small

Here is the complete Table of Contents for “Oracle APEX Reporting Tips & Tricks“.

Remember, you can buy my book from:

– Lulu.com: http://www.lulu.com/spotlight/george_bara/

– iTunes:https://itunes.apple.com/us/book/oracle-apex-reporting-tips/id648562856?mt=11

– Barnes and Noble: http://www.barnesandnoble.com/w/oracle-apex-reporting-tips-tricks-george-bara/1115380466?ean=9781304020222

– Amazon: http://www.amazon.com/dp/B00DHHRH7M

Table of Contents

Introduction
About the Author

Chapter 1: Introducing APEX
GETTING STARTED WITH APEX
INSTALLING ORACLE APPLICATION EXPRESS
SETTING UP A WORKSPACE AND CREATING YOUR FIRST APPLICATION
CREATING YOUR FIRST APPLICATION
HOW DOES APEX WORK?
PL/SQL Web Applications
Choosing an APEX Web Server
APEX REPORTING BASICS
The Classic Report
The Interactive Report

Chapter 2: Interactive Reports Basics
INTERACTIVE REPORT MAIN FEATURES
Report Attributes
Saving Customized Reports
INTERACTIVE REPORT ALTERNATIVE VIEWS
Single Row Detail View Grouping
Alternative Detail View
Interactive Report Icon View
MIGRATING FROM CLASSIC TO INTERACTIVE REPORT
CUSTOM INTERACTIVE REPORT CSS STYLING
The APEX Theme CSS
Creating Custom Theme CSS
CSS with a Custom HTML Source
INTERACTIVE REPORTS DOWNLOAD OPTIONS
Standard Download Options
Creating a Custom Download Link
CREATING A CUSTOM DOWNLOAD FORMAT
How does APEX Render a Report for Download?
Creating a Download Procedure for CSV Format

Chapter 3: Advanced Interactive Reports
INTERACTIVE REPORTS BASED ON APEX COLLECTIONS
About APEX Collections
Interactive Reports Based on Collections
Interactive Report Column Headings
Hardcoding Report Column Headings
HACKING FILTERED INTERACTIVE REPORTS
The APEX Filter Condition Views
Interactive Reports IDs

Chapter 4: Beyond Interactive Reports
ADDING CHECKBOXES TO INTERACTIVE REPORTS
Checkbox Selected State
Select and Unselect All
JQUERY DYNAMIC ACTIONS ON CHECKBOX CHANGES
Installing jQuery on APEX
Creating Checkboxes with Dynamic Actions
Summary of Dynamic Calculations with Checkboxes
DYNAMIC INTERACTIVE REPORTS FILTERING
Default Filtering Methods
The “gReport.search” Function
Report Filtering Based on APEX Items
The “APEX_UTIL.IR_FILTER” Procedure
FILTER AND REFRESH USING DYNAMIC ACTIONS
Interactive Report Filter Using Dynamic Actions
Interactive Report Refresh Using Dynamic Actions
DISPLAYING IMAGES IN INTERACTIVE REPORTS
Local Filesystem, CDN or Database?
Uploading Images to the Database
Displaying Images Stored in the Database

Chapter 5: Reporting on Web Services Results
ABOUT WEB SERVICES
USING WEB SERVICES IN APEX
CREATING WEB SERVICE REFERENCES
Creating REST Web Service Reference
Creating WSDL Web Service Reference
Creating Manual Web Service Reference
Using Web Services over HTTPS. Oracle XE Limitations
CREATING REPORTS BASED ON WEB SERVICES RESULTS
Reports Based on REST Web Services with Forms
Reports Based on WSDL Web Services

Chapter 6: PDF Report Printing
ABOUT APACHE FOP
DEPLOYING FOP IN A SERVLET
Using OC4J as Servlet Container
Deploying FOP in OC4J
SETTING UP APACHE FOP PRINTING IN APEX
HOW DOES APEX USE THE FOP PRINTING ENGINE
SINGLE REPORT PRINTING
REPORT QUERIES
Creating a Report Query
How Does APEX Store Report Queries
REPORT LAYOUTS
Creating a Report Layout
Creating a Download Button
UNDERSTANDING REPORT LAYOUTS
Generic Columns Report Layout Sections
Customizing the Page Template Section
How Does APEX Store Report Layouts
MULTIPLE REPORT PRINTING

Chapter 7: Complex Report PDF Printing
DESIGNING XSL-FO REPORT LAYOUTS
Display Images in the PDF with XSL-FO
Conditional display in PDF with XSLT
DOWNLOADING FILTERED INTERACTIVE REPORTS AS PDF FILES WHEN USING REPORT QUERIES
Retrieve the filter applied on the Interactive Report from the APEX internal views
Create a View Synchronized with the Filtered Interactive Report
Creating the synchronized Report Query
Create the PDF Download Button

Conclusions