Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Help crystal report

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

65 Views

RSS

sjacobs

(@sjacobs)

Posts: 13

Eminent Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0