Training Tidbit: Printing A Range
Would you like to generate a report for a particular range of records? If so, on the Report Printing Options screen, enter the beginning information of the first records to print in the range in the From field for the desired parameter; then in the To field for that parameter, enter the beginning information of the last records to print in the range followed by a “z” at the end of the string. For example, to print the Vendor Detail Listing for all vendors that have an ID starting with an A through H, enter A in the From field for the Vendor ID parameter and enter Hz in the To field.
Below is an example of also using the “z” to print a range of account numbers on a report. This specific example will print all the particular instructional expense accounts containing an object in the 100s to 400s (or 6100s to 6400s for Missouri districts).
State | Account Number Parameter From Field | Account Number Parameter To Field |
Iowa………………….. | 10 1000 1000 100 0000 1……………… | 10 1000 1000 100 0000 4z |
Illinois……………….. | 10 1130 1……………………………………. | 10 1130 4z |
Missouri……………. | 10 1111 61………………………………….. | 10 1111 64z |
Nebraska…………… | 01 1100 1……………………………………. | 01 1100 4z |
North Dakota…….. | 01 00 200 120 1000 1………………….. | 01 00 200 120 1000 4z |
South Dakota…….. | 10 1111 001 1…………………………….. | 10 1111 001 4z |
Wyoming…………… | 01 110 1110 1…………………………….. | 01 110 1110 4z |
Note: The exact structure for the account number masks may vary from the examples since you may be utilizing a different account structure within your database. Also, be sure to key the |