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.png = Sample data from the spreadsheet.
PatientID_5454.png = Sample of expected results for patient ID 5454 showing insertions.
PatientID_4522.png = Sample of expected results for patient ID 4522 showing insertions, mainly the three (highlighted in yellow) from the spreadsheet.