Contents
- Index
- Next
Including and Excluding records
Macros/Sort
Before you can include and exclude records you must already have your data loaded into memory by opening an individual (CI) or game (CG) report. You use these 2 functions when working with individual and game data. Both functions can be accessed from the Macros/Sort menu on the main menu bar.
Including records - Including records is the process of showing a record that was previously hidden. Before including data in a report you must first Exclude all records. This will give you a blank report. You can now include just the data you want in your report.
Excluding records - Excluding records is the process of hiding a record that is currently being shown in the report. Before excluding data in a report you must first Include all records. You can now exclude just the data you want from the report.
Generally these 2 functions should not be mixed, use one or the other for each report. For example, suppose you want only records in the report for home games played during the day. You have 2 ways of going about doing this.
Using Include - First exclude all records. Now include just home games using the include records menu. Then include just day games from the include records menu. Mission accomplished, your report now contains only player records for home games played during the day.
Using Exclude - First include all records. Now exclude just away games using the exclude records menu. Then exclude just night games using the exclude records menu. Again your mission is accomplished, using this method produces the exact same report as method 1.
Note that after using include or exclude you will usually use the compression function to finish your report. By combining include, exclude, compress and qualify, you will be able to create an unlimited number of complex reports.