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

Adding obs terms to Referral Order Crystal Report

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

58 Views

RSS

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

Hello,

I'm trying to use Crystal Reports to modify the reforder.rpt file for Referral Orders. This is for physical therapy referral orders specifically. We are trying to add some items such as Therapeutic Exercises, Modalities, Frequency and Duration. Each one of these items is entered on a custom VFE form tied to an obs term.

I linked the obs table in database expert to the document table matching on SDID (Left Outer Join). Then I created a formula field for each obs term I want to add that look like the below with the correct HDID number for each:

if {OBS.HDID} = 254104 then {OBS.OBSVALUE}

When testing this in CPS, if I only fill in one field then it works great, but if I fill in all four fields then they all turn out blank on the referral order form.

Does anybody know why this would happen? Like the multiple obs terms from the same document is confusing the code?

Thanks in advance for your help!

Crystal Price

Posted : August 14, 2017 10:55 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Two approaches:

1. use subreports to extract each obs term, link on SDID, filter on HDID or obterm Name via link on HDID to ObsHead

2. process variables in detail section, if statements for HDID or Name (easier), use shared variables, display variable in functions in report section, assume in footer.

Both approaches reasonable simple, subreports may be more intuitive. Delighted to help your problem, contact me directly.

Posted : August 15, 2017 3:12 am

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

thanks jfitzmd! I tried your approach using sub-reports and was able to get what I was looking for. I've never used sub-reports before, but can see how it will come in handy.

Posted : August 17, 2017 12:07 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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