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