• Section: Reports & Forms
  • Last updated: June 26, 2019, 5:02 p.m.

Wildcards for Reports

Wildcards are special characters that give you more flexibility when selecting which records, such as account numbers and invoice numbers, you want to include in a report. You can use two wildcard characters, the asterisk (*) and the question mark (?), in the Report Customization window.


Use the asterisk in the Report Customization window if you want to print a report for a specific group of records.

Example 1—If you want to print an Account Transactions report for all accounts whose account numbers begin with 1, you can use the asterisk wildcard to do so.

To include accounts whose numbers begin with 1, enter 1* in the Selected field in the Report Customization window for the Account Transactions report. When you print the report, only accounts whose numbers begin with 1 will be included on the report.

Example 2—If you have several items whose numbers end in SVC (to indicate the items are service items), you can enter *SVC in the Selected field to print a report that includes only the items whose numbers end in SVC.

Question mark

The question mark wildcard allows you to limit your report to elements that contain only a specific number of characters.

Example 3—If you want to print a Job Transactions report for the Cadwell Corporation. All Cadwell job numbers are three characters long and begin with the letter C. However, you have other jobs that start with the letter C and you don’t want those jobs to appear on the report. In the Selected field of the Job Transactions report’s Report Customization window, enter C?? to limit the report to three-character jobs that begin with C.