combining text fields 1

[jchewsmith]

I have a report that can have multiple records with the only difference being a notes field,

I would like to combine each note field from a group to create one summary field.
Example:
Rec # Title date user Notes
1 ABC 1-1-10 jim I want to see
2 ABC 1-1-10 jim you in my
3 ABC 1-1-10 jim office please.

I want result to be: I want to see you in my office please.

 

[fisheromacse]

most likely you woiuld need to concatenate and then display them in the group footer, with a reset in the group header.

One formula to gather the information (place in details):
//{@GatherText}
whileprintingrecords;
stringvar GT;
GT := GT & {yourtable.notesfield} & " ";

One formula to display the information (place in group footer):
//{@ShowText}
whileprintingrecords;
stringvar GT;
GT

One formula to reset the variable (place in group header)
//{@ResetText}

 

[fisheromacse]

ooops, {@ResetText} should be:
whileprintingrecords;
stringvar GT := "";