I have a report that is pulling several thousand contract records because the comments create a new record each time they are entered. I would like to concatenate the comments into a single record.....at least the first 5 comments.
I found the following solution and it would have worked but it exceeds a limit of 65,000+ records. I need to know if there is another way to do this without worrying about a limit??? Help please!
Insert a group on salesnum and then create three formulas:
//{@reset} for the group header:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";
//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x := x + {table.SText}+" ";
//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;
trim(x);
Then suppress the group header and detail section.
MB
I found the following solution and it would have worked but it exceeds a limit of 65,000+ records. I need to know if there is another way to do this without worrying about a limit??? Help please!
Insert a group on salesnum and then create three formulas:
//{@reset} for the group header:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";
//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x := x + {table.SText}+" ";
//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;
trim(x);
Then suppress the group header and detail section.
MB