User Support Forum

I'm getting real comfortable writing custom reports but can't figure this one out. I want to print a simple(?) list of family's address and all their kids in the following format:
Joe & Mary Doe
1234 2nd st
Anytown, USA
(Mary, Bob, Johnny, Ed)

I can only figure out how to print the following format:
Joe & Mary Doe
1234 2nd st
Anytown, USA
Mary
Bob
Johnny
Ed
Can someone tell me how to get the kids names listed on one line? Thanks

John,

To get things from different records to print on the same line, you are going to need to use variables. You will have to create a variable to string together all the kids name into one string and then print that string in the group footer for the family.

Take a look at the m.kids variable in this post, it shoud do what you are looking for.
http://www.powerchurch.com/forum/viewtopic.php?t=2931

I looked at that and played with my report and finally got it to print the way I want it too. Thanks much.