Results 1 to 4 of 4

Thread: Suppress (null) values

  1. #1

    Default Suppress (null) values

    Hi again

    Im having some problems getting suppress to work.
    I want to suppress the field if there is no records to show.
    Currently VRW prints "(null)", but I dont want that.

    This is what Im trying in the function for suppress, but its not working.

    if isnull({WSHPVALG.TYPEVALGTEXT}) then
    return true
    else
    return false
    end

    What to do?

    Thanks,
    Jimmy

  2. #2
    Join Date
    Feb 2009
    Location
    Masterton, New Zealand
    Posts
    167

    Default Re: Suppress (null) values


  3. #3
    Join Date
    May 2013
    Location
    Hengelo, the Netherlands
    Posts
    12
    Blog Entries
    2

    Default Re: Suppress (null) values

    Hi Jimmy

    VRW will handle the return values from a DB call acordingly of the field type, a string type will be handled like a string.

    So when a field with a string type returns (Null) it will be converted to a string containing "(Null)".

    In your case you have to use
    Code:
    return ({WSHPVALG.TYPEVALGTEXT} = "(Null)")
    Met vriendelijke groet,
    with Kind Regards,

    Bénar Bloemendal
    Application Developer

  4. #4

    Default Re: Suppress (null) values

    Keith and Benar, you both hit the nail on the head. It works like a charm. Thanks to both of you :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •