I have a report showing the most recent OB & it's value by doing a record sort in ascending order. Then I put the recent OB & value into a group then set the remaining data underneath the group to hidden so it won't show up on the report. But when go to selection criteria it searches in the data values eventhough its set to "hidden". How can I have the selelction criteria to search by the data thats in the group only?
Thanks!
can't. selection criteria compares to database data, not report data (displayed or suppressed).
🙁 I was hoping it could be done. So there isnt a way to pull the most recent Observation for the given OBSHEAD.NAME without having to do record sort to have the unnecessary data as part of the report. I only need to pull the most recent OB for a certain OBSHEAD.NAME. ?????
Connect the LASTLABS table to RPT_OBS by PID, HDID, & MAXLABDATE.
Thanks for your reply but I am not seeing LASTLABS or RPT_OBS in my list of tables. I am on Centricity 9.5????
They are views.
Thanks!! When I put in the PERSON.SEARCHNAME, LASTLABS.MAXLABDATE, & OBSHEAD.NAME in the report. It lists the searchname more than once for the one OBSHEAD.NAME rather than listing it one time with the latest lab date (LASTLABS.MAXLABDATE) as I thought it would? The goal I am trying to get at is to list the patient once with the max lab date with its lab value for the OB rather than having to hide/surpress the duplicate patient names.