I have a Crystal Report that is grouped by a Medical Record Number for patients--and an end user specifies a time frame to pull all visits for patients within a date range. Within those patients, there will be multiple visits within our hospital.
Right now, under the Group Section--it is simply pulling the 1st location in the DB. For example, I run the report and select the last month;
Patient Zero
---was seen in Emergency Room {Location.ER}
---was seen in Medical Surgical Floor {Location.MedSurg}
---was seen in Lab {Location.Lab}
Since it's grouped under the Patient Zero medical record number, it just displays the {Location.ER}. Desired behavior would be a prioritized list, so it displays the most applicable location. For example;
IF Patient Zero was seen in ER, MedSurg and Lab--then only display MedSurg.
I would then set the priority locations in the order I choose. The end game of this--is we send out this list for a survey for our patients--and we value surveys in one area over another. Thanks for any help. I do have SQL experience and access to the DB if it comes to that.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.