Oracle Reports: Report Fundamentals

This course is the first in a three-part Oracle Reports series that is based on Oracle Reports release 6. Oracle Reports the reports component of Oracle Developer is used to centralize report processing and to improve report management. It contains Report Builder a program used to create effective and professional reports. The Report Fundamentals course includes detailed Report Builder concepts. It also features the whole suite of Oracle Reports components and their capabilities for people who are computer literate and who want to gain basic skills in creating efficient reports and building integrated applications. The course familiarizes the learner with the features and components of Oracle Developer release 6. It comprises information on the Main menu interface environment variables and the method to customize an Oracle session in Oracle Developer. The course also introduces the learner to the standard design styles output destinations and execution methods of a report in Oracle Reports. The key features of Oracle Reports such as the Report Builder executables module types the Report editor views Report Builder editor objects and the Reentrant Wizard are also a part of the course. In addition this course will help students learn how to create and modify the different types of reports such as Tabular Form-like Break Mailing Label and Matrix report styles. The student learns how to use the Live Previewer document a report convert a report design file (.RDF) to a runtime executable program (.REP) and migrate report definitions from Developer/2000 Release 2 to Oracle Reports Release 6.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Application developers database administrators designer/developers and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures Functions and Packages (60114); and Oracle PL/SQL: Database Programming (60131).

Objective

• List the features and components of Oracle Developer.
• Identify the components of Report Builder and the environment variables.
• Set preferences to customize an Oracle Developer session using the Preferences dialog box.
• Describe standard report design styles and the guidelines for efficient report design.
• Run a report in Oracle Developer.
• Locate the destinations for a report.
• Split a large page horizontally or vertically using the Runtime Previewer.
• Invoke Report Builder.
• Identify the Report Builder module types.
• Match the Report Editor views with their uses.
• Match the different categories of objects available in a Report Module with their descriptions.
• Create a report by using the Report Wizard the reentrant Report Wizard and the Create button.
• Create Form Like Break Mailing Label and Matrix types of reports using the reentrant Report Wizard.
• Recognize the features of Live Previewer.
• Modify reports in the Live Previewer.
• Identify the situations to save a report module to a database and the search file order used by Oracle Developer.
• Match report file types with their descriptions and portability limitations.
• Convert a .rdf file to a .rep file.
• Document a report using Report Builder.
• Identify the tasks to migrate a report from Developer/2000 Release 2.

Topics Include

Unit 1: Oracle Developer: Report Builder

• Select the features of Oracle Developer.
• Match the components of Oracle Developer with the tasks that they enable.
• Select the common features of Oracle Developer Builder components.
• Set preferences to customize an Oracle Developer session using the Preferences dialog box.
• Match the Oracle Developer environment variables with their descriptions.
• Match the report design styles with their graphical representation.
• Identify the guidelines for efficiently designing a report.
• Run a report using the Reports Runtime menu item.
• Match the report output with its destination options.
• View large pages by splitting a page horizontally or vertically by using the Runtime Previewer.

Unit 2: Building a Tabular Report

• Invoke Report Builder by using the Oracle Developer Menu.
• Identify the Report Builder module types.
• Match the Report Editor views with their uses.
• Match the Report Level objects with their uses.
• Match the Data Model objects with their uses.
• Identify the descriptions of the Layout Model objects.
• Identify the functions of the Parameter Form objects.
• Identify the relationship between the objects in the Report Editor.
• Match the tab pages in the Report Wizard with their uses.
• Create a query using the Query Builder in the Report Wizard.
• Select the fields to be displayed from a list of available fields by using the Report Wizard.
• Create a summary by using the Report Wizard.
• Edit a label by using the Report Wizard.
• Select a template from a list of predefined templates by using the Report Wizard.
• View a report in different view sizes by using the Live Previewer.

Unit 3: Building Additional Report Layout Styles

• Invoke the reentrant Report Wizard by using the Report Editor Tools menu option or the Shortcut menu.
• Create a new report using the Create button.
• Identify the features of a Form-like report.
• Create a Group Left report from an existing report by using the reentrant Report Wizard.
• Create a Mailing Label report from an existing report by using the reentrant Report Wizard.
• Create a Matrix report from an existing report by using the reentrant Report Wizard.

Unit 4: Using the Live Previewer

• Identify the features of the Live Previewer.
• Align columns by using the Live Previewer.
• Set a specified format mask for a numeric field by using the Live Previewer.
• Manipulate objects to change the size and position by using the Live Previewer.
• Edit boilerplate text by using the Live Previewer.
• Modify visual attributes by using the Live Previewer.
• Create conditional formats using the Format Exception dialog box.
• Insert page numbers in a report by using the Live Previewer.
• Insert the current date and time in a report by using the Live Previewer.

Unit 5: Report Storage and Migration Methods

• Identify the situations in which a Report Builder module must be saved to a database.
• Match report file types with their descriptions.
• Convert a report definition (.RDF) file to a runtime executable program (.REP) file using the conversion utility.
• Match report file types with their portability features.
• Identify the order in which Oracle Developer searches for a referenced file.
• Document a report by using Report Builder.
• Select the tasks to migrate report definitions from Developer/2000 release 2 to release 6.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Web Based Training

• Oracle Reports: Controlling Reports
• Oracle Reports: Enhancing Reports