Oracle Report Builder Enhancing Reports

This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports.

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.

Content Emphasis

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)

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.