After completing FOCUS: Creating Complex Reports, the user should be able to:

	Use the rules for coding statements in FOCUS graph requests.
	Describe how to use advanced sorting techniques when creating reports.
	Create headings and footings, including positioning text.
	Rank and summarize numeric data.
	Create totals in your reports and print them.

Course Conventions and Databases

	Course conventions
	Course databases

Advanced Sorting Techniques

Sorting with ACROSS

Creating Matrix Reports

Advanced sorting techniques

Additional Formatting Options

Formatting headings and footings

Ranking Data

Ranking and summarizing numeric data

Subtotaling Operations

Printing subtotals

The WHEN Clause

Conditional formatting with WHEN

This course has the following features:

	A glossary
	A Skill Assessment

	FOCUS: Getting Started (FOCS01)
	FOCUS: Working with FOCUS (FOCS02)
	FOCUS: Basic Report Preparation (FOCS03)
	FOCUS: Creating Simple Reports (FOCS04)

	FOCUS: Additional Reporting Techniques (FOCS06)
	FOCUS: Fundamentals of Graphs (FOCS07)
	FOCUS: Advanced Graph Topics (FOCS08)
	FOCUS: Data Manipulation for Reporting (FOCS09)
	FOCUS: Advanced Screening Techniques (FOCS10)
	FOCUS: Creating File Definitions (FOCS11)
	FOCUS: Adjusting File Definitions (FOCS12)
	FOCUS: Accessing External Files (FOCS13)
	FOCUS: Basic MODIFY Requests (FOCS14)
	FOCUS: Segment Modification (FOCS15)
	FOCUS: Complex MODIFY Requests (FOCS16)
	FOCUS: Additional File Maintenance (FOCS17)
	FOCUS: Dialogue Manager and FIDEL (FOCS18)
	FOCUS: More Features of FIDEL (FOCS19)
	FOCUS: MAINTAIN Facility (FOCS20)
	FOCUS: Completing a MAINTAIN Application (FOCS21)