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.
Thanks!