Suggested Reports - Feature Idea

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
ajhalls
Posts: 36
Joined: Fri Jan 10, 2014 1:41 pm
Location: Utah
Contact:

Suggested Reports - Feature Idea

Post by ajhalls » Thu Apr 29, 2021 9:43 am

Playing with the reports here: https://opendentalsoft.com:1943/ODQuery ... yList.aspx

It would be pretty cool if there was a way to know which ones were used most often, creating a way to filter them by "Most Popular"

For what it is worth, there are 901 out of 1329 that run, AND return results, without modification other than dates
15 seem to reference either a missing table or columns
322 run, but don't return anything
Dr. Alan Halls DMD
alan@reminderdental.com
ReminderDental.com - A new way to save

User avatar
jordansparks
Site Admin
Posts: 5751
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Suggested Reports - Feature Idea

Post by jordansparks » Thu Apr 29, 2021 2:05 pm

You ran them all? Wow.
Jordan Sparks, DMD
http://www.opendental.com

ajhalls
Posts: 36
Joined: Fri Jan 10, 2014 1:41 pm
Location: Utah
Contact:

Re: Suggested Reports - Feature Idea

Post by ajhalls » Tue May 04, 2021 9:21 am

It took a little time, but here is a sample of the output. It has been sanitized to remove practice or patient specific data, so there are only 177 results. On the result sets, they were trimmed as well to the first 20 results, just so we could evaluate the type of data we would be looking at for each.

https://docs.google.com/spreadsheets/d/ ... sp=sharing
Dr. Alan Halls DMD
alan@reminderdental.com
ReminderDental.com - A new way to save

Post Reply