Oracle Developer Reports

3 days


This Oracle Reports course introduces the delegate to the main concepts of Oracle Reports Developer. It is designed to give delegates practical experience in designing and creating Web and paper Reports using the Oracle Report Wizard, to add dynamic report data to static HTML pages and to publish reports on the Web


This course is for programmers and developers who need a comprehensive introduction to Reports 10G. This course takes students though reports development in Developer Reports 10g. Beginning with basic report design and ending up with fully integrated applications rollout. The workshops are designed to mimic a true application building process

Skills Gained

To provide the skills needed to design and create Web and paper reports using the Report Wizard.


A working knowledge of SQL and PL/SQL is required. This can be obtained by attendance on the pre-requisite courses. Familiarity with basic XML and HTML would be an advantage

Pre-Requisite Courses

  • Oracle SQL
  • Oracle PL/SQL

Course Outline

The delegate will practice

  • Creating paper and web reports
  • Defining report queries
  • Building reports in various different formats
  • Applying queries, groups, calculations and summaries to a report
  • Editing and manipulating boilerplate and layout objects
  • Editing and enhancing the Web source code
  • Using Cascading Stylesheets in Web Reports
  • Building master/detail and matrix reports
  • Building and using report templates
  • Using PL/SQL to base reports on ref cursor queries
  • Using PL/SQL trigger code for validating and formatting reports
  • Adding dynamic web links to reports
  • Using XML and text pluggable data sources in reports
  • Using Parameters in Reports
  • Adding graphics to a report
  • Distributing and bursting reports
  • Tuning reports
  • Maximizing report performance using Oracle AS Reports Services
  • Publishing reports on the Web
  • Adding dynamic data to an HTML page

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Onsite3 2400 $2400 2019-06-16
Onsite4 3200 $3200 2019-06-16