How to automate printing of reports?

For users or potential users.
Post Reply
spolevoy
Posts: 74
Joined: Wed Oct 17, 2012 4:45 am

How to automate printing of reports?

Post by spolevoy » Mon Mar 11, 2019 12:16 pm

I would like certain queries to print out automatically Monday morning.
How do I do that?

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: How to automate printing of reports?

Post by cmcgehee » Tue Mar 12, 2019 7:52 am

Open Dental on its own doesn't have the capability to run queries automatically. I believe that some 3rd-party vendors that integrate with Open Dental have this feature like Divergent Dental or Practice by Numbers.
Chris McGehee
Open Dental Software
http://www.opendental.com

spolevoy
Posts: 74
Joined: Wed Oct 17, 2012 4:45 am

Re: How to automate printing of reports?

Post by spolevoy » Tue Mar 12, 2019 8:22 am

Thanks - I'll reach out to Kevin.

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: How to automate printing of reports?

Post by enamelrod » Wed Mar 13, 2019 11:13 am

can you add a feature request?

User avatar
irfan
Posts: 216
Joined: Thu Oct 21, 2010 9:09 am

Re: How to automate printing of reports?

Post by irfan » Sat Mar 16, 2019 4:36 pm

If you have a computer running24/7 (probably your server) you can use some sql report software like flyspeedSQL and have it automatically run queries through task scheduler. Those can automatically export to a shared folder. In the morning print the PDFs. you could also export them to a google drive folder and have google app scripts automate emailing them or even automatically print them so they are printed before you show up.

spolevoy
Posts: 74
Joined: Wed Oct 17, 2012 4:45 am

Re: How to automate printing of reports?

Post by spolevoy » Tue Mar 26, 2019 8:07 am

Irfan - how do you connect to the database?
says "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"

User avatar
irfan
Posts: 216
Joined: Thu Oct 21, 2010 9:09 am

Re: How to automate printing of reports?

Post by irfan » Wed Mar 27, 2019 2:17 pm

i dont use a standard local mysql server, but if you do id imagine you just need to type in the server name (many times "SERVER", but find out what your server computer is called)... your database is probably labelled 'opendental', your user is probably still 'root' and you probably dont have a password on it.

id recommend you have a new low-level user created with no writing abilities so you dont accidentally change things, and get a password on it.

Post Reply