so the tno field is a comma delimited string, or each field would look like 1000..1005?
If the later, there isn't a function. Crystal does not select data like that, you can only look at 1 line at a time. On the other hand, if it is this case, you could build a formula that would keep appending to a string that you could display in the group footer.
If just one record of TNO is 1000..1005,1006..1009,1010..1016 you should be able to write a formula to split it. I know that Crystal can loop, but I have never done it...never needed to.
the formula to split up the line is pretty simple
local stringvar orig := {tno}
local numbervar comma := instr(orig, ",")
local stringvar commaSep;
local stringvar ret;
while orig <>"" do
(
if comma > 0 then (
commaSep := left(orig, comma-1);
orig := mid(orig, comma + 1);
)
else(
commaSep = orig;
orig := ""
);
ret := ret + ", " + mid(commaSep, instr("..")+2);
);
ret
This should do it.
Hope this helps
IP Logged
