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

Anonymous
2022-10-14T15:33:08.483+00:00

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?

250449-remove-dt-if-value-is-true.png

250564-remove-dt.png

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
    2022-10-17T01:56:20.287+00:00

    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:

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

    Best Regards,
    Joy


    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
    2022-10-17T06:40:15.99+00:00

    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,
    Aniya

    0 comments No comments