Options

Suppress row from report if a given field is null

Joseph_NoufailyJoseph_Noufaily Member Posts: 7
edited 2014-01-02 in NAV Three Tier
Hi,

I'm using Navision 2009 i want to create a report to be used by a roletailored client.
How can i delete a row in a table if the value of a given field in this row is null or blank.
Thank you for the help.

Comments

  • Options
    geordiegeordie Member Posts: 655
    It's possible to manage row visibility (hidden property on table row) in layout design testing the length of the data:
    =IIf(Len(Fields![FIELD].Value) = 0, True, False)
    

    Is there any particular requirement you need to accomplish?
  • Options
    Joseph_NoufailyJoseph_Noufaily Member Posts: 7
    Thank you for the help i just tried it and it worked
Sign In or Register to comment.