How to Suppress a record with a NOT NULL value

Question

User635243920 posted

I know the code to suppress a NULL value is (Isnull({table.field}))

What would I change to make it so that it will suppress records where a certain field is NOT NULL.  I am trying to suppress records that have an end date entered.

Thanks in advance!

Answer 1

User306743125 posted

If I recall...

not(Isnull({table.field}))

Answer 2

User-578610739 posted

Hi Ibeau310,

You can give conditional suppress, for that right click on that field, make suppress and nr above right hand side blue button for conditional suppress. click on that and write as

if( {table.field} == '2013/01/01')
return true;
else 
return false;


or simply write

if( {table.field} == '2013/01/01' )
true
else false

Now ok or close it. now you see a button colr is red which show in there some thing.

Please see .

http://forums.asp.net/t/1569924.aspx/1?Conditional+format

Answer 3

User635243920 posted

Thank you!