Oracle SQL

Oracle PL/SQL

Oracle Forms

Oracle Reports

Residential Courses

Prices

Location

Oracle Report Builder: Controlling Reports
Computer based training course 

Course ID: 61223

Course Overview

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.

Learn To:

• 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 report-level, 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.

Content Emphasis

Skills-Based

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 using Procedure Builder and PL/SQL Database Programming, or have taken courses 61111, 61112, 61113, and 61114. In addition, participants should have taken the first two parts of this series, courses 61221 and 61222.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Developing Report Templates

Duration: 1.5 - 2 Hour(s)

• 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

Duration: 1.5 - 2 Hour(s)

• 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

Duration: 1 - 2 Hour(s)

• 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

Duration: 1 Hour(s)

• 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

Duration: 1 Hour(s)

• 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.

Anglesey has over 125 miles of coastline designated "areas of Natural Outstanding Beauty".

Tyn Y Felin is a mere five minutes away from the A55 North Wales Coast Expressway and is a perfectly situated coastal retreat on the serene and beautiful Isle of Anglesey.