The modules below provide instruction on how to use FOCUS commands to develop more complex ad hoc report requests and enhance the appearance of printed reports. Specifically, they give examples of FOCUS commands for retrieving data and customizing reports (formatting), creating new fields (defines) and combining data from multiple files and/or segments (matching). The information in these modules presumes you are familiar with the material presented in Basic CIRS Reporting Modules.
To download the entire workbook, select a link below:
Advanced CIRS Reporting Workbook (.zip)
Module 1, Introduction (PDF)
Welcome
How To Use This Workbook
Assumptions
Resources
Module 2, Requesting Data (PDF)
Overview
Implied Prompting
Multiple Display Commands (Verb)
Prefix Operators
What You Have Learned
Module 3, Sorting Report Data (PDF)
Overview
Ranked By
In-Groups-Of
Columns
Rows
What You Have Learned
Module 4, Customizing Printed Reports (PDF)
Overview
Embedded Values
Positioning Columns
Nosplit
Skip-line
Under-line
Fold-line
Page-Break Repage
Subhead / Subfoot
On Table Subhead / Subfoot
Practice
What You Have Learned
Module 5, Creating Temporary Fields (PDF)
Overview
Compute Command
Define Command
Types Of Define Expressions
Date Define
Numeric Define
Alphanumeric Define
Edit Define
Concatenation Define
Conditional Define
Practice
What You Have Learned
Module 6, Holding And Matching Files (PDF)
Overview
Holding Files
Matching Files
Practice
What You Have Learned
Module 7, Closeout (PDF)
Recommendations For Successful Reporting
Ad Hoc Report Procedures
Practice Set
Practice Set Answers
Appendix A, Contacts (PDF)
Appendix B, Campus Codes (PDF)
Appendix C, Frequently Used Files (PDF)