Open Dental Production Report by Provider

If you need to see exactly how much production each provider in your office completed over a specific time period, this query provides the answer instantly. It is the most reliable way to generate an open dental production report by provider without relying on pre-built reports that may not show exactly what you need.

The Query

Copy and paste the following code into your User Query window. You can change the dates in the first two lines to match the period you want to analyze.

SET @FromDate = '2026-01-01';
SET @ToDate = '2026-01-31';

SELECT 
    p.Abbr AS 'Provider',
    SUM(pl.ProcFee * pl.UnitQty) AS 'Total Production'
FROM procedurelog pl
INNER JOIN provider p ON pl.ProvNum = p.ProvNum
WHERE pl.ProcDate >= @FromDate 
  AND pl.ProcDate <= @ToDate
  AND pl.ProcStatus = 2
GROUP BY p.Abbr
ORDER BY SUM(pl.ProcFee * pl.UnitQty) DESC;

How to Run This Query

1. In Open Dental, go to Reports in the Main Menu.
2. Click User Query.
3. Paste the query provided above into the large text box.
4. Click Submit Query.
5. The results will display in the grid below the text box.

Understanding the Results

• Provider: This column displays the abbreviation of the provider as set up in your provider list.
• Total Production: This is the sum of all completed procedures (ProcStatus = 2) assigned to that provider within your chosen date range. It multiplies the procedure fee by the quantity of units performed.

How to Customize

You can easily adjust this report to fit your specific needs:

• Change the Date Range: Modify the dates inside the single quotes on the first two lines. For example, to see February 2026, change the lines to:
  SET @FromDate = '2026-02-01';
SET @ToDate = '2026-02-28';
• Filter by Clinic: If you have multiple locations and only want to see one, add a line before the GROUP BY clause:
  AND pl.ClinicNum = 1
  (Replace '1' with your specific ClinicNum, which you can find in the Clinic list under Setup > Appointments > Clinics).

Variations

Including Adjustments

If you want to see "Adjusted Production" (Production minus adjustments), you would need a more complex query that joins the adjustment table. For most offices, the standard production report above is sufficient for tracking daily or monthly goals.

Filtering by Procedure Category

If you only want to see hygiene production, you can filter by the procedure code category. Add this line before the GROUP BY clause:
AND pl.CodeNum IN (SELECT CodeNum FROM procedurecode WHERE ProcCat = 1)
(Note: You must verify which ProcCat number corresponds to your hygiene category in your specific database setup.)

Skip the Query — Use DentalCanvas Instead

Don't want to write SQL? DentalCanvas connects to your Open Dental database and shows you this data automatically in a visual dashboard — no queries required.

This article is provided by opendentalsupport.com, an independent community resource. We are not affiliated with Open Dental Software, Inc.