locked
How to Suppress a record with a NOT NULL value RRS feed

  • 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!

    Tuesday, June 18, 2013 2:31 PM

Answers

  • User306743125 posted

    If I recall...

    not(Isnull({table.field}))



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 18, 2013 2:40 PM

All replies

  • User306743125 posted

    If I recall...

    not(Isnull({table.field}))



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 18, 2013 2:40 PM
  • 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

    Wednesday, June 19, 2013 12:55 AM
  • User635243920 posted

    Thank you!

    Wednesday, June 19, 2013 11:56 AM