Course Overview

Learn To:

• Identify and modify the regions of a report template.
• Identify the steps to register your own predefined template and add an image to it.
• Create and reference user parameters in a query.
• Create valid lists of values for parameter input.
• Identify the system parameters.
• Build and customize a parameter form.
• Create report-level triggers.
• Create a group filter.
• Create a validation trigger using the property palette in the data model.
• Create a format trigger.
• Create a report-level and library program unit.
• Identify the functions of the Report Builder built-in package.
• Modify report layout dynamically using the built-in package.
• Control report output using the built-in package.
• Identify components of the three-tier architecture of the Reports Server.
• Identify the settings to configure a remote server.
• Identify different methods for running and monitoring a report on a remote server.
• Identify the different development and runtime environments, and development factors for report execution in different GUI's.
• Identify the development factors to be considered for character-mode reports.
• Identify the steps for developing reports in different languages, using national language support and Translation Builder.

Skills-Based

Audience

Application Developers, Database Administrators, 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 two parts in this series: Oracle Reports: Reports Fundamentals (course 62221); and, Oracle Reports: Enhancing Reports (course 62222).

Total Learning Time

6 - 8 Hour(s)

Course Contents

• Match the regions of a report template with their uses.
• Customize the template margin.
• Customize the template body.
• Sequence the steps to register a customized template.
• Sequence the steps to add a template image in the template directory.

• Create a user parameter by using the Create button.
• Identify the purpose of user parameter properties.
• Identify the different methods of referencing a user parameter in a report.
• Create a static list of values.
• Create a dynamic list of values.
• Display a currency symbol by using the CURRENCY system parameter.
• Build a parameter form.

• Identify time when specific Report Builder triggers fire during report execution.
• Match the report-level triggers with their 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 for a parameter.
• Create a format trigger for a layout object by using the property palette.
• Create report-level and library program units by using the Object Navigator.

• Match the contents of the Report Builder built-in package with their purpose.
• Display a message by using a Report Builder packaged procedure.
• Restrict the number of records retrieved for a query by using a Report Builder packaged procedure.
• Initialize the value in a layout field by using a Report Builder packaged procedure.
• Create a drill-down report by using a Report Builder packaged procedure.
• Execute a SQL statement in a report by using a Report Builder packaged procedure.

• Differentiate between multi-tier and client-server reporting.
• Identify the three tiers in the multi-tiered server environment.
• Identify the parameters for configuring a remote server.
• Identify the commands that are required to connect to the server.
• Identify purpose of the Queue Manager.
• Schedule a report on a remote Reports Server.
• Identify the privileges of an administrator.
• Identify the parameters for running and scheduling a report using RWCLI60.
• Identify the method of invoking a report from another application, by using Reports ActiveX Control.

• Identify the features of the different environments used for developing reports.
• Identify the factor to be considered while developing character mode reports.

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

Get Train in Oracle
Oracle Training CD

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