Overview of search behavior

Search results match all entries and don't use case sensitivity.
Use quotes around entries to find literal blocks.
Click Show other search options to access advanced search options.

To search by keywords

1. Open 13-8 Search Reports.
2. Enter a keyword in the Search text box.
3. Click Search.

To search by specific program area

Sage 100 Contractor searches using the first-level menu number for the selected program area.

If you select Include report forms, Sage 100 Contractor searches these locations:

• \\ServerName\Sage100Contractor\Custom Reports
• \\ServerName\Sage100Contractor\User Data\username\Custom Reports
• \Program Files\Sage\Sage 100 Contractor SQL\System Reports, or \Program Files (x86)\Sage\Sage 100 Contractor SQL\System Reports

1. Open 13-8 Search Reports.
2. Click Show other search options.
3. Enter a keyword in the Search text box.
4. Select an area in Limit search to a specific program area.
5. Click Search.

To search by specific data table

1. Open 13-8 Search Reports.
2. Click Show other search options.
3. Enter a keyword in the Search text box.
4. Select a table in Limit search to a specific data table.
5. Click Search.

Including database fields in search

1. Open 13-8 Search Reports.
2. Click Show other search options.
3. In the Tables column, select a table.
4. In the Fields column, select a field, and click OK.
5. Click Search.

Search option behavior

Search into calculated fields finds matches when the calculated field exists in the report or form design.

The search doesn't validate calculated field usage in reports or forms.

Include report forms will show the RPF title and report forms in the Forms column when the criteria match.

Excluding Include report forms hides the Forms column from search results.