Multiple records per line in Detail section

[JohnVDB]

I have a report where I have a header that contains the usual information about a person (name, address etc)
Each person is on multiple committees. The committees get listed in the detail section, but each one is on a separate line. I would like to have multiple records per line to save some paper and make the report more readable.

I have:
John Doe
123 Any Road, Anytown, PA 15139
Executive
Rules
Green

I would like:
John Doe
123 Any Road, Anytown, PA 15139
Executive, Rules, Green

 

[jiqjaq]

You need to add a group footer based on the person. Put a textbox field in the footer and in the Detail_Format append the committee for that record into that field. In the Print section for the footer clear out the field to get ready for the next person.

The append statement would be something like:
Me.AllCommittee = Me.AllCommittee & IIF(Me.AllCommittee<>&quot;&quot;, &quot;, &quot;,&quot;&quot & Me.txtCommittee

You need the IIF to avoid printing the leading comma from the list.

In the Print: Me.AllCommittee = &quot;&quot;