Suppress TextBox Object

[FJR]

Not sure this is possible...but it seems so easy but doesn't work!! I've added a formula field to my detail section, called it recno.

The recno formula is -> Round(RecordNumber,0)

I've added another TextBox to the detail section and I want to suppress the TextBox based on the recno value. So in the Suppress formula I have ->

If {@recno} <> 7 Then
false
Else If {@recno} <> 8 Then
false
Else If {@recno} <> 12 Then
false
Else
true

They all display!! Can anyone help? Thanks in advance...ugh!!

 

[Madawc]

I'd do it as a boolian. Create a formula field:

{@recno} in [7, 8, 12]

Put this beside the data, to check it works OK. Then invoke it to suppress. If you'd called it @BadText, then you'd say not @BadText to suppress eveything that had a value other than 7, 8 or 12. (I'm not clear which way round you wanted it: to show only 7/8/12 would be @BadText

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

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

 

[dgillz]

Dump the round formula, it is not needed.

Try this:

If Recordnumber in [7,8,12] then false else true

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[FJR]

THANKS dgillz and Madawc!!!!!! THAT WORKED!!!