Patients Report

The Patients Report is used to create simple queries using fields in the Patient table.

In Standard Reports, in the Lists section, click Patients - Raw.

Options are hard coded and may not reflect all fields. For more query options, see Query Examples or submit a Query Request.

Note: To control user access to this report, see Report Setup: Security Permissions.


Select Tab

In the Select tab, users can choose which columns of data to include in the report (e.g., PatNum, Email, etc). This information is pulled directly from the Patient Table in Open Dental and most can be edited or added from Edit Patient Information. Most fields are self-explanatory. Below are fields that may need additional explanation.

Patient: Select fields to include columns on patient information.

Referral Type: Select a referral type and at least one Referred field to filter patients with Referrals. Patients with no referrals (or only referrals of a different type) will be excluded from the report. Only one referral type can be selected at a time. To include patients without referrals, leave this section deselected.

Referred: Select fields to include information on referral. For referrals that are not patients (e.g., providers), this information is entered in the Edit Referral window. See Referral List. Most fields are self-explanatory. Below are fields that may need additional explanation.

Where Tab

In the Where tab, users can select additional patient fields to limit report results. Most fields are self-explanatory. Below are fields that need additional explanation. Most fields are added or edited from Edit Patient Information.

When including a Where statement to the Patients Report, users will need to choose how the data is being limited. Users can enter a phrase to limit the results or select from a list of options, depending on the field chosen. Once the field is chosen, users will need to determine how the results are being limited. Below are the options. For each option, assume that PatNum and 14 are being used to filter results in the example.

LIKE: Include results from similar to the filter entered (e.g., results will include PatNum: 14, 140, 7142, and any other results that include the combination of characters entered).

=: Only includes results matching the statement exactly (e.g., results would only include PatNum: 14).

> : Include all results greater than the statement entered (e.g., PatNums 15 and above are included in results).

<: Include all results less than the statement entered (e.g., PatNums 13 and lower are included in results).

>=: Include all results greater than or equal to the statement entered (e.g., PatNum 14 and above are included in results).

<: Include all results less than or equal to the statement entered (e.g., PatNum 14 and lower are includes in results).

<>: Include only results less than or greater than the statement entered (e.g., PatNum 14 is excluded from the results, but 15 and above are included and 13 and lower are included).

This section displays the limitations that have already been added to the report. Click Delete Row to delete a limitation from the report.

This section displays the query that is being written. It is also displayed in the SELECT tab. This section is read-only. Click OK to run the query. Click Cancel to close Patients Report.

Running the Patients Report

  1. In the SELECT tab, select the Patient information the display on the report
    • To select multiple rows, hold CTRL button when clicking.
  2. Select information to include from Referral Type/Referred lists.
  3. Click the WHERE tab.
  4. Choose a field to limit query results.
  5. Enter necessary details and choose how to limit results.
  6. Click Add.
  7. Repeat steps 4-6 to add any additional limitations as needed.
    • Select a row and click Delete Row to remove a row that was added by mistake.
  8. Click OK to run the report. The results will be displayed in the User Query window.
Note: To quickly run this query again later, save it as a Query Favorite.