Welcome

Welcome to the Oracle9i Reports Tutorial. This manual will help you get started using Oracle9i Reports, as well as introduce you to publishing data to the Web and paper.

Note: For the latest updates to the Oracle9i Reports Tutorial, refer to the Oracle Technology Network (http://otn.oracle.com/products/reports/), then click Getting Started with Oracle9i Reports and use the index to navigate to the Oracle9i Reports Tutorial.

This preface includes the following sections

Section	Location
"Intended Audience"	Page 1
"Prerequisites"	Page 2
"Structure"	Page 2

Intended Audience

This manual is intended for those users who are new to Oracle Reports, as well as those who are familiar with previous versions, but would like to learn more about some of the major new features in Oracle9i Reports.

Prerequisites

The exercises in the tutorial use the Human Resources sample schema provided with the Oracle9i database and an HTML template. We've also provided a text file containing the SQL you will enter, as well as the JSPs you create in every chapter.

You can download these files from the Oracle Technology Network (http://otn.oracle.com/products/reports), then click Getting Started with Oracle9i Reports and use the index to navigate to the Oracle9i Reports Tutorial Sample Files. You can also find the files by opening the Getting Started with Oracle9i Reports Web site on your product CD. We recommend that you copy the files into a local directory, such as d:\Reports_Tutorial.

Sample Schema

This tutorial relies on the data contained in the Human Resources section of the sample schema. This sample schema is provided with the Oracle9i database.

Viewing Web Reports

To produce the Web-based report, you must have a Web browser installed on your machine. The minimum and recommended requirements are:

• Microsoft Internet Explorer 4.x or higher

or

• Netscape Communicator 4.x or higher

Viewing the Web Source

Although you can view the Web source for your JSP report in Reports Builder, this tutorial also shows you how to analyze your Web source in a text editor. We recommend you use a text editor like NotePad (on Windows NT) or UltraEdit.

Structure

This manual contains the following chapters.

Overview

This chapter describes the tutorial scenario and what the chapters will help you achieve.

Lesson Chapters

The lesson chapters contain the procedures for producing the reports. These chapters step you through the Report Wizard, adding report blocks, and the Graph Wizard. If you are already familiar with using these features, you can use the Quick Reference guide, located in Appendix A.

Output Review Chapters

The output review chapters review what you did in the lesson chapters. These chapters explain the JSP tags and code for the JSP-based Web report.