Oracle9i AS Reports Services & Oracle9i Reports Developer
Oracle9iAS Reports Services, the flexible and powerful solution for Web and paper publishing, enables you to publish any data in any format, anywhere. Oracle9iAS Reports Services is part of Oracle9i Application Server.
Oracle9i Reports accommodates a variety of possible data sources:
Additionally, you can add your own, custom data source by leveraging the Pluggable Data Source (PDS) API of Oracle9i Reports. It is a documented Java API that allows you to create native access mechanisms for data formats that are unique to your business.
Both areas of publishing are possible with Oracle9i Reports. Paper Layout enables you to design high-fidelity, boardroom -uality reports and either print them or create files in various formats (e.g. RTF, HTML/HTMLCSS, PDF) for presentation online. Web Source enables you to "inject" dynamic content into standard Java Server Pages to create "real" Web pages. Additionally, the Paper Layout can be stored in XML format within the JSP file. This way, you have one file that can be used for both Web and paper publishing.
You can also use Oracle9i Reports for generating data interchange formats, such as delimited or XML. This way a single report can be used to provide three vital parts of modern data publishing:
The bursting feature of Oracle9i Reports enables you to create multiple personalized reports out of a single report model. For example, you can create an employee report for all your departments and send an email with a PDF-attachment containing the report to each manager. Each attachment would contain only the relevant department information for the particular manager. All these reports could be created in a single pass and distributed by email to each manager.
Oracle9i Reports provides a powerful destination infrastructure that allows you to publish your output to any source you want. Out of the box, Oracle9i Reports ships with the support for a variety of destinations:
By leveraging the Pluggable Destination API, a Java based interface, you can create your own destination drivers and thereby extend the functionality of this feature.