Course Overview

Learn To:

• Enhance a report by modifying properties of a query, changing group structure an filtering data in a group.
• Build a report by creating queries.
• Enhance a report by creating columns.
• Identify the sections of the Layout Model.
• Identify the components in the Data Model view.
• Control the common layout properties.
• Create a link file.
• Identify the objects in the Data Model and the Layout Model to enhance matrix reports.
• Create nested matrix reports.

Skills-Based

Audience

Application Developers, DatabaseAdministrators, Designer/Developers and Technical Support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first part in this series Oracle Reports: Reports Fundamentals (course 62221).

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Match the Data Model objects with their characteristics.
• Change the structure of a group using the Data 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 using the Data Wizard.
• Match Oracle8 object columns and ref columns with their representation in reports.
• Create an external query by using the Object Navigator.
• Create ref queries by using the ref cursor query tool.
• Modify the properties of a query using Property Palette option in the Data Model.
• Create a data link between objects by using the link tool in the Data Model.
• Modify the database column to display the contents of a file by using the property palette.
• Identify the properties of a summary column.
• Create a formula column using the tool palette in the Data Model.
• Identify the uses of placeholder column.

• Identify the properties of the Layout Model sections.
• Match the Layout Model views with their properties.
• Create a default layout for a report by using the Report Wizard.
• Sequence the steps to create a default layout for a section of the report by using the Report Wizard.
• Display the layout view for a report section by using the section option.
• Apply conditional formatting to a layout object by using the Format option.
• Set properties for a report section by using the Property Palette.
• Add a new layout section to a report without overriding existing layouts by using the Report Wizard.
• Identify the situations in which layout mode buttons are used to facilitate layout modifications.
• Move a child object outside its enclosing parent object by using the Confine Mode button.

• Create a link file to display file contents in the Layout Model by using the tool palette.
• Create a chart using the Chart Wizard in the Layout Model.
• Embed an existing chart in the Layout Model using the tool palette.
• Display a multimedia file using a button.
• Match the pagination properties with their functions.
• Match the print properties with their functions.
• Identify the uses of field properties.
• Identify functions of the repeating frame properties.

• Match the matrix structure with the relevant Data Model objects.
• Match the matrix structure with the relevant the Layout Model objects.
• Identify the product order values to be set for creating matrix summaries in 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.

Click here for Secure Yahoo Order: Oracle Reports R6: Enhance Reports

Get Train in Oracle
Oracle Training CD

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