|
Provided by: Serebra Learning Corporation Oracle Reports: Controlling ReportsReport Builder |
 |
This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates creating and using parameters coding PL/SQL triggers exporting built-in package procedures using the Reports Server and developing reports for different environments. This course is based on Oracle's ILT course Oracle Developer: Build Reports.
|
|
||||||||||
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).
Objective
- 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 reportlevel triggers.
- Create a group filter.
- Create a validation trigger using the property palette in the data model.
- Create a format trigger.
- Create a reportlevel and library program unit.
- Identify the functions of the Report Builder builtin package.
- Modify report layout dynamically using the builtin package.
- Control report output using the builtin 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 charactermode reports.
- Identify the steps for developing reports in different languages using national language support and Translation Builder.
Topics Include
Unit 1: Developing Report Templates
- 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.
Unit 2: Creating and Using Report Parameters
- 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.
Unit 3: Coding PL/SQL Triggers in a Report
- 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.
Unit 4: Report Builder Built-In Package
- 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.
Unit 5: Using the Reports Server
- 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.
Unit 6. Reports for Different Environments
- Identify the features of the different environments used for developing reports.
- Identify the factor to be considered while developing character mode reports.
Duration
8
Minimum Requirements
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).
Media
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
