Introduction

The Inspections Report Selector form gives you access to several inspection related reports. Some reports are permitted a filter, so you can include on the printout only the records that are of interest to you right now; however, most reports don't require a filter. A picture of the screen is below.

Selecting a Report

There are five different reports from which you can choose.

• Inspections: This is just the Inspections report. The Start Date and End Date fields will be visible allowing you to choose a date range. Only inspections that have an Inspected date that falls within the selected date range will appear on the report. See the Entering a Date Range section below for more information on using the date filter.
• Inspections List: When you select this option, a list of inspections will be shown. They will be grouped by the reason for the inspection be it complaint, request, routine, or one of the others that can be set up in the Codes table. With this report, not only can you select a date range, you can also choose one or more entries from the list of occupancy types. If you do not choose anything from the Occupancy Type box, then all records will show. If all you see in the data section of the report is #Error, then there were no records that matched the chosen date range and occupancy types. The occupancy type data also come from the Codes table.
• Inspections by Roll: To get a clearer view of what has happened with all properties, you can print the Inspections by Roll report. It includes a list of fire codes and corrective actions for each inspection. Of course this report will only be useful if the rolls are consistent. Since you may have to look through the report for rolls that were chosen incorrectly, there is no filter available for the roll number for this report.
• Inspections with Sub Roll: Generally, inspections are done against the entire property, so if a subordinate roll is chosen, it likely was in error. A subordinate roll has a 19 digit roll number that ends in something other than "0000." This report helps you clean up the data because it helps you to figure out why inspections are missing from or misplaced on the above Inspections by Roll Report.
• Inspections without a Roll: As well, you can get a list of inspections that do not have a roll associated with it. This is also useful in figuring out why inspections are missing from the Inspections by Roll Report.
   

Entering a Date Range

If the chosen report permits you to use the date filters, you can enter a start and end date for the inspections list. Filtering out records using the two date boxes works with the following scenarios:

• Both Blank: If you leave both boxes blank, then the report will not filter out any Inspected dates.
• End Date Entered: If the only Start date is blank, then the report will show all records that have a date up to the End Date.
• Start Date Entered: If the only End date is blank, then the report will show all records that have a date beyond the Start Date.
• Both Dates Entered: If both dates are entered, then only inspections that have an inspected date falls within that date range will appear on the report.

In the picture above, the date range was the entire year for 2010. The date range is inclusive.