Using previousvalue formula to supress in selection expert

[tcbc]

Why , When I use previousvalue formula to supress dupes within detail section of selection expert does it supress all lines of the first line.

Example

123 Dog Boxer
123 Dog Boxer
456 Cat Domestic
456 Cat Domestic

I see

456 Cat Domestic but not one line of the first row.

I sorted decending and it did the same thing.

 

[IanWaterman]

Try adding

not onfirstrecord or .....

Ian

 

[tcbc]

If my formula in formula editor is this
formula = {master_cred.lookup} = previousvalue {master_cred.lookup}

at what location would I use notfirstrecord. Where would I put it

 

[IanWaterman]

If suppression rule then

If not onfirstrecord and {master_cred.lookup} = previousvalue {master_cred.lookup} then true
else
false

 

[lbass]

If you don't check the box to suppress and ONLY enter the conditional formula:

{master_cred.lookup} = previous({master_cred.lookup})

...the first row will not be suppressed. Because there is no previous record, the conditional formula does not execute on the first record, and therefore defaults to the status of the checkbox.

-LB

 

[Madawc]

Wouldn't it be easier to group by categories like "Cat Domestic", suppress all detail lines and just show the values in the group header or footer?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10