Post reply

Hiding columns with no data

  • March 3, 2009 at 3:57 am

    #200464

    I have created a report that contains a customer's users and their services. Some services do not apply to the customer specified, so naturally these services clutter up my report with unnecessary columns that contain empty strings.

    I need to hide the columns which are empty. I just can't seem to figure out which expression to use. I am using VS 2005.

    Any ideas?

    Cheers.

    /M

  • March 3, 2009 at 5:58 am

    #952357

    Eureka! Found the solution myself. (Thank you, Google!)

    My results are not only empty but also NULL, if the column should not be displayed.

    Therefore I can use IIF(IsNothing(Fields!MyField.Value), true, false) as the expression.

    This might seem obvious to most of you, but it just made my day 🙂

    /M

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply