Skip Headers

Oracle Reports Tutorial 10g (9.0.4) Part Number B10612-01 |
Home | Contents | Index

# 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're already familiar with the wizards in Reports Builder.

## A.1 Entries for the Data Wizard

The following table shows 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

The following table shows 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

The following table shows 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 | Check the box and type Salary Comparison
Legend | Show Legend | Select
X-Axis | Show X-Axis Title | Check the box and type Employees
Y-Axis | Show Y-Axis Title | Check the box and type Salaries
Plot Area Options | Row 1 Color | Select a different color

## A.4 Entries for the Report Wizard

The following table shows the entries for the Report Wizard in Chapter 8, "Generating a Paper Report".

##### Table A-4 Report Wizard Input for the Report Block

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

| Copyright © 2002, 2003 Oracle Corporation. All Rights Reserved. |
Home | Contents | Index