Oracle Reports:An Introduction
- You can access data from any data source
- You can obtain the report data in a graphical representation by a query builder
- You can use default report templates or you can customize it if needed
- A live editor that allows you to modify paper report layouts in WYSIWYG (“what you see is what you get”) mode
- The ability to add dynamic report output to an HTML page by embedding custom JavaServer Page (JSP) tags within an HTML document
- You can graphically represent report data with the help of integrated chart builder
- You can use various web publishing tools that dynamically generate Web pages based on your data
- You can show the report data in various formats such as HTML, HTMLCSS, XML, PDF, PCL (Printer Control Language), Postscript, and ASCII
- Support for run-time customization
- You can execute dynamic SQL statements within PL/SQL procedures
- Seamless integration of Oracle Reports with OracleAS Portal for administering report security
- The ability to publish report output to portlets
- Tabular: One group
- Master-detail: Master-detail hierarchy (may be several levels)
- Master and multiple details: Two or more detail groups at the same level
- Matrix: Two masters, one detail
- A Web browser
- An OracleAS Portal application
- The command line, using the Start > Run option in Windows
- The OracleAS Reports Queue Manager
- A Java application
- A database trigger
- A customized menu in a Forms application
- A button in a Forms application
- RDF: Report Definition File: binary file containing source code
- REP: Report: binary file without source code
- JSP: JavaServer Page format
- HTML: HyperText Markup Language
- XML: Extensible Markup Language
- Report: A report definition
- Template: A skeleton definition containing common style and standards
- PL/SQL Library: A stand-alone library containing PL/SQL program units—procedures, functions, packages—that can be called from multiple reports
- Data: Data structure and data to be displayed
- Layout: Formatting information about how the data appears in the output
- A data model and a paper layout.
- A data model and a Web layout.
- A data model, a paper layout, and a Web layout.
- Report Wizard: The Report Wizard guides you through the steps to create a basic paper report. Each page of the wizard asks you for information to help you create your initial report.
- Data Wizard: This wizard helps you quickly define or modify a query for a multiquery data models.
- Graph Wizard: You can add a variety of charts and graphs, including true 3-dimensional graphs, to a report using the Graph Wizard. Charting is implemented in Reports Builder with the Oracle BI graph bean.
- Report Block Wizard: This wizard enables you to quickly create a JSP report by embedding report data into a Web page using Reports custom JSP tags.
Leave a Reply
Want to join the discussion?Feel free to contribute!