I don't believe that suppressed values show in Excel...it is basically a copy of the report that you can see. The supressed values are still used in calculations though.
The best that I can think of is in the Record Selection Formula, you could a value to check against to see if has already been selected. I use a string just because I don't have to redim arrays, something like:
shared stringvar already;
local stringvar thisRec = "|"{table.field1}+"@"+{table.field2}+"^"+{table.field3}+"|";
if instr(already, thisRec) > 0 then //already accepted
false;
else(
already := already + thisRec; // add so it is not accepted again.
true;
)
HTH
IP Logged
