Oracle Report Builder: Controlling Reports

This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates code PL/SQL triggers in a report and use Report Builder's built-in package. Finally building reports for different environments will be covered.

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. Prior to taking this course participants should be familiar with SQL and PL/SQL and PL/SQL Database Programming or have taken courses 61110 61111 61112 and 60131. In addition participants should have taken the first two parts of this series courses 61221 and 61222.

Objective

• Identify the regions of a report template.
• Modify template regions
• Register a predefined template.
• Add an image to a predefined template.
• Create and reference user and system parameters.
• Create valid lists of values for parameter input.
• Identify different types of triggers in report data and layout models.
• Create reportlevel data model and layout model triggers.
• Identify the functions of the SRW package.
• Identify the various SRW packaged procedures used for message display field initialization data restriction format attribute setting report creation and SQL statement execution.
• Identify the different development and runtime environments
• Identify the factors to be considered for developing reports for execution in different GUIs environments and languages.

Topics Include

Unit 1: Developing Report Templates

• Match regions of a report template with their purpose.
• Customize the template margin.
• Customize the template body.
• Sequence the steps to register a customized template.
• Sequence the steps to add a template image.

Unit 2: Creating and Using Report Parameters

• Create a user parameter by using the Create button.
• Identify the purpose of user parameter properties.
• Distinguish between the ways of referencing a user parameter in a report query.
• Create a static list of values.
• Create a dynamic list of values.
• Identify the purpose of system parameter properties.
• Display a currency symbol by using the CURRENCY system parameter.
• Build a parameter form by using the menu bar.
• Identify the purpose of the parameter form properties.

Unit 3: Coding PL/SQL Triggers in a Report

• Identify the time when specific Report Builder triggers fire in a report execution phase.
• Select the report-level trigger that will be used for a specific purpose.
• Create a report-level trigger by using the Object Navigator window.
• Set a PL/SQL group filter by using the Property Palette for a group.
• Create a validation trigger by using the Property Palette for a parameter.
• Identify the features of a format trigger.
• Create a format trigger for a layout object by using the Property Palette.
• Create a report-level program unit by using the Object Navigator.
• Create a library program unit by using the Object Navigator.

Unit 4: Report Builder Built-In Package

• Match the contents of the SRW package with their functions.
• Display a message by using a SRW packaged procedure.
• Restrict the number of records retrieved for a query by using a SRW packaged procedure.
• Initialize the value in a layout field by using a SRW packaged procedure.
• Set the format attributes for an object by using the SRW packaged procedure.
• Create a drill-down report by using a SRW packaged procedure.
• Execute a SQL statement in a report by using a SRW packaged procedure.

Unit 5: Reports for Different Environments

• Identify the features of different environments.
• Identify the factors to be considered while developing the reports that will be executed in different graphical user interfaces (GUIs).
• Identify the guidelines to be considered while building bitmapped reports executed in the character mode environment.
• Identify the syntax of the NLS_LANG language environment variable.
• Sequence the steps to translate a resource file by using Translation Builder.

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

CDROM

• Oracle Report Builder: Enhancing Reports
• Oracle Report Builder: Report Fundamentals