Combining Detail in Group Footer?

[dboylan]

Maybe you can point me in the right direction.
I would like to combine 2 detail records but only print the different Sport IDs. Do I use a Group Footer?


Here's a visual rep:
Brown ID Lastname Firstname Sportid
00055555 boylan david BB
00055555 BOYLAN david F
I'd like to see:
Brown ID Lastname Firstname Sportid Sportid
0005555 boylan david BB F

 

[chelseatech]

You build this up with formulas using variables...
Group your data by BrownID.
Formula in group header....
WhilePrintingRecords; stringvar sportlist:="";
(The group header section should be suppressed)

Formula in details....
WhilePrintingRecords;
stringvar sportlist:=sportlist + ", " + {table.SportID};
(The detail section should be suppressed)

Formula in group footer....
WhilePrintingRecords;
stringvar sportlist;
mid(sportlist,3) //to ignore leading comma and space
(place other fields in this section)
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[ppark001]

Hi,

Thank you for this formula. I also need to string together several detail lines. However, my problem is that I ran into a limit of 254 characters. Is there any way to string together several detail lines that are over 254 characters?

Thanks,

Paula Park