opendentalsupport.com is an independent community resource. We are NOT affiliated with, endorsed by, or sponsored by Open Dental Software, Inc. Open Dental® is a registered trademark of Open Dental Software, Inc.

SQL Queries

Ready-to-use SQL queries for Open Dental. Copy, paste, run.

4 articles

Collections by Provider Report

Need to track production and collections by provider? Use this open dental collections report query to get accurate data for your practice in seconds.

3/27/2026 · 3 min read

Open Dental Production Report by Provider

Need an open dental production report by provider? Use this ready-to-use SQL query to quickly pull production totals for any date range in your practice.

3/27/2026 · 3 min read

Net Production Query with Adjustments and Writeoffs

Need an accurate view of your practice's performance? Use this open dental net production query to calculate gross production, adjustments, and write-offs.

3/27/2026 · 3 min read

Monthly Production Report Query

Need a custom production report? Use this SQL query for generating monthly production reports in Open Dental to see completed work by provider and date.

3/27/2026 · 3 min read
opendentalsupport.com is an independent community resource. We are NOT affiliated with, endorsed by, or sponsored by Open Dental Software, Inc. Open Dental® is a registered trademark of Open Dental Software, Inc.