2 Replies Latest reply: Mar 1, 2012 3:22 AM by jagan mohan rao appala RSS

    How to make a row not load in an expression

      Hi i'm looking for an expression to make a row not load if the data is blank in multiple rows, see example


      Customer NumberLandlineMobile
      00101234 45678907890 123456
      00208791 123456

      Customer number , land line and Mobile details exist in different tables.


      I want to write an expression where the Customer Number Row will disapear if there are no land line or mobile details(see row 4&5)


      Ive tried suppress value when null which you can do one or either but not both because all the data disapears. Is there a work around to this?