Suppress row from report if a given field is null

Joseph_Noufaily
Joseph_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

  • geordie
    geordie 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?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • Joseph_Noufaily
    Joseph_Noufaily Member Posts: 7
    Thank you for the help i just tried it and it worked

Categories