I've read that this same issue has been asked several times but I haven't been able to find the correct solution for my problem.
I have a one to many issue. I have a custom stored proc that returns patient, order, and assessment data. For each patient they can have multiple orders and multiple assessments. Each of the three tables are linked by the PatientVisitID. There is no link between the orders and assessments other than PatientVisitID. Each of orders and the assessments have their own unique ID's.
Here is what my raw data looks like:
I've created a group for the patient and that took care of the duplicates. I then created groups on the OrderID and AssessmentID and placed the OrderDate in the OrderID Group and then placed the AssessmentDate in the AssessmentID group.
<GH1>Patient Name with PatientAcct, PatientName, and DischargeDate
<GH2>OrderID with OrderDate
<GH3>AssessmentID with AssessmentDate
<Detail>suppressed
<GF3>suppressed
<GF2>suppressed
<GF1>blank
So here is what the data comes out like in the report:
Here is what I would like it to look like and I can't figure it out for the life of me.
Thank you in advance!!
John
I have a one to many issue. I have a custom stored proc that returns patient, order, and assessment data. For each patient they can have multiple orders and multiple assessments. Each of the three tables are linked by the PatientVisitID. There is no link between the orders and assessments other than PatientVisitID. Each of orders and the assessments have their own unique ID's.
Here is what my raw data looks like:
Code:
[b][u]PatientAcct[/u] [u]PatientName[/u] [u]DischargeDate[/u] [u]OrderDate[/u] [u]AssessmentDate[/u][/b]
12345 John Smith 2013-01-08 2013-01-05 2013-01-06
12345 John Smith 2013-01-08 2013-01-05 2013-01-07
12345 John Smith 2013-01-08 2013-01-05 2013-01-08
12345 John Smith 2013-01-08 2013-01-07 2013-01-06
12345 John Smith 2013-01-08 2013-01-07 2013-01-07
12345 John Smith 2013-01-08 2013-01-07 2013-01-08
I've created a group for the patient and that took care of the duplicates. I then created groups on the OrderID and AssessmentID and placed the OrderDate in the OrderID Group and then placed the AssessmentDate in the AssessmentID group.
<GH1>Patient Name with PatientAcct, PatientName, and DischargeDate
<GH2>OrderID with OrderDate
<GH3>AssessmentID with AssessmentDate
<Detail>suppressed
<GF3>suppressed
<GF2>suppressed
<GF1>blank
So here is what the data comes out like in the report:
Code:
[b][u]PatientAcct[/u] [u]PatientName[/u] [u]DischargeDate[/u] [u]OrderDate[/u] [u]AssessmentDate[/u][/b]
12345 John Smith 2013-01-08
2013-01-05 2013-01-06
2013-01-07
2013-01-08
2013-01-07 2013-01-06
2013-01-07
2013-01-08
Here is what I would like it to look like and I can't figure it out for the life of me.
Code:
[b][u]PatientAcct[/u] [u]PatientName[/u] [u]DischargeDate[/u] [u]OrderDate[/u] [u]AssessmentDate[/u][/b]
12345 John Smith 2013-01-08
2013-01-05 2013-01-06
2013-01-07 2013-01-07
2013-01-08
Thank you in advance!!
John