I can't get a report to look the way I want it to. :( (1 Viewer)

[SomeGuy]

I have a report where we want to see who our project leader have been working with. Presently the report appears like the following:
Project Head ------------------Associates
John Doe -----------------------Jane Doe
-------------------------------Tim Doe
-------------------------------Weedle Doe
and so on (I put in the dashes so it would keep the format)

Is there any way to get the associates names to follow one another in more than just one column like this:

Project Head: John Doe
Associates: Jane Doe, Tim Doe, Weedle Doe, etc

I would like it this way because if they associate with many people, it won't end up running onto another page.
Any help is appreciated.

 

[chrismcbride]

In the Format event of the section of your report that holds the control you would like to populate with the Asociate names, you can set up a recordset with all the associate names that match the selected leader id. Once this is done, loop through the recordset and concatenate the name values with commas and spaces in order to make a string of names. Build this string in a variable and when the loop is done, transfer the string into a text field that has it's CanGrow property set to True.
Good Luck
Chris

 

[SomeGuy]

Thanks. I'll give that a try.