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 Oracle 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
Type	SQL Query
Data	Query Statement	Paste in SQL from tutorial_sql.txt
	Connect	Obtain connection string from your DBA.
Group	Group Fields	MGR_NAME
Totals	Total Fields	SALARY:Sum

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 to Displayed list)
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".

Gra

Table A-3 Graph Wizard Input

Graph Wizard Page	Field	Input
Type	Type	Bar
Position	Positions	At the beginning of the report
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
Title	Show Title	Check the box and type "Salary Comparison"
Legend	Show Legend	Deselect
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 Generating a 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 SumSALARYPerReport SumSALARYPerReport1 SumSALARYPermgr_name SumSALARYPermgr_name1 SALARY
Totals		Salary, Sum
Labels	All labels	Change labels to be meaningful.
Templates	Predefined Templates	Beige