Post reply

Hide column IF all rows in that column are null

  • December 10, 2015 at 9:47 pm

    #310107

    Hello,

    Trying to finish this last report, sadly ran into a hurdle.

    I am trying to hide an Entire Column IF all rows in that column are null, However if there is a number or varchar then dont hide, hope that makes sense, example below:

    Column 1 Column 2

    null null

    null null

    null Stuff

    null null

    so I would like to hide column 1 since its all null, but for column 2 show it since there is something on one of the rows.

    hope anyone can help on this, thanks in advanced

  • December 10, 2015 at 9:56 pm

    #1845400

    if your using SSRS, then you can toggle the visibility of the column using an expression ,

    something like

    iif(SUM(len(colA))=0 , FALSE, TRUE)

    Jayanth Kurup[/url]

  • December 10, 2015 at 10:21 pm

    #1845403

    THANK YOU JAYANTH!

    yup that worked 🙂 you da man 🙂

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

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