:) A bit more scouting and I found the answer from here, its ingenious and it concatenates all my records onto one line in my report footer exactly as I wanted them, hooray!:
http://forums.codeguru.com/showthread.php?524357-RESOLVED-Multiple-Rows-to-a-single-rowStudy the next solution, where we are concatenating a field and display the resulting string at group or report footer in only one line
To do that, you have to create 3 formulas:
The first one, let's call it @null:
Code:
whileprintingrecords;
stringvar names := "";
Place it in your GH section, it will return you null.
The second one, let's say @comma_field:
Code:
whileprintingrecords;
stringvar names;
names := names & ", " & {table.field};
Place it in your Detail section which you can suppress; the formula will return you next:
, Jules, Christina, Paul
and the 3rd formula, let's call it @final (or whatever you like):
Code:
whileprintingrecords;
stringvar names;
Mid(names, 3);
Place it in your GF or report footer section.