Notifications
Clear all
Topic starter
I am not sure how to begin a crystal report, I went to the training but worked on the demo database there when I got back to the office and finally got CPS loaded locally on my computer I go onto the server and go to start a new query, but I am am not sure where to go next. Pecan anyone help
Posted : September 8, 2014 12:06 pm
Probably best to start with some 'goal' report in mind; perhaps listing all active patients and PCP.
To begin with, do you own the free-standing Crystal Reports program? And, if so, is it configured to be able to open the datatables?
Then, simply start slow. Open the Person (or Patient) table. See if you can paste a few fields into the Detail row of Crystal - useful stuff like name, date of birth, med rec number, address.
Once that far, you can go back to Datebase Expert and add the User (or Userinfo) table, linking from the Person table RESPROVID to the Usrinfo table PVID.
You can then go back to the Detail row and now paste the SEARCHNAME field from Usrinfo on the same line.
At this point, you have a way to list all patients and linked PCP.
Before going further, can you get this far?
(Hoping I did not skip too much, and got the table names correct as I am on EMR and CPS has some different names plus unsure what version of CPS you are using.)
Posted : September 8, 2014 9:56 pm
Just a bit of advice for the future, you might get more help if you post CR questions to the General Discussion > Crystal Reports forum. Report/data nerds like me tend to gravitate to that board more so than this one, and it will likely get more attention there. This board's a lot noisier.
That being said, I think Joseph's questions are a good place to start.
Posted : September 9, 2014 6:19 am
