I was able to figure this out but I don't really like the method enough to publish it as a procedure I would recommend. I had to buy a password reset program for SQL server and reset a password for a particular system ID. Then I had read access to the tables of the v5.0 database and could do the custom reports. I'd prefer using another method so I'm not dependent on that system ID existing on the SQL id/password table. If anyone else has an idea, I'd really like to hear it.
Hello Eric,
I work with a clinic in Sacramento CA and I have created their entire AC system from the ground up. I have created a custom reporting system that merges data from AC?s SQL tables and data that we need to modify for Workers Comp doctors first reports and what we call PR-2?s.
I have also created custom reports that work for our admin staff to produce reports ?custom letter with letter head kind of a mail merge? for various patients needs.
As for your needs, I have created custom data dumps that can be sent to our billing company that the import into their Centricity system by day or date ranges.
In short all of what you?re looking to achieve is doable and there is no need to crack that MS-sql tables to do it. You just need to wrap your head around what all the tables mean in AC and either import the required data to something that is a little easier like MS Access or Crystal reports.
If I can be of any help feel free to drop me a line
Aaron
asicams@gmail.com
