Test for Hidden Columns

  • I have a report where the user can expand the columns or hide them.  The is not based on a parameter but dynamic within the report.
    However I would like the Column Header/Text Box to change based on whether or not other columns are visible.  How might I test to see if a specific column is visible and have that in an Iif statement.

    Thank you,

  • Ken at work - Thursday, March 23, 2017 2:04 PM

    I have a report where the user can expand the columns or hide them.  The is not based on a parameter but dynamic within the report.
    However I would like the Column Header/Text Box to change based on whether or not other columns are visible.  How might I test to see if a specific column is visible and have that in an Iif statement.

    Thank you,

    What's wrong with using an IIf() function?   You'll have to place whatever you use in some kind of expression anyway...

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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