Prev: Accessing SSRS through SSMS
Next: Style of the first details column messed up (IE8 and FF3)
From: aaron thornberry on 29 Oct 2009 16:56
I am using IIF statements to show/hide tablix columns based upon a
parameter value. These statements are used as expressions in the
visibility properties for the columns.

If the parameter value is one that causes the column to be hidden, the
coulmn does not appear on the report, but there is whitespace in its
place.

I have used this functionality very frequently in SSRS 2005 without
the whitespace issue. The 2005 report automagically closed this
whitespace up by moving the column to the right of the hidden one to
now be adjacent to the column to the left of the hidden one at
rendering. This is what i need to happen now in 2008.

Has anyone else experienced this? If so, would you please share your
solution? I am getting extremely frustrated by this...

Thanks!!
From: Ben Watts on 2 Nov 2009 14:57
if you right click on the column and go to column visibility and click on
"Show or hide based on an expression". Put your expression in there and it
should work. Make sure to take your original expression out of the
properties window first. Not sure what the difference is but they work
differently.

Ben


"aaron thornberry" <aaron.thornberry(a)gmail.com> wrote in message
news:2e6113ca-b1d5-4670-b59f-e33dcbe52cea(a)l31g2000vbp.googlegroups.com...
>I am using IIF statements to show/hide tablix columns based upon a
> parameter value. These statements are used as expressions in the
> visibility properties for the columns.
>
> If the parameter value is one that causes the column to be hidden, the
> coulmn does not appear on the report, but there is whitespace in its
> place.
>
> I have used this functionality very frequently in SSRS 2005 without
> the whitespace issue. The 2005 report automagically closed this
> whitespace up by moving the column to the right of the hidden one to
> now be adjacent to the column to the left of the hidden one at
> rendering. This is what i need to happen now in 2008.
>
> Has anyone else experienced this? If so, would you please share your
> solution? I am getting extremely frustrated by this...
>
> Thanks!!


 | 
Pages: 1
Prev: Accessing SSRS through SSMS
Next: Style of the first details column messed up (IE8 and FF3)