I would like certain queries to print out automatically Monday morning.
How do I do that?
How to automate printing of reports?
Re: How to automate printing of reports?
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?
Thanks - I'll reach out to Kevin.
Re: How to automate printing of reports?
can you add a feature request?
Re: How to automate printing of reports?
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?
Irfan - how do you connect to the database?
says "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"
says "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied"
Re: How to automate printing of reports?
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.
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.