Skip to Content
0
Jun 21, 2018 at 02:33 PM

How to group row data by a field

81 Views Last edit Jun 21, 2018 at 04:29 PM 2 rev

I have no issues grouping in SQL, but in Crystal Report can not figure it out. I have my report built and it displays fine, but I want to combine rows if there are multiple rows for a person, here each person has a field = PersonID. So one row for Debra Renee Byrd, would look like so.

01/03/2018 - Debra Renee Byrd - 24 - 960.00 - 24 - 816.00

Attachments

row.jpg (38.9 kB)