Solved

Crystal Reports--specifying a specific detail row to select

Posted on 2016-08-10
2
63 Views
Last Modified: 2016-08-10
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.
0
Comment
Question by:CMCITD
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 41750648
Try this

Set a CUSTOM sort order for the locations so the highest priority locations sort first
Put the location in the group header
Hide the details

mlmcc
0
 

Author Closing Comment

by:CMCITD
ID: 41750878
Simple, easy--should have spotted that way myself.  There I was about to write a formula to set priority status to each word...

Thanks!
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question