troubleshooting Question

Crystal Reports--specifying a specific detail row to select

Avatar of CMCITD
CMCITDFlag for United States of America asked on
Crystal ReportsMicrosoft SQL Server
2 Comments1 Solution194 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros