Notifications
Clear all
Topic starter
Hello,
I would like to filter labs and rad orders in crystal reports. Does anyone have any ideas?
Thank you!
Posted : March 7, 2019 2:51 am
OK, to begin with Orders are broken into three classifications - Services, Referrals, Tests.
It is in this third group - Tests - that I think you want to explore further. I will make a guess that you group your labs and rad orders inside this group.
To help me keep track of the Test Orders, I created the attached report. It will review your Test order type codes, provide you with classification, category, code (like CPT), description, count of your uses in past year (helpful to see what ones are being used) and lastly the embedded comment.
Suggest running this, and its output should point you to the codes you will need to use to find your specifics.
One last thing - to help you with the classifications, see the following which I use in my report. Thus you may be looking for a Classification value of 1 or 2.
select {ORDERCODES.CLASSIFICATION}
case 0 : "Other"
case 1 : "Labs"
case 2 : "Radiology"
default : "unknown"
Here is the report you can run.
Posted : March 11, 2019 12:49 am
Topic starter
Thank you so much! I will try to merge my two reports.
Posted : March 15, 2019 8:09 am
