Hi,

Maybe this should be a Reply to my earlier post, but I thought it would be less confusing starting fresh.

First I'll phase this as concisely as I can, then I will explain more (for you patient saints)

How can I make this:

(totext({Activity.StartTime}) in {@runString}) = False (currently in Record Selection)

run BEFORE:

Global StringVar D;
D := (D & totext({Activity.StartTime})); (currently in {@runString} in the details section)

I need to suppress records that have a particular field duplictated. My idea is to create a global array of the the fields in question and check each new record for duplicates against that array. I'm too unsure of syntax to code this...SO..instead of an array I created a Global StringVar in to which I concatenate the potentialy duplicated field. I can check to see if the contents of the field, for each record, are contained in the StringVar.

It really seems as if it will work if I can get it to perform the evaluation BEFORE it concatenates the new value to the StringVar. As it is now, it performs the concatenation first and therefore, during the comparison, a duplicate is always found.

Here's what I have....

I have a formula field called {@runString}, in this field I put this code:

Global StringVar D;
D := (D & totext({Activity.StartTime}));

I put {@runString} in the details section. (I have tried it in group headers and footers and had no luck either)

In the Record Selection Formula Editor I put this code:

(totext({Activity.StartTime}) in {@runString}) = False

I hoped this would cause the report to not select records where this field had come before in another record (the records are sorted by another, non-duplicating, date field)

When this didn't work (the StringVar concatenation had already taken place), I tried puting it in the Section Editor to supprress records using a True value (totext({Activity.StartTime}) in {@runString}) = True. In this case the concatenation still takes place first.

I'm 99% sure this will do exactly what I need if I can get the concatenation to take place AFTER the evaluation. Ihave tried placeing the code in different place, but I'm very unsure of what options there are for controling when these things execute.

Any help would be GREAT!

Thanks.

Chuck

Thanks very much for responding.