|
Provided by: Serebra Learning Corporation Oracle Report Builder: Enhancing ReportsReport Builder |
![]() |
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.
|
|
||||||||
- J asked: Hi, Can you please send information regarding this course. Price, Availability, etc... I am familiar with Oracle reports developer in customizing existing reports...mostly dealing with the Layout model, Data Model Layers... ***Not sure who would pay for the training....company or myself ***Either Online or Off-Site Training depending upon location of off-site facility.
- D asked: how to create formulas in oracle reports builder
- A asked: i want oracle report training
- M asked: i want a free pdf's toturial of this course ,if possible. thanks
- D asked: My company currently has Oracle Reports Developer iDS, Release . Is there a class that covers this release?
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.
Objective
- 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
Minimum RequirementsThe 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

