Search found 3 matches

by n2vball
Wed Oct 11, 2023 9:48 am
Forum: Main Forum
Topic: Excel Refreshable Reports
Replies: 5
Views: 3010

Excel Refreshable Reports

Have you heard of connected reporting from Excel. Just connect excel to the OpenDental DB, add your query and you can refresh and update your reports at the click of the refresh button. I have been working with connected reports for 20 years. 13 years with dental data. This is the BEST and easiest w...
by n2vball
Tue Jan 28, 2020 7:03 pm
Forum: Advanced Topics
Topic: Query - listing of Payment & Payment date with Production & Production dates
Replies: 1
Views: 10569

Query - listing of Payment & Payment date with Production & Production dates

I have been trying to find / develop a query that would give me actual collections, (Ins & Patient) with collection dates linked to the procedure, procedure date and provider. Here is what I have so far but I think I am missing some other payments. Is there a better query that someone else is using ...
by n2vball
Fri Jun 07, 2019 9:54 am
Forum: Developers
Topic: Dental KPI & Metrics
Replies: 2
Views: 5429

Re: Dental KPI & Metrics

Do you use excel to do any reports? The best way to pull data, KPI & Metrics. Have you heard of connected reporting. It just connects excel to OpenDental and you just need to refresh. If you have not heard of this, I would be happy to share with you something that would change your reporting world. ...