Search found 3 matches
- Wed Oct 11, 2023 9:48 am
- Forum: Main Forum
- Topic: Excel Refreshable Reports
- Replies: 5
- Views: 4364
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...
- Tue Jan 28, 2020 7:03 pm
- Forum: Advanced Topics
- Topic: Query - listing of Payment & Payment date with Production & Production dates
- Replies: 1
- Views: 10772
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 ...
- Fri Jun 07, 2019 9:54 am
- Forum: Developers
- Topic: Dental KPI & Metrics
- Replies: 2
- Views: 5597
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. ...