Here's a formula that will give you the first 508 characters or so, and then ignore the rest--so if you have more characters than that, you will need to adapt this further. The code is only slightly adapted from a formula that another contributor here, Naith, developed in a much earlier thread:
//{@accum} to be placed in the details section:
whileprintingrecords;
stringvar firstst;
stringvar secondst;
if instr(firstst,{table.name}) = 0 then
if instr(secondst,{table.name}) = 0 then
if secondst = "" then
if len(firstst) + len({table.name} + ", ") > 254 then
secondst := secondst + {table.name} + ", " else
firstst := firstst + {table.name} + ", "
else
if len(secondst) + len({table.name} + ", ") > 254 then
secondst := secondst else
secondst := secondst + {table.name} + ", "
else secondst := secondst
else firstst := firstst;
I changed the variable names, so now you have two display formulas:
//{@firstst}:
whileprintingrecords;
stringvar firstst;
left(firstst,len(firstst)-2);
//{@secondst}:
whileprintingrecords;
stringvar secondst;
left(secondst,len(secondst)-2)
Insert a text box in the report footer, and add {@firstst}, followed by ", " and then add {@secondst}. Format the text box (format->text->common) to "can grow."
-LB