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.
Each of the modules below are Word documents that can be downloaded from a password protected site. Contact the CIRS Hotline, if you are a CIRS user and need the userid and password to download. To download the entire workbook, select a link below:
Advanced CIRS Reporting Workbook (.zip, 144 KB)
Advanced CIRS Reporting Workbook (.exe, 212 KB)
Module 1, Introduction (38 KB)
Welcome
How To Use This Workbook
Assumptions
Resources
Module 2, Requesting Data (114 KB)
Overview
Implied Prompting
Multiple Display Commands (Verb)
Prefix Operators
What You Have Learned
Module 3, Sorting Report Data (101 KB)
Overview
Ranked By
In-Groups-Of
Columns
Rows
What You Have Learned
Module 4, Customizing Printed Reports (125 KB)
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 (138 KB)
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 (136 KB)
Overview
Holding Files
Matching Files
Practice
What You Have Learned
Module 7, Closeout (98 KB)
Recommendations For Successful Reporting
Ad Hoc Report Procedures
Practice Set
Practice Set Answers
Appendix A, Contacts (38 KB)
Appendix B, Campus Codes (50 KB)
Appendix C, Frequently Used Files (51 KB)