Display group data in another group

[ksaab2002]

How would I write a formula to display group data in another group?

I have a group1 on person, group2 on email (formula that grabs email if one is there) and group3 on invoice..One person, One Invoice, many emails. Group headers are suppressed and data is displayed in the footer.
I would like to display all possible emails in a list on the same line for any given Invoice?

My data looks like this:
Person Invoice EMail
JDoe 89782396
jdoe@test.com
jjdoe@yahoo.com

I would like it to look like this:
Person Invoice EMail
JDoe 89782396 jdoe@test.com, jjdoe@yahoo.com

I am using CR 10 and SQL 2000

Thanks in advance for any suggestions..

KSaab

 

[lbass]

Create three formulas:

//{@reset} to be placed in the person group header:
whileprintingrecords;
stringvar email := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar email := email + {table.email} + ", ";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar email;
left(email,len(email)-2);

-LB