Oracle Report Builder: Enhancing Reports

Application developers database administrators designer/developers and technical support professionals. Prior to taking this course participants should be familiar with SQL and PL/SQL and PL/SQL Database Programming or have taken courses 61110 61111 61112 and 60131. In addition participants should have taken the first part in this series course 61221.

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

Unit 1: Enhancing a Report - Data Model

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

Unit 2: Enhancing a Report - Layout Model

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

Unit 3: Modifying the Layout Object - Properties

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

Unit 4: Enhancing Matrix Reports

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

8

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

CDROM