on 01-23-2019 4:44 PM
I have a report that looks at discharge orders. Some patients may have more than one order. I only want to see those patients on my report. Right now I have the field in my details section so it pulls all of the orders. I do see some duplicates but I am also getting the all of the data I need to see. How do I only see those patients with more than one order ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this:
1. Group by Patient.
2. Go to Report >> Select Expert >> Group (or click on the down arrow next to the Select Expert button and select Group.)
3. Your formula will look something like this:
Count({MyTable.OrderNumber}, {Patient Group Field}) > 1
This will filter out all patients that only have one discharge order and only show those that have more than one.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.