Report Builder : Controlling Reports

Duration: 8 Hours
Training Method: Technology Based Training Title Technology-Based Training Title

Description:
This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps learners to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, the course covers the building of reports for different environments.

System and Software Requirements
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 running is 640 x 480 or higher resolution
Double-speed (or higher) CD-ROM drive
An MPC-compliant sound card with attached speakers or headphones (multimedia version only)

Purchase this Title

Audience:
  • Application Developers
  • Database Administrators
  • Designer/Developers
  • Technical Support Professionals

Required Prerequisites:

Suggested Prerequisites:

Course Objectives:

  • Modify template regions
  • Register a predefined template
  • Add an image to a predefined template
  • Create and reference user and system parameters
  • Create valid lists of values for parameter input
  • Identify different types of triggers in report, data and layout models
  • Create report-level, data model, and layout model triggers
  • Identify the functions of the SRW package
  • Identify the various SRW packaged procedures used for message display, field initialization, data restriction, format attribute setting, report creation, SQL statement execution
  • Identify the factors to be considered for developing reports for execution in different GUIs, environments, and languages
  • Identify the different development and runtime environments
  • Identify the regions of a report template
Return to top

Course Topics:

Developing Report Templates

Creating and Using Report Parameters

Coding PL/SQL Triggers in a Report

Report Builder Built-In Package

Reports for Different Environments

Return to top

Suggested Next Courses:
    Please check with your Education Representative to determine the appropriate follow up course.
Return to top

Related Instructor Led Courses:
 Return to top