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

Integration with SAP crystal reports


SAP's crystal Reports shares the reporting market with Oracle products such as OBIEE and BI Publisher. Since Oracle APEX is a reporting and rapid application development tool, we should have a brief look at the way in which crystal reports can be integrated with APEX. Let's begin:

  1. Download Crystal report designer (development tool for crystal reports) from the following link:

    https://www.sap.com/campaign/ne/free_trial/crystal_reports_2011/index.epx?URL_ID=crcom&kNtBzmUK9zU=1

  2. Unzip 51043408.zip, go to 51043408\DATA_UNITS\CrystalReports and execute setup.exe to install the designer. You will get the Installation key code in the e-mail Id submitted while filling the form before downloading the installer. Use this code to install the product.

    If your system memory is a constraint then do a custom install, because the default installation installs the drivers for all kinds of data sources and makes arrangements for integration of Business Objects with tools...