Have A collumn be hidden if user Selects True on a Parameter.


I have a Summary Report that is working fine but the client want to have a collumn in the table hidden if the parameter "MonthsEnd is set true the want the collumns DT not to be shown in the report. I'm not sure what is the best way to show the results?



SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,825 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points

    Hi @Jannette Jones
    Do your tables share a dataset?
    If not, you need to set the visibility of each [DT] column in Tablix with an expression, such as:


    Best Regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor

    Hi @Jannette Jones
    I agreed with Joy. You can set the visibility of report items based on report parameters. For more details, you can refer to this link: hide-an-item-report-builder-and-ssrs.
    Best regards,

    0 comments No comments