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>
Table of Contents (17 chapters)
Oracle APEX 4.2 Reporting
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

DML operations and report filtering using DA, JavaScript, and page processes


This section is dedicated to understand the following two methods of report filtering and DML operations:

  • Filtering report and logging user selection using Dynamic Actions.

  • Filtering report and logging user selection using JavaScript and Page Process. We will see Advanced AJAX and two way communication between page process and JavaScript in this section.

We have two select lists, namely, P5_JOB_FILTER and P5_SALARY_FILTER on page 5 of the reference application. The first select list is a list of jobs and the second select list is a list of salaries. We will now use P5_JOB_FILTER to see the filtering of a report and logging of values using Dynamic Actions.

Filtering reports and logging values using Dynamic Actions

This section is dedicated to using Dynamic Actions for submitting the page and logging the values. Let's check it out. The Filter selected job id DA and the Ajax using Dynamic Actions DA are fired when a value...