Custom Search

Oracle Report Builder Report Fundamentals

123-CBT Computer Based Training
Training Provided by 123-CBT Computer Based Training

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

Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should familiar with SQL and PL/SQL using Procedure Builder and PL/SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131.

Total Learning Time

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.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
cd romThis program may be available on CD
Contact 123-CBT Computer Based Training for more information
Training Presented in:English
Oracle Report Builder Report Fundamentals --
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...
Sell databases enterprise training?
tcw11-gfc-v396M-10/25/09-10:01:01-()[A]-[B]-[B] -20:10:13