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

In-Process Orders Report

Trading Post

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

72 Views

RSS

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

I'm in search of anyone who has created a Crystal Report to show in-process orders by provider. (EMR 9.5)

Thanks!

Posted : May 29, 2012 2:51 am

erinkistner

(@erinkistner)

Posts: 41

Trusted Member

I removed the post of a sample report because it appeared to contain patient information. If you created the post, please change it to something generic and repost.

Sorry,

CHUG Webmaster

Posted : May 30, 2012 6:58 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

Inprocess Orders Report.rpt

Posted : May 30, 2012 7:14 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I tweaked a couple of things in that last report — here's the result.

Inprocess Orders Report B

For one, I like grouping on Primary Keys, so instead of using PERSON.MEDRECNO, I used PERSON.PID — that's much less likely to be accidentally duplicated somewhere along the line. Then I set the Group Name to FIRSTNAME+" "+LASTNAME, so it would display nicely.

I don't like using extra groups just for sorting, so I created a PatSort formula, LASTNAME+", "+FIRSTNAME, inserted a Maximum() summary field into the PID grouping, and suppressed it. That allowed me to use the Group Sort Expert to sort the records using it.

Also, I saw no reason to use a subreport here. I added ORDDX to the tables in the Database Expert, and inserted a grouping on ORDERID, along with a Maximum summary for USRINFO.SEARCHNAME Then I moved the fields from the detail line to the header, and set them to Underlay Following Sections in the Section Expert. Then I placed the fields from the subreport in the detail line of the main report, and added RANK to the Record Sort Expert, removing the other sort fields.

To help with readability, I added ProperCase to the Display String of the DXDESC field, and set the page layout to legal instead of letter (though it was obvious this was intended for an Excel export — it helps when you can see what you're exporting 🙂 ) If it hadn't been Excel, I would have cleaned up the formatting a bit more. One trick I use is to change all my reports to a different font than Arial — it looks a bit less generic, and it provides a mental built-here note to me, as opposed to the reports that ship with EMR and CPS.

Posted : May 31, 2012 12:16 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