Simple Crystal Reports?

I have a database of: File Number, Task Description, Date Completed, Who Completed it.

Example: File Task Date Who C1023 Examined Property 01/01/2016 Jack C1023 Typed Property Report 01/02/2016 Sally C1023 Reviewed Report 01/02/2016 Jeff C1023 Sent Report to Client 01/03/2016 Mary C1025 Examined Property 01/02/2016 Jack C1025 Typed Property Report 01/02/2016 Amy C1025 Reviewed Report 01/03/2016 Jeff C1025 Sent Report to Client 01/04/2016 Mary

I can figure out how to do report in Crystal where I use the file number as the group and then detail of each task but it is in rows. I really would prefer the data in columns.

Example:
File Task Examined Report Typed Report Reviewed Sent to Client C1023 Property Exam 01/01/2016 01/02/2016 01/02/2016 01/03/2016 C1025 Property Exam 01/02/2016 01/02/2016 01/03/2016 01/04/2016

What is the best way to accomplish that?

Recent Questions...