Suppress details section with OR statement

[dz0k52]

I am using Crystal 8.5 and am having trouble suppressing a details sections with an OR statement. My statement is
{WORKORDER.STATUS} <> 'WAITASGN' or {WORKORDER.WO13} <> 'Y'
and is placed in the X-2 box of the suppress button.
Whichever one is listed first works but not both. What am i doing wrong??

 

[synapsevampire]

Hmmm, it should work...

Now it may be that nulls are at play here, and confusing things, so you might allow for mulls as well:

Try:

(
isnull({WORKORDER.STATUS})
or
{WORKORDER.STATUS} <> "WAITASGN"

)
or
(
isnull({WORKORDER.WO13})
or
{WORKORDER.WO13} <> "Y"
)

-k

 

[dz0k52]

Believe it or not I try records with both suppressions and neither works now.

 

[synapsevampire]

Try:

(
isnull({WORKORDER.STATUS})
or
{WORKORDER.STATUS} <> "WAITASGN"

)
and
(
isnull({WORKORDER.WO13})
or
{WORKORDER.WO13} <> "Y"
)

I should have use AND.

-k

 

[synapsevampire]

Sorry, screwed up again...

(
not(isnull({WORKORDER.STATUS}))
or
{WORKORDER.STATUS} <> "WAITASGN"

)
and
(
not(isnull({WORKORDER.WO13}))
or
{WORKORDER.WO13} <> "Y"
)

-k