I created a report which is displaying 2 records for each student. The student ID, Name, DOB all these fields are repeated and is same, the only difference is there are other fields that are not similar, 'Submit Date', 'Approved by ID, 'Approved by'. I would like to merge this data into one record. Is this possible in Crystal report? Thanks in advance.
This a dummy data for reference.
StudentID Name 'Submit Date' 'Approved by' 'Approved by ID'
1234, SAM, '10/01/2018 4:04:18 PM', Hary, hry243
1234, SAM, '10/02/2018 12:30:51 PM', John, jhn334
StudentID Name 'Submit Date 1' 'Approved by 1' 'Approved by ID 1' 'Submit Date 2' 'Approved by 2' 'Approved by ID2'
1234 SAM '10/01/2018 4:04:18 PM', Hary, hry243, '10/02/2018 12:30:51 PM' John jhn334