Custom Criteria for Part I: Report Criteria:

One of the options is to write customized criteria in the custom criteria box. This allows you to write criteria using fields other than those on this screen, or to write criteria that use "or" statements. If you ever want to write a report using customized criteria, you can email jleonard@skillslibrary.com for assistance. Or, if you are familiar with SQL language or comfortable learning how to write these statements, you can experiment and write your own criteria. For example, you could write the following criteria:

Custom Reports in Part II: Reports

One of the sections on the list of reports provides a custom-report routine. There are two types of custom reports. One will provide a list, based on fields that you check off on the list of fields. The other will provide a count, also based on fields that you check off on the list of fields. Custom reports can be saved and run again. The image below shows the custom report screen for creating a list. You can check the fields you want; sort by any field; and add "Where" criteria to select certain records. If you don`t want to sort or select particular records, you can leave "PlanID" and "PlanID greater than 0" on the screen. A similar screen allows you to create a count of records for any subgroups, such as a count by employer name or a count by activity name.

Check the Database Field List in this website to learn more about the field names used on these screens.