Conditional supress

[matpj]

how can I write a formula to check if a field in one of my group records has not changed since the last record?

I want to add this so that I supress certain fields.

Also, is it possible to supress, but display test in the field such as "No Change"
Or failing that, change the colour of a field or entire row?

 

[Naith]

Base your suppression and colour conditions on the Previous function.

e.g. If {Field} = Previous({Field}) Then xxx

 

[matpj]

hi,

if I try this :

if {Budget} = previous({Budget}) then "no change"

it complains that it must be a boolean.

 

[Naith]

Yeah, cos you're doing that in the X+2 button of the Suppress option, I guess.

You want to paste that exact formula into the body of a new formula, and in the area where you're currently trying to enter the formula you just posted, replace "no change" to True.

Remember that anytime you get an error message complaining about boolean values, you basically want to insert a True or False somewhere.

Naith

 

[matpj]

ok thanks.
when I try it I get errors from other supress formula etc.
so I might try and live without it.

I have seena display string format option, and have tried using it with my formula - but nothing happens...

have you used it before?

 

[matpj]

as an alternative - can I supress an entire row from being displayed but hold the data for it for my calculated fields etc?

 

[matpj]

scrub the holding of data bit!
I just need to make rows with duplicate budget fields disappear!