The Developer/2000: Build Reports Curriculum consists of the following courses:

Oracle Report Builder: Report Fundamentals
Oracle Report Builder: Enhancing Reports
Oracle Report Builder: Controlling Reports

Course Overview

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.

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

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

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

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

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

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

Course Overview

Learn To:

• Enhance a report using the Data Model.
• Understand the Layout Model layers.
• Enhance a report by modifying the layout in the Layout Model editor.
• Understand the contents of a file at runtime.
• Control the pagination of the contents and other objects in the report output by modifying the object properties.
• Enhance the matrix reports by modifying the objects in the Data Model and the Layout Model.

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 60111, 60112, 60113 and 60131. In addition, participants should have taken the first part in this series, course 61221.

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Match the Data Model objects with their characteristics.
• Identify the advantages of modifying the properties of a query statement.
• Change the structure of a group in the Object Navigator.
• Update the layout of a report using the Report Wizard.
• Identify the methods of ordering data in a group.
• Create a group filter by using the Property Palette dialog box.
• Add new data to a report by creating a query in the Data Model.
• Create an external query by using the Object Navigator.
• Create a data link between objects by using the link tool in the Data Model.
• Identify the instances where it will be advantageous to use a single query or a multiple query.
• Match the Data Model column types with their functions.
• Identify the properties of a summary column.
• Create a formula column using the tool palette in the Data Model.
• Identify the uses of the placeholder column.

• Identify the descriptions of the Layout Model regions.
• Design a multipanel report by modifying the logical and physical panel properties of objects in the Layout Model.
• Sequence the layers of a tabular report in the Layout Model.
• Sequence the steps in report processing.
• Identify the situation in which the confine mode and the flex modes are used to avoid common hierarchy errors.
• Match the components of the tool palette with the tasks that they enable.
• Create a variable length line between columns of a report in the Live Previewer using the tool palette.
• Create a button in a report using the tool palette in the Layout Model.
• Create an explicit anchor using the tool palette in the layout model.
• Sequence the steps to suppress space in a conditional report using explicit anchors.
• Create a chart using the Chart Wizard in the Layout Model.
• Embed a chart in the Layout Model using the tool palette.

• View the properties of multiple layout objects in Object Navigator simultaneously by opening the property palettes.
• Identify the relationship type to be used in a given situation.
• Create a link file object in the layout model using the tool palette.
• Identify the differences between the properties of a link file and a file column.
• Identify the properties that are common among the layout objects.
• Identify what the elasticity values specify.
• Match the pagination properties with their functions.
• Identify what the field properties are used for.
• Identify the functions of the repeating frame properties.

• Match the Data Model objects with the matrix structure.
• Match the Layout Model objects with the matrix structure.
• Identify the product order values to be set for creating matrix summaries for a given situation.
• Create a cross product group to build a nested matrix using the tool palette.
• Create a nested matrix summary for a report by using the Report Wizard.

Course Overview

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.

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 60111, 60112, 60113 and 60131. 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

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

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

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

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

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

Click here for Secure Yahoo Order: Developer/2000: Build Reports Curriculum

Get Train in Oracle
Oracle Training CBT

Best Regards,
Oracle Database, SQL, Application, Programming Tips