Notifications
Clear all
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
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
I tweaked a couple of things in that last report — here's the result.
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
