We help IT Professionals succeed at work.
Get Started

How do I group information from multiple rows of the same PatientID?

Kevin
Kevin asked
on
221 Views
Last Modified: 2015-03-19
Hello,

I am using Crystal Reports v12 with a spreadsheet as my data source.

In my spreadsheet I have a few rows which contain the same PatientID. I am trying to group some of the information together for the rows with the same PatientID, but cannot figure out how to do this.

Is someone able to advise how I can accomplish this?

See attached as an example:

data
Data.png = Sample data from the spreadsheet.

PatientID-5454
PatientID_5454.png = Sample of expected results for patient ID 5454 showing insertions.

PatientID-4522
PatientID_4522.png = Sample of expected results for patient ID 4522 showing insertions, mainly the three (highlighted in yellow) from the spreadsheet.

Kindly advise.

Regards,
N
Comment
Watch Question
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE