![Page 1: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/1.jpg)
<Insert Picture Here>
![Page 2: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/2.jpg)
<Insert Picture Here>
Advanced Reporting and Charting with Oracle Application Express 4.0
Marc Sewtz | Software Development Manager | Oracle Application Express Oracle USA Inc. 520 Madison Avenue, New York, NY 10022 [email protected]
![Page 3: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/3.jpg)
The following is intended to outline Oracle’s general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remain at the sole discretion of Oracle.
![Page 4: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/4.jpg)
Agenda
• Oracle APEX 4.0 - Overview
• Interactive Report Enhancements
• Updated Flash Charts
• Report Printing
• Demonstration
![Page 5: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/5.jpg)
Oracle APEX 4.0
Overview
![Page 6: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/6.jpg)
Easy to develop • Easy to deploy • Easy to manage
Oracle Application Express Overview
• Unique Rapid Application Development (RAD) tool for the Oracle Database
• Browser based for Development, Deployment and Use
• Allows to declaratively build professional Web 2.0 applications that are fast and secure
• Leverages full Oracle database capabilities and existing SQL & PL/SQL skills
• Standard component of the database
• Fully supported, “no-cost” option with all editions of the Oracle Database
![Page 7: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/7.jpg)
Data-driven ApplicationsDevelop opportunistic and departmental productivity applications
Online ReportingBuild SQL-based reporting applications on existing database schemas
Access ReplacementConsolidate outgrown Access applications to the Oracle database with an APEX Web front end
Spreadsheet Web-ificationConvert spreadsheets to Web applications where they can be concurrently viewed and edited
Oracle Forms Modernization
Leverage SQL & PL/SQL declarative programming skills to move Forms applications to HTML / Web 2.0
Oracle APEX – Typical Use Cases
![Page 8: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/8.jpg)
Oracle APEX - Architecture
![Page 9: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/9.jpg)
Oracle APEX – Multi-Tenancy
![Page 10: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/10.jpg)
Oracle APEX – Deployment Options
Multi-tenant and browser-based architecture allows for deployment anywhere Hosted Service
(dedicated or multi-tenant)
Corporate IT / Enterprise Service (dedicated or multi-tenant)
Departmental Server
Local Database (Oracle XE)
![Page 11: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/11.jpg)
Oracle APEX – Development Features
Reports
Forms
Charts
Calendar
Templates
Navigation
Validations
Processes
Computations
Branches
Web Services
Email Services
Translation Services
Conditional Processing
Authentication
Authorization
Session State Management
Logging & Monitoring
![Page 12: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/12.jpg)
Interactive Report Enhancements
![Page 13: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/13.jpg)
Oracle APEX 4.0 – Interactive Reports
• Out-of-the-box declarative Web 2.0 reporting
![Page 14: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/14.jpg)
Oracle APEX 4.0 – Interactive Reports
• Search Bar• Quick Text-Search on all or select columns• Actions Menu Button
• Actions Menu • Formatting• Number of Rows• Charting• Saving & Sharing• Exporting
• Column Sorting and Filtering • Column-Header menu for easy Sorting, Filtering and Break-Formatting• More granular control via Actions Menu
![Page 15: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/15.jpg)
Oracle APEX 4.0 – Interactive Reports
• Control Break, Highlighting, Compute Columns and Aggregate
• Saving and sharing of customized reports • Saving Interactive Report customizations for future use• Sharing with other users by saving reports as public• Selection via Saved-Reports select list in Actions Menu
• Logging of Search Criteria
• Notification• Scheduled notification • Email send to user including static HTML version of report data
• Report, Detail and Icon View
• Single-Row View
• Charts
![Page 16: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/16.jpg)
D E M O N S T R A T I O N
Oracle APEX 4.0Interactive Reports
![Page 17: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/17.jpg)
Updated Flash Charts
![Page 18: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/18.jpg)
Oracle APEX 4.0 – Updated Flash Charts
• Updated Charting Engine using AnyChart 5
• New Flash Chart Regions
• Updated Interactive Reports, replacing AnyChart 4 with AnyChart 5
• AnyChart 3 and SVG based chart region types deprecated
![Page 19: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/19.jpg)
Oracle APEX 4.0 – Updated Flash Charts
• Column - , Horizontal Bar - , Pie - & Doughnut Charts
![Page 20: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/20.jpg)
Oracle APEX 4.0 – Updated Flash Charts• Scatter -, Candlestick and Line Charts
![Page 21: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/21.jpg)
Oracle APEX 4.0 – Updated Flash Charts
• Gauges, Gantt Charts & Maps
![Page 22: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/22.jpg)
• Interactive Reports – built-in Flash Charts• Updated to AnyChart 5
Oracle APEX 4.0 –Interactive Reports Charts
![Page 23: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/23.jpg)
Oracle APEX 4.0 – Updated Flash Charts
• New Create Page and Create Region Wizard for charts• Gallery of charts types • Additional chart attributes, minimizing need for XML customization• Declarative action link attribute
• Combined Charts • Available Multi-Series Bar and Column Charts• Add additional series using Bar -, Line - or Marker Charts
• Gantt charts included in the Chart wizard• Project and resource chart• Specific Gantt Chart attributes
• “Migrate to New Flash Chart”• Migrate option for SVG and AnyChart 3 based charts
![Page 24: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/24.jpg)
Oracle APEX 4.0 – Updated Flash Charts
• New Create Page and Create Region Wizard for Maps• Oracle APEX 4.0 includes AnyChart map charts• Over 300 different maps• Tree view for easy selection of the desired map• Support for multiple chart series queries
![Page 25: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/25.jpg)
D E M O N S T R A T I O N
Updated Flash Charts
![Page 26: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/26.jpg)
<Insert Picture Here>
Report Printing
![Page 27: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/27.jpg)
Oracle APEX with Oracle BI Publisher
• BI Publisher 10.1.3.2.1 or above• APEX calls “convert” Servlet through utl_http• Supports XSL-FO and RTF based templates• Template design using MS Word Plug-In• Output to PDF, Word, Excel, HTML and XML
![Page 28: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/28.jpg)
Oracle APEX with Apache FOP
• Full Oracle Support using Oracle Containers for J2EE (10.1.3.2) or above
• APEX calls apex_fop.jsp through utl_http• Supports XSL-FO based templates• Template design using third party tools• Output to PDF and XML *)
*) other output formats supported using custom FOP code
![Page 29: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/29.jpg)
• Report Queries• Report generation based on one or more query result sets• WYSIWIG report design using Template Builder for MS Word • Inclusion of data driven charts and images• Referencing application session data
• Interactive Reports• Export of interactive report data to
PDF, Word, Excel, HTML and XML
• Classic Reports• Easy report printing using customizable
generic report layouts• Full support for custom RTF layouts
Oracle APEX Report Printing
![Page 30: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/30.jpg)
• Report Design with the BI Publisher Template Builder• Export report data as XML data file or XML schema definition
Oracle APEX Report Customization
<?xml version="1.0"?><ROWSET>
<ROW num="1"><EMPNO>100</EMPNO><ENAME>Jo Bloggs</ENAME><JOB>CLERK</JOB><SAL>100</SAL><DNAME>ACCOUNTING</DNAME>
</ROW><ROW num="2">
<EMPNO>100</EMPNO><ENAME>Jane Doe</ENAME><JOB>CLERK</JOB><SAL>100</SAL>
</ROW>...
</ROWSET>
![Page 31: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/31.jpg)
Template Builder Menu
Oracle APEX Report Customization
Insert Table/Form dialog
Inserted table structure
• Report Design• Load XML file into the BI Publisher Template Builder• Insert report objects as
fields, table or charts using wizards
• Save layout as RTF file• Deploy to APEX and
associate with report query or report region
![Page 32: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/32.jpg)
• Creating a PDF Report with Multiple Queries and Charts
• Create report query in APEX containing multiple result sets
• Design RTF Template combining one or more reports and charts
Oracle APEX Report Customization
![Page 33: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/33.jpg)
D E M O N S T R A T I O N
High-Fidelity Report Printing
![Page 34: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/34.jpg)
![Page 35: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/35.jpg)
Information:
http://otn.oracle.com/apex
Hosted Development:
http://apex.oracle.com
![Page 36: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/36.jpg)
© 2008 Oracle Corporation – Proprietary
![Page 37: Advanced Reporting And Charting With Oracle Application Express 4.0](https://reader034.vdocuments.us/reader034/viewer/2022052310/554fb0f3b4c905ad218b5247/html5/thumbnails/37.jpg)