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 Filtering Help

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

64 Views

RSS

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Is it possible to write a filter in Crystal Reports to sort based upon the value of one obsterm while returning more than just that one obsterm?

Example: Show me data for obsterms 1 - 9 and sort by date on obsterm 3

Posted : August 11, 2016 5:37 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Yes, but would probably need to know specifics.

You could sort based on WEIGHT, but also display on the detail line HEIGHT, AGE, SEX, ...

Posted : August 11, 2016 6:18 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Okay. I'm using a formula to pull in a select group of ObsTerms:

IF {OBSHEAD.NAME} = 'HAT-SOLD'
THEN 'Date Sold: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-WARR-EXP'
THEN 'Warranty Expiration: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-MISC1'
THEN 'Office Warranty Expiration: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-VENDOR'
THEN 'Vendor: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-MODEL'
THEN 'Model: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-SERIAL'
THEN 'Serial: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-STYLE'
THEN 'Style: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-SIDE'
THEN 'Side: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-BATTERY'
THEN 'Battery: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-STATUS'
THEN 'Status: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-PAYMENT'
THEN 'Payment: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-SOURCE'
THEN 'Source: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-EMPLOYEE'
THEN 'Employee: ' + {OBS.OBSVALUE}
ELSE IF {OBSHEAD.NAME} = 'HAT-COMMENTS'
THEN 'Comments: ' + {OBS.OBSVALUE}

I want to display this formula, but sort it based upon the entry for the 'HAT-SOLD'.

Posted : August 11, 2016 6:54 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Why not have two columns? First being your special formula field setting a value, and the second column being HAT-SOLD?

You could also group on HAT-SOLD (which will ask you sort order). Then just not print the header or footer related to that group.

Posted : August 11, 2016 7:50 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Because that would be entirely too easy, and exactly what I should have done to begin with. *sigh* Thank you! Too close to the problem I guess.

Posted : August 11, 2016 7:54 am

Share:

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