Advanced CIRS Reporting Modules

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)