The MainTrac Inspection Results report output allows you to report the status of each inspection item, in addition to linked Work Orders, for a selection range of inspections.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
From the bottom of the screen…
Core Criteria
Inspections (MTInspectionResultsReport_InspectionNumber_DataGrid)
The Inspection DataGrid displays all Inspections in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Inspections, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Inspection Number Range option.
THEN
Input the range of Inspections you wish to include. When the report is run, each Inspection will begin on its own page.
Make selections in the DataGrid or use an Inspection Number Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO INSPECTIONS being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Inspection Number Range (MTInspectionResultsReport_InspectionNumber_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Inspection Numbers.
THEN
Enter the range of Inspection Numbers. Each Inspection will print on its own page.
OR
Leave this option de-selected to skip the Inspection Number Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Inspection Status (MTInspectionResultsReport_RecordStatus_ComboBox)
Select the Inspection Status(es) on which you wish to report. Only those Inspection Numbers with a Status matching your selection(s) will be included.
Leave this field at its default value (0) to skip the Status check.
DeleteBegin Inspection Number (MTInspectionResultsReport_InspectionNumber_Begin)
This field is applicable only if you opt to Use Inspection Number Range.
Select the Beginning and Ending Inspection Numbers for their respective fields. Inspection Numbers within the range entered will be included in the process. Each Inspection will begin on its own page.
DeleteEnd Inspection Number (MTInspectionResultsReport_InspectionNumber_End)
This field is applicable only if you opt to Use Inspection Number Range.
Select the Beginning and Ending Inspection Numbers for their respective fields. Inspection Numbers within the range entered will be included in the process. Each Inspection will begin on its own page.
DeleteUse Inspection Date Range (MTInspectionResultsReport_InspectionDate_UseRange)
Select this option to limit your selection to a range of Inspection Dates.
THEN
Enter the Date Range you wish to use.
OR
Leave this option de-selected to skip the Date Range check.
Inspection Begin Date (MTInspectionResultsReport_InspectionDate_Begin)
This field is applicable only if you are opting to Use Inspection Date Range.
Select your beginning and ending Inspection Date range option for the Inspections you wish to print.
THEN
Take appropriate action in the right-hand column to specify the dates you wish to select. Inspections that were done within this date range will be included.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteInspection End Date (MTInspectionResultsReport_InspectionDate_End)
This field is applicable only if you are opting to Use Inspection Date Range.
Select your beginning and ending Inspection Date range option for the Inspections you wish to print.
THEN
Take appropriate action in the right-hand column to specify the dates you wish to select. Inspections that were done within this date range will be included.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteInspection Form (MTInspectionResultsReport_InspectionFormCode_Picklist)
Select the Inspection Form on which you wish to report. Any inspections done using this form over the other ranges selected will be included on your report.
Leave this field blank to skip the Inspection Form check.
DeleteInspection Category (MTInspectionResultsReport_CategoryCode_ComboBox)
Select the Inspection Category on which you wish to report. Any inspections done using this category over the other ranges selected will be included on your report.
Leave this field blank to skip the Inspection Form check.
DeleteFixed Asset Types to Include (MTInspectionResultsReport_AssetTypes_Combobox)
Select Fixed Asset Type(s), if desired. The report will include Inspections linked to the Fixed Asset Type(s) you select. Multiple selection is allowed, and a separate Tab with additional selection criteria will appear for each Fixed Asset Type you select.
Leave this field deselected to skip this check and run the report for all Asset Types.
DeleteFacility Criteria
MainTrac Facilities (MTInspectionResultsReport_FacilityCode_DataGrid)
The Facility DataGrid displays all Facility Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Facility Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Facility Range option.
THEN
Input the range of Facility Codes you wish to include.
Make selections in the DataGrid or use a Facility Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO FACILITY CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Facility Code Range (MTInspectionResultsReport_FacilityCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Facilities.
THEN
Enter the range of Facility Codes.
OR
Leave this option de-selected to skip the Facility Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Facility Code (MTInspectionResultsReport_FacilityCode_Begin)
This field is applicable only if you opt to Use Facility Range.
Click the Picklist icon to select the Beginning and Ending Facility Codes for their respective fields. Facility Codes within the range entered will be included in the process.
DeleteEnd Facility Code (MTInspectionResultsReport_FacilityCode_End)
This field is applicable only if you opt to Use Facility Range.
Click the Picklist icon to select the Beginning and Ending Facility Codes for their respective fields. Facility Codes within the range entered will be included in the process.
DeleteFacility Code WildCard (MTInspectionResultsReport_FacilityCode_Equals)
If opting to Use Facility Range, then click the Picklist icon to select a single Facility Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTInspectionResultsReport_FacilityCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Equipment Criteria
MainTrac Equipment (MTInspectionResultsReport_EquipmentCode_DataGrid)
The Equipment DataGrid displays all Equipment Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Equipment Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Equipment Range option.
THEN
Input the range of Equipment Codes you wish to include.
Make selections in the DataGrid or use an Equipment Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO EQUIPMENT CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Equipment Code Range (MTInspectionResultsReport_EquipmentCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Equipment Codes.
THEN
Enter the range of Equipment Codes.
OR
Leave this option de-selected to skip the Equipment Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Equipment Code (MTInspectionResultsReport_EquipmentCode_Begin)
This field is applicable only if you opt to Use Equipment Range.
Click the Picklist icon to select the Beginning and Ending Equipment Codes for their respective fields. Equipment Codes within the range entered will be included in the process.
DeleteEnd Equipment Code (MTInspectionResultsReport_EquipmentCode_End)
This field is applicable only if you opt to Use Equipment Range.
Click the Picklist icon to select the Beginning and Ending Equipment Codes for their respective fields. Equipment Codes within the range entered will be included in the process.
DeleteEquipment Code WildCard (MTInspectionResultsReport_EquipmentCode_Equals)
If opting to Use Equipment Range, then click the Picklist icon to select a single Equipment Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTInspectionResultsReport_EquipmentCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Street Criteria
MainTrac Street (MTInspectionResultsReport_StreetCode_Datagrid)
The Street DataGrid displays all Street Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Street Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Street Range option.
THEN
Input the range of Street Codes you wish to include.
Make selections in the DataGrid or use a Street Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO STREET CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Street Code Range (MTInspectionResultsReport_StreetCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Street Codes.
THEN
Enter the range of Street Codes.
OR
Leave this option de-selected to skip the Street Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Street Code (MTInspectionResultsReport_StreetCode_Begin)
This field is applicable only if you opt to Use Street Range.
Click the Picklist icon to select the Beginning and Ending Street Codes for their respective fields. Street Codes within the range entered will be included in the process.
DeleteEnd Street Code (MTInspectionResultsReport_StreetCode_End)
This field is applicable only if you opt to Use Street Range.
Click the Picklist icon to select the Beginning and Ending Street Codes for their respective fields. Street Codes within the range entered will be included in the process.
DeleteStreet Code Wildcard (MTInspectionResultsReport_StreetCode_Equals)
If opting to Use Street Range, then click the Picklist icon to select a single Street Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTInspectionResultsReport_StreetCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Utility Criteria
Utility Code Datagrid (MTInspectionResultsReport_UtilityCode_Datagrid)
The Utility DataGrid displays all Utility Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Utility Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Utility Range option.
THEN
Input the range of Utility Codes you wish to include.
Make selections in the DataGrid or use a Utility Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO UTILITY CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Utility Code Range (MTInspectionResultsReport_UtilityCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Utility Codes.
THEN
Enter the range of Utility Codes.
OR
Leave this option de-selected to skip the Utility Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Utility Code (MTInspectionResultsReport_UtilityCode_Begin)
This field is applicable only if you opt to Use Utility Range.
Click the Picklist icon to select the Beginning and Ending Utility Codes for their respective fields. Utility Codes within the range entered will be included in the process.
DeleteEnd Utility Code (MTInspectionResultsReport_UtilityCode_End)
This field is applicable only if you opt to Use Utility Range.
Click the Picklist icon to select the Beginning and Ending Utility Codes for their respective fields. Utility Codes within the range entered will be included in the process.
DeleteUtility Code WildCard (MTInspectionResultsReport_UtilityCode_Equals)
If opting to Use Utility Range, then click the Picklist icon to select a single Utility Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTInspectionResultsReport_UtilityCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Tree Criteria
Tree Code Datagrid (MTInspectionResultsReport_TreeCode_Datagrid)
The Tree DataGrid displays all Tree Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Tree Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Tree Range option.
THEN
Input the range of Tree Codes you wish to include.
Make selections in the DataGrid or use a Tree Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO TREE CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Tree Code Range (MTInspectionResultsReport_TreeCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Tree Codes.
THEN
Enter the range of Tree Codes.
OR
Leave this option de-selected to skip the Tree Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Tree Code (MTInspectionResultsReport_TreeCode_Begin)
This field is applicable only if you opt to Use Tree Range.
Click the Picklist icon to select the Beginning and Ending Tree Codes for their respective fields. Tree Codes within the range entered will be included in the process.
DeleteEnd Tree Code (MTInspectionResultsReport_TreeCode_End)
This field is applicable only if you opt to Use Tree Range.
Click the Picklist icon to select the Beginning and Ending Tree Codes for their respective fields. Tree Codes within the range entered will be included in the process.
DeleteTree Code WildCard (MTInspectionResultsReport_TreeCode_Equals)
If opting to Use Tree Range, then click the Picklist icon to select a single Tree Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTInspectionResultsReport_TreeCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.