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

Creating multiple IR on the same page


In APEX 4.2, we can have only a single IR on one page. Let us outfox this problem. The truth is, we can have only one IR on one APEX page and APEX won't let us create more. So, we will have to create one IR each on two separate pages and then put them together in one. This has been done in the reference application using first and second pages. We have used the object HTML tag to get the report of the second page on the first page. Report on the first page is a report on order_items while that on the second page is on order_line_items. I wanted to create a master-detail relation between the two reports, so I had to pass the order_id value from the first page to the second page. We cannot use the usual column links to set some page item because the report which we get on the first page, using the object HTML tag, can only be affected by the data attribute of the object tag. So I am using application items to set a link between the two pages. When the...