Share via

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,878 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,571 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,421 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