Skip Headers
Oracle® Reports Tutorial
10g Release 2 (10.1.2)
B14364-01
  Go To Documentation Library
Library
Go To Product List
Product
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

A Quick Reference Guide

This appendix contains tables that describe the entries you make into each wizard in Reports Builder. These tables are meant to be a quick reference guide for you to use later, or for you to use if you are familiar with the wizards in Reports Builder.

A.1 Entries for the Data Wizard

Table A-1 lists the entries you made in the Data Wizard in Chapter 2, "Adding Data to a Report".

Table A-1 Data Wizard Input

Data Wizard Page Field Input

Query

Name

Employee Salaries

Data Source

SQL Query


Data

Query Statement

Paste in SQL from:

<example files>/tutorial_sql.txt.


Connect

Obtain the connection string from your DBA

Group

Group Fields

MGR_NAME

Totals

Total Fields

Sum(SALARY)


A.2 Entries for the Report Block

Table A-2 lists the entries for the report block in Chapter 4, "Creating a Report Block for the Web Report".

Table A-2 Report Wizard Input for the Report Block

Report Block Wizard Page Field Input

Title

Title

Direct Reports by Manager

Type

Group Above

Select

Groups

Available Groups

G_EMPLOYEE_ID, DOWN

Displayed Fields

Available Fields

All fields (move all fields to Displayed)

Totals


None

Templates

Predefined Templates

Beige


A.3 Entries for the Graph Wizard

Table A-3 lists the entries you made to the Graph Wizard in Chapter 6, "Creating a Graph for the Web Report".

Table A-3 Graph Wizard Input

Graph Wizard Page Field Input

Type

Type

Bar

X-Axis -Category

Available Columns

Move EMPLOYEE_ID and MGR_NAME to X-Axis Categories

Y-Axis - Data

Available Columns

Move SALARY to Y-Axis Data

Layout

Groups field

Drag EMPLOYEE_ID from the Groups field to the Bars field.

Title

Show Title

Select Show Title and type Salary Comparison

Legend

Show Legend

Select

X-Axis

Show X-Axis Title

Select Show X-Axis Title and type Employees

Y-Axis

Show Y-Axis Title

Select Show Y-Axis Title and type Salaries

Plot Area Options

Row 1 Color

Select a different color


A.4 Entries for the Report Wizard

Table A-4 lists the entries for the Report Wizard in Chapter 8, "Generating a Paper Report".

Table A-4 Report Wizard Input for the Paper Report

Report Wizard Page Field Input

Layout

Create Paper Layout Only

Select

Type

Group Above

Select

Groups

Available Groups

(Do not change)

Displayed Fields

Available Fields

emp_name

mgr_name

SumSALARYPermgr_name

SALARY

Totals


(Do not change)

Labels

All labels

Change labels to be meaningful.

Templates

Predefined Templates

Beige