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

Formula for Crystal Reports to show patients without a specific observation

Trading Post

Last Post by Anonymous 1 second ago

8 Posts

3 Users

0 Reactions

70 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

I am trying to produce a list of diabetic patients with the date of the most recent office visit and last HGBA1C result or a notation that HGBA1C was not done. I can produce a list of patients with the date of the most recent office visit and the most recent HGBA1C. However, I have been unable to include patients who have an office visit but no HGBA1C recorded. Can anyone help me with a formula to include those who do not have an HGBA1C recorded?

Posted : March 18, 2013 11:14 pm

jjordet

(@jjordet)

Posts: 545

Honorable Member

Doing this in Crystal is complicated. I would typically create a view from RPTOBS including only the obsterm in question, connect the view with a left outer join Person to the view. This should list all patients, and then the obs values if there is one.

Posted : March 18, 2013 11:20 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

I have connected Patient Profile PID to RPTOBS PID with a left outer join, not enforced and equal. My report displays only only those patients with a recorded HGBA1C.

I am also connecting PatientProfile.PrimaryCareDoctorId --> DoctorFacility.DoctorFacilityId with a left outer join and that seems to be working correctly. I get a list of Patients and the primary care doctor if one is entered.

Do I need a formula or do I need to change some settings on my Crystal Reports? Or maybe I should just give up in frustration. Cry

Posted : March 20, 2013 7:40 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

if you put criteria in your select for the obsterm, the right outer join acts like an inner join and you'll only get patients with that specific criteria.

Posted : March 21, 2013 12:03 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

AHA!!!!!!! Thank you for the information. Laugh Do you have any suggestions for other ways to accomplish the task?

Posted : March 21, 2013 12:35 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

left outer join, select all patients matching other criteria, suppress those that you don't want.

Posted : March 21, 2013 12:44 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Something I have done...

select for OBS in ["BP SYSTOLIC","HGBA1C"]

do this, so you don't have to read thru everything

I use the in logic since I often (you too) may be checking for more than one OBS

then use a local defined variable called pt_A1C

with a formula like

if OBS in ["HGBA1C"] then obsdate

place the pt_A1C in your report

you can add conditional formatting to only print detail rows where pt_A1C < #01/01/2001# for instance

I assume that everyone will have a BP taken during a visit, and thus your link/join logic will be ok.

Make sense?

Posted : March 22, 2013 4:19 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Makes perfect sense. I just tried changing a report this morning using a similar idea and it worked wonderfully. Thanks for the verification. Smile

Posted : March 22, 2013 4:36 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