Crystal Reports
-
- Posts: 8
- Joined: Tue Jun 08, 2010 1:56 pm
Crystal Reports
Hello, has anyone used Crystal Reports with Open Dental? I have a trial version and want to play around.
Thanks
Thanks
Re: Crystal Reports
I've seen a post at the MySQL site saying that Crystal Reports can work with MySQL database version 5.0.27 or later. Open Dental uses version 5.0.22 or some even 4.1. For those, an ODBC connector is needed as a go-between. I used Crystal Reports long ago and liked it, but since the RDL report format meets our needs, connects directly to the database without ODBC, and is around $327 cheaper (that is, free), why bother with it.
DMA, Inc.
http://www.dmatechsolutions.com
http://www.dmatechsolutions.com
Re: Crystal Reports
what reports are you able to generate with RDL report format
Re: Crystal Reports
Try iReports (download from sourceforge). I have written a *lot* of reports with iReports and it only gets better. I would be happy to help if needed.
Re: Crystal Reports
We have over 40 reports, from routing slips to referral reports to production/writeoff reports. The nice thing about RDL Designer in OD is that you can paste in a query and it creates a table or list based on the fields, with various layout and formatting options that aren't available in "user query." Formulas can also be applied to the results. Use "search" for "RDL" on the Open Dental website and you get 2 results, one with a nice sample report and one with rather over-complicated instructions and helpful links. It can connect thru the ODR.dll or directly to the database with a MySQL server connection string. It's not very user-friendly though and you have to know how to query the database and pull more human-readable results from the raw data.
DMA, Inc.
http://www.dmatechsolutions.com
http://www.dmatechsolutions.com
- Rickliftig
- Posts: 764
- Joined: Thu Jul 10, 2008 4:50 pm
- Location: West Hartford, CT
- Contact:
Re: Crystal Reports
I've started posting some of my info sheets onto Google docs. Maybe there's a way to share the rdl files there. Then you can do some Youtube videos!
Another Happy Open Dental User!
Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net
Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net
Re: Crystal Reports
this goes back to a previous post of what third party programs are you using. if ireport does what you say this would be an area that OD users need guidance on and support on from OD team, since reporting is a weak link for od
Re: Crystal Reports
iReport is pretty good as stand-alone application but it is more for advanced users and is also java. Considering that most reports run by your staff... there is a potential of "staff whining" involved.fdscadmin wrote:Try iReports (download from sourceforge). I have written a *lot* of reports with iReports and it only gets better. I would be happy to help if needed.
I wonder if it could be integrated in OD through plugin API http://opendental.com/manual/plugins.html?
Thanks,
Steven G.
Steven G.
-
- Posts: 59
- Joined: Sat Mar 13, 2010 11:11 am
Re: Crystal Reports
mowgli wrote:We have over 40 reports, from routing slips to referral reports to production/writeoff reports. The nice thing about RDL Designer in OD is that you can paste in a query and it creates a table or list based on the fields, with various layout and formatting options that aren't available in "user query." Formulas can also be applied to the results. Use "search" for "RDL" on the Open Dental website and you get 2 results, one with a nice sample report and one with rather over-complicated instructions and helpful links. It can connect thru the ODR.dll or directly to the database with a MySQL server connection string. It's not very user-friendly though and you have to know how to query the database and pull more human-readable results from the raw data.
Id ove to hear more about how you were able to do this, especially the part about getting to be more user friendly and getting readable results. Can you please expand?