Suppress a text object in group Header based on record in detail 1

[tsd30135]

Hello all

I need to turn suppress off on a text object based on the existence of a -1 in the nta field from the database. The logic needs to be such that if a -1 is found in any data record for field nta then the field is turned on (displayed) and to ignore any further values in the field.

Any ideas?

Thanks in advance

Tsd30135

 

[lbass]

The detail formula will increment only if there is a -1 in the NTA field. The second formula sums the NTA field per person. If the sum <> 0, then the suppression will not work.

-LB

 

[synapsevampire]

Ahhh, it was a string.

I knew I should have whined louder about the data types earlier...

-k

 

[tsd30135]

Thanks everyone. I will remember to post the data types of the fields

Tsd