Suppressing a section where date field is not null or empty

[AngEm]

I am trying to suppress a section where field is not null and cannot seem to get the formula correct. Suggestions?

Thanks

 

[bdreed35]

Try:

isnull({table.field})

If that doesn't work, post what you have been using and where you are trying to use it.

~Brian

 

[synapsevampire]

The formula should be something like:

isnull({table.date})
or
{table.date} < cdate(1900,1,1)

I use the second part because I don't know your Crystal version or the database being used, much less the format of this date when potentially null or blank, these things vary depending upon the environment and settings. Note that null checks must be performed first.

I'm guessing that you're new to computers, so please understand that software versions and in this case the database being used are critical to understanding the implementation.

-k

 

[AngEm]

I have a list of items that have a completion date field. I am trying to suppress the items where the completion date field is still empty, I want to see outstanding items only.

 

[AngEm]

Sorry.
I am using Crystal 8.5.
Oracle database.
Date format is "2005/06/22 16:40:34.00

 

[Turkbear]

Hi,
That would be better served by a Record Selection formula rather then supressing it after it is returned from the database..

Use
IsNull({table.competiondate})

Check ( using the show sql option) that the where clause has this in it ( probably will say
where {table.completiondate} IS NULL )





To Paraphrase:"The Help you get is proportional to the Help you give.."