Oracle SQL

Oracle PL/SQL

Oracle Forms

Oracle Reports

Residential Courses

Prices

Location

Oracle Report Builder: Report Fundamentals
Computer based training course

Course ID: 61221

Course Overview

This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report definitions from Developer/2000 Release 1 to Developer/2000 Release 2.

Learn To:

• Identify the features and components of Report Builder.
• Identify standard report design styles.
• Invoke Report Builder.
• Identify the destinations for a report.
• Identify the options in the Live Previewer.
• Run a report in Developer/2000.
• Match a report's executable filenames, the Report Builder module types, the Report editor views and the Data Model objects with their descriptions.
• Create a report using Report Wizard.
• Identify the features of Live Previewer.
• Modify reports in Live Previewer.
• Identify report file types.
• Match report file types with their 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 1.

Content Emphasis

Skills-Based

Audience

6 - 8 Hour(s)

Course Contents

Unit 1: Developer/2000 Report Builder

Duration: 1.5 - 2 Hour(s)

• Identify the feature of Developer/2000
• Match the components of Developer/2000 with the tasks that they enable.
• Invoke Report Builder by using the Project Builder.
• Identify the common features of Developer/2000 components.
• Identify the features of Oracle Toolkit.
• Identify the features of the Developer/2000 main menu.
• Set preferences to customize a Developer/2000 session by using the Preferences dialog box.
• Identify the description of the main environment variables.
• Match the report design styles with their graphical representations.
• Identify the guidelines for efficiently designing a report.
• Identify the methods of invoking a report.
• Identify the method to cancel report execution.
• Identify the destination options for viewing the report output.
• Label the options available in the Previewer.
• Split the Previewer window to view large pages.

Unit 2: Building a Standard Tabular Report

Duration: 1.5 - 2 Hour(s)

• Match the report executable files with their functions.
• Identify the Report Builder module types.
• Match the Report Editor views with their uses.
• Match the report level objects with their uses.
• Identify the different categories of objects available in a Report Module.
• Match the Data Model objects with their uses.
• Match the Layout Model objects with their descriptions.
• Identify the functions of the Parameter Form objects.
• Identify the statements that describe the interrelationship among the objects in the Report Editor views.
• Identify the definition of the report wizard.
• Create a query by 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 created by using the Report Wizard in the Live Previewer.

Unit 3: Building Additional Report Layout Styles

Duration: 1 - 2 Hour(s)

• Enter the wizard by using the specific methods.
• Create a new report by using the Create button.
• Identify the features of a Form Like report.
• Generate a Group Left report from an existing report by using the Report Wizard.
• Generate a Mailing Label report from an existing report by using the Report Wizard.
• Generate a Matrix report from an existing report by using the Report Wizard.

Unit 4: Using the Live Previewer

Duration: 1 Hour(s)

• Identify the features of the Live Previewer.
• Align the columns in the Live Previewer.
• Set a specified format mask on a numeric field in the Live Previewer.
• Manipulate objects in the Live Previewer.
• Edit boilerplate text in the Live Previewer.
• Modify visual attributes in the Live Previewer.
• Insert page numbers to a report in the Live Previewer.
• Insert the current date and time in a given report in the Live Previewer.

Unit 5: Report Storage Methods

Duration: 1 Hour(s)

• Identify the situations in which a Report Builder module needs to be saved to a database.
• Match the types of report files with their descriptions.
• Convert an .rdf file to a .rep file by using the conversion utility.
• Match the types of report files with their portability features.
• Sequence the order in which Developer/2000 searches for a file referenced in Report Builder.
• Document a report by using Report Builder.
• Identify the tasks that are performed to migrate report definitions from Developer/2000 Release 1 to Developer/2000 Release 2.

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.