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

Crystal Report code

General Discussion

Last Post by rwilliams 9 years ago

4 Posts

4 Users

0 Reactions

58 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

I am trying to write a report that will show the last two obs values side by side. Can anyone help me with how to set that up. Thanks!

Replies through here or my direct email are great. [email protected]

Posted : April 20, 2016 8:14 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Just thinking....

Group by person.

Person will link to LastObs table (and Obs) , to get the last data point (date and element). Save to a variable.

Also have Person link to Obs (or RptObs) to read thru all.

If two dates match, then skip. Else, write to combined variable [call it CombData] in format "YYYYMMDD_data".

At group level, you can repeat your saved items from LastObs for date and data. But take the maximum of CombData and place at group level.

John Doe 1/1/2016 18.9 20150704_17.6

Then, break apart the CombData field to get the date and value formatted nice (and remove the maximum entry.

John Doe 1/1/2016 18.9 7/4/2015 17.6

Posted : April 20, 2016 9:03 am

acantu

(@acantu)

Posts: 722

Prominent Member

You can create a view, in the view, create two columns, then you can do something like this:

Column One:

SELECT TOP 1 OBSVALUE FROM OBS WHERE HDID = 1111 AND PID = 12324352345234523453 ORDER BY OBSDATE DESC

Column Two:

SELECT TOP 1 OBSVALUE FROM (SELECT TOP 2 OBSVALUE, OBSDATE, HDID FROM OBS WHERE PID = 1681213456006610 AND HDID = -1 AND (SELECT COUNT(*) FROM OBS OBS2 WHERE PID = OBS.PID AND HDID = OBS.HDID) > 1 ORDER BY OBSDATE DESC) OBSColumn2 ORDER BY OBSDATE ASC

Just change the PID and HDID as needed to meet your requirements

Posted : April 22, 2016 4:26 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

You probably also want to only include signed obs by adding a "change in (2,6) and xid = 100000000000000000000000000000000000"

Posted : April 22, 2016 8:29 am

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