Skip Headers
Oracle® Fusion Middleware Oracle Reports Tutorial
11g Release 1 (11.1.1)

Part Number B32123-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 5, "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


A.5 Reference Material

You create a reference-type chapter or appendix by using the following elements inside the RefEntry element within a chapter or appendix template file.

Note:

You do not need the template file ref_chap.fm to create a reference-type chapter or appendix. All elements and formats you need to create reference-type documentation are in the chapter.fm or the appendix.fm template.

You can include Sectn elements at the beginning of a chapter or appendix that contains reference information. However, once you insert a RefEntry, you can no longer insert Sectn elements. Therefore, place all narrative or tutorial-type text at the beginning of a chapter or appendix, before reference information.