set visibility of a column in a table based on a parameter

Posted on 2005-04-26
Last Modified: 2008-03-06
how do i set the visibility of a column based on a parameter in a report using SQL Server reporting Services,
Question by:vinny45
    LVL 7

    Accepted Solution

    of an entire column?  You would do this....

    1) Highlight the entire column by clicking the gray column button at the top of the table
    2) In the properties window, scroll down to Visibility
    3) Click the plus sign
    4) Pull down the drop-down next to "Hidden" and choose Expression
    5) In the right hand expression window, your expression will look something like this:

    =IIF(Parameters!MyParameter.Value = "HideTheColumn", True, False)

    That's it.  Working with the IIF statement above, essentially, if my parameter called "MyParameter" is set to "HideTheColumn" then the column will be hidden, else hidden=false.

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now