Page 1 of 1
How to automate printing of reports?
Posted: Mon Mar 11, 2019 12:16 pm
by spolevoy
I would like certain queries to print out automatically Monday morning.
How do I do that?
Re: How to automate printing of reports?
Posted: Tue Mar 12, 2019 7:52 am
by cmcgehee
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.
Re: How to automate printing of reports?
Posted: Tue Mar 12, 2019 8:22 am
by spolevoy
Thanks - I'll reach out to Kevin.
Re: How to automate printing of reports?
Posted: Wed Mar 13, 2019 11:13 am
by enamelrod
can you add a feature request?
Re: How to automate printing of reports?
Posted: Sat Mar 16, 2019 4:36 pm
by irfan
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.
Re: How to automate printing of reports?
Posted: Tue Mar 26, 2019 8:07 am
by spolevoy
Irfan - how do you connect to the database?
says "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"
Re: How to automate printing of reports?
Posted: Wed Mar 27, 2019 2:17 pm
by irfan
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.