Section Expert - Suppression Formula

[Krusher]

This has been on ongoing problem for me. It seems as if I can't have more than one condition statement when suppressing a Section in the formula field:

isnull({EMPLOYEE.EMAIL}) or
EMPLOYEE.EMAIL = "OFFSITE ADDRESS"

The section is only being suppressed if the first condition is met (isnull). I am using Crystal Reports 10 with Oracle 9i. Any help would be greatly appreciated.

-K

 

[synapsevampire]

It allows for 2 conditions, and your syntax is fine.

Try this:

isnull({EMPLOYEE.EMAIL})
or
1 <> 0

Everything is now suppressed, correct?

So the second condition is honored.

I'd guess that you've mispelled something or the case is lowercase or mixed.

-k

 

[dgillz]

I noticed that you did not put brackets around the second EMPLOYEE.EMAIL field. Also try to trim() and uppcase() this field.

isnull({EMPLOYEE.EMAIL}) or
uppercase(trim({EMPLOYEE.EMAIL})) = "OFFSITE ADDRESS"

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

 

[Madawc]

Is "OFFSITE ADDRESS" just part of the field you are testing? If so, you'd need something like

"OFFSITE ADDRESS" in EMPLOYEE.EMAIL

If a test is failing, put it as a separate formula field, which should return True or False. Add a test detail line below your data and see what you get.

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