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 need additional explanation.

Patient: Select fields to include columns on patient information.

Referred To: Select fields to include columns on outbound referrals (e.g., other providers the patient has been referred to)

Referred From: Select fields to include columns on inbound referrals (e.g., who referred patients to your practice)

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 Referred To/Referred From 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.