March 24, 2014 at 3:12 pm
I have a Report which has 3 parameters ABC,BBC,CBC and i have three tablix TAB1,TAB2,TAB3 .
my requirement is to
Display tablix TAB1 when parameter is set to ABC.
Display TAB2 when parameter is set to BBC.
display Tab3 when patrameter is set to CBC.
what is the expression i need to write in visibility property of each tablix.
Thanks in advance
March 24, 2014 at 3:27 pm
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
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply