After completing this course, the student should be able to:
 

	Utilize ACROSS and other advanced techniques to sort data
	Customize report output with additional formatting techniques, including ACROSS, subtotaling operations and WHEN conditions
	Use the JOIN and MATCH commands to report from more than one file at a time
	Save report output using the HOLD, PCHOLD, SAVE and SAVB options
	Utilize alternate file views and TABLEF to change the way FOCUS retrieves data

Course Conventions and Databases
Reviews rules for coding FOCUS statements.  Covers the conventions and databases used in the course.
 

	Course Conventions Rules for coding FOCUS statements.  Standards used when showing the format of FOCUS commands, simulating FOCUS sessions, entering TABLE requests and displaying output.  Four ways to create reports in FOCUS.
	Course Databases Master File Descriptions and diagrams.

More Sorting Techniques
Covers additional sorting techniques.  Discusses the ACROSS phrase and also COLUMNS, NOPRINT, SUP-PRINT and matrix reports.  Covers multi-path files and how to write requests with more than one verb.
 

	Sorting with ACROSS How to use ACROSS to sort data by columns.  Data sort order changes using HIGHEST with ACROSS.  Column printing with COLUMNS and ACROSS.
	Advanced Sorting Techniques Suppression of printing with NO-PRINT and SUP-PRINT.  Matrix reports using BY and ACROSS together.  Multi-path file printing.

More Formatting Options
Presents additional formatting options to use when printing reports.
 

	Formatting Headings and Footings Text positioning in headings and footings.  Field values embedded in headings and footings.  Non-tabular report creation.
	Ranking and Summarizing Numeric Data How to use HIGHEST, LOWEST or TOP to specify how many BY fields to print.  Numeric ranking in reports.  Row and column totals.
	Printing Subtotals How to use SUBTOTAL and

SUB-TOTAL to subtotal numeric fields.  How to use SUMMARIZE and RECOMPUTE to subtotal and recalculate computed fields.  How to use RECAP and COMPUTE to include subtotaled values in calculations.
 

Conditional Formatting with WHEN How to conditionally print formatting and subtotal lines with WHEN.  Multiple ON options in a report request.

Multiple File Reporting
Covers how to report from separate databases using the JOIN and MATCH commands.
 

	The JOIN Command JOIN structure creation and naming.  Diagram of JOIN structure using the CHECK FILE command.  How to use the JOIN utilities JOIN * and JOIN CLEAR.
	The MATCH Command MATCH file creation and naming.  When to use MATCH instead of JOIN.

Saving Report Output
Presents the use of HOLD, PCHOLD, SAVE and SAVB files to save report output.
 

	HOLD and PCHOLD files Guidelines for using extract files.  How to use HOLD and PCHOLD to save output.  Various formats in which to save output.
	SAVE and SAVB files How to use SAVE and SAVB commands to save output.  Differences of SAVE and SAVB from HOLD.

Advanced Reporting Techniques
Introduces alternate file views and TABLEF as advanced ways to create reports.
 

Alternate File Views and TABLEF Alternate file view creation with indexed and non-indexed fields.  Differences between TABLE and TABLEF commands.  How to use the TABLEF command to create reports.