Displaying information for one ID at once.

[gtimmies]

Hi everyone,

I am building a report and I need a little help.

Below is what my report looks like currently. (I do not have permission to link yet so I will type it out)

Roll Number: 19-000-000-00000-0000
Use: Commercial

Roll Number: 19-000-000-00000-0000
Use: Residential
​

Instead of displaying the two uses as two records, I would like to have the uses displayed under one roll number because it is for the same roll number. Below is what I hope my final result will look like.

Roll Number: 19-000-000-00000-0000
Use: Commercial
Residential
​

I was wondering what I can do so my report looks like the above.

Thank you in advance for your help

 

[Mr. B]

Try creating a group for the Roll Number field and place that field in the group header and keep the Use field in the Details section.