How do I suppress a text object when a certain field is empty or null? 1

[puitar]

Thanks!

 

[EngJoo]

hi puitar,

i think you should highland the field, then right click --> format_field. under the common tab. you thick the supress then go to formula

try to type

{employee.emp_name} = "null"

then i think its could help.

tell me your outcome.

hehe tell you, this is the first time i post my opinion to help to solve the problem because most of the question i dont know.hahah

good luck

 

[puitar]

Thanks! but...
The field is a memo and crystal doesn't let you play with memo fields. dammit

 

[EngJoo]

what is memo field?
may i know what u do with crystal report?
any contacts?
name?
may be we can exchange idea next time

 

[dgillz]

{employee} = "null" will only supress if the employee's name is "null". I don't know of anyone by that name....maybe in Europre somewhere?

IsNull({memofield}) should work, even with a memo field. While it is generally true that you cannot use a memo field in a formula, you should be able to conditionally suppress it based on an isnull() test as I have shown. I do not have a database with a memo field in it or I would test it.

Please let me know your results. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[puitar]

Thanks guys!

puitar@hotmail.com