Post reply

How to make tablix visible based on parameters in SSRS

  • March 24, 2014 at 3:27 pm

    #1699693

    I almost feel cheeky answering this - only because you are so close.

    You can set the Visibility of a chart/tablix/control by setting the Visibility Property of the chart/tablix in question:

    Choose "Show/Hide based on an expression" and then you can specify

    @prmValue = "Value 1"

    so that the control will be hidden if that's true.

    e.g.

    =Parameters!prmHideReport.Value="Tablix2"

  • March 27, 2014 at 5:45 am

    #1700635

    You have two options really, if all three tables are using the same data set then combine them into 1 table (on different rows) and use an IF statement on the Tablix' Row Visibility Expression to only show row1 if parameters value equal ABC; only show row2 if parameter is BBC etc. Something like this: -

    =IIF(Parameters!Test.value = 'ABC', FALSE,TRUE)

    If there are using different data sets then you can put the above IF statement in each table and that should do it.

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

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