Home Forums Reporting Services Reporting Services 2005 Development Hiding Null value rows RE: Hiding Null value rows

  • July 15, 2011 at 10:02 am

    #1353525

    sdvoranchik (6/1/2011)

    I just tested this as well and it worked fine for me. In SSRS 2005, first make sure you select the entire row, not just a single cell or textbox. In the properties pane expand Visibility and in the Hidden property create an expression. This is the expression I used utilizing AdventureWorks:

    =IIF(IsNothing(Fields!AddressLine2.Value),True,False)

    My entire address line 2 row was hidden and the rest of the text was collapsed togther.