Hide a Static Row/Column in a Matrix

How can I hide a static row/column in a matrix? The static row/column should
only display depending on a parameter.
thanks,The column should have a visibility property, you can put an expression in
there I think.
"Jiabin Xie" wrote:
> How can I hide a static row/column in a matrix? The static row/column should
> only display depending on a parameter.
> thanks,
>|||On Feb 28, 8:40 am, adolf garlic
<adolfgar...@.discussions.microsoft.com> wrote:
> The column should have a visibility property, you can put an expression in
> there I think.
>
>
> "Jiabin Xie" wrote:
> > How can I hide a static row/column in a matrix? The static row/column should
> > only display depending on a parameter.
> > thanks,
Here is an example. Select a cell in the matrix in Layout view, open
the 'Properties' window and in Appearance -> Visibility -> Hidden,
select '<Expression...>' from the drop down menu and enter something
like:
=iif(Parameters!SomeParameterName.Value = "TargetValue", true, false)
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer