|
Provided by: 123-CBT Computer Based Training Oracle Report Builder Report Fundamentals |
![]() |
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.
|
|
||||||||||

