Crown and Bridge Production by Provider

If you need to see exactly how much crown and bridge work each provider in your office has completed over a specific period, this report provides the data instantly. This open dental crown production query helps you track performance and production goals without manually digging through individual patient charts.

The Query

Copy and paste the following code into the User Query window. You can adjust the dates in the SET section to match the period you want to analyze.

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

SELECT 
    p.LName AS 'Provider',
    pc.ProcCode AS 'Code',
    pc.AbbrDesc AS 'Description',
    COUNT(pl.ProcNum) AS 'Count',
    SUM(pl.ProcFee) AS 'Total Production'
FROM procedurelog pl
INNER JOIN procedurecode pc ON pl.CodeNum = pc.CodeNum
INNER JOIN provider p ON pl.ProvNum = p.ProvNum
WHERE pl.ProcStatus = 2
  AND pl.DateComplete BETWEEN @FromDate AND @ToDate
  AND (pc.ProcCode LIKE 'D27%' OR pc.ProcCode LIKE 'D67%' OR pc.ProcCode LIKE 'D62%')
GROUP BY p.LName, pc.ProcCode, pc.AbbrDesc
ORDER BY p.LName, SUM(pl.ProcFee) 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.

Understanding the Results

• Provider: The name of the provider who completed the procedure.
• Code: The specific ADA procedure code (e.g., D2740).
• Description: The short description of the procedure code.
• Count: The total number of times this specific procedure was completed by this provider in the selected date range.
• Total Production: The total dollar amount (ProcFee) for these procedures.

How to Customize

You can easily modify this report to fit your specific needs by changing the lines at the top of the query:

• Change the Date Range: Edit the dates inside the single quotes for @FromDate and @ToDate. Ensure you keep the YYYY-MM-DD format.
• Filter by Clinic: If you have multiple locations and only want to see one, add this line right before the GROUP BY clause:
  AND pl.ClinicNum = 1 (Replace 1 with your specific Clinic Number).
• Include More Codes: If you want to include additional codes (like implants or specific bridge components), add them to the WHERE clause using OR:
  AND (pc.ProcCode LIKE 'D27%' OR pc.ProcCode LIKE 'D67%' OR pc.ProcCode LIKE 'D62%' OR pc.ProcCode LIKE 'D60%')

Variations

If you want to see a high-level summary by provider without the individual procedure codes, you can simplify the query to just show the provider totals:

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

SELECT 
    p.LName AS 'Provider',
    SUM(pl.ProcFee) AS 'Total Crown/Bridge Production'
FROM procedurelog pl
INNER JOIN provider p ON pl.ProvNum = p.ProvNum
WHERE pl.ProcStatus = 2
  AND pl.DateComplete BETWEEN @FromDate AND @ToDate
  AND (pc.ProcCode LIKE 'D27%' OR pc.ProcCode LIKE 'D67%' OR pc.ProcCode LIKE 'D62%')
GROUP BY p.LName;

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.