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

Hidden Values are not calculated in SSRS 2005?!

Hi,
I just created a Report in SSRS 2005 and wanted to use the "old" trick to
display data values in the header (reference body-elements from the header).
I know this worked fine in SSRS 2000, but in SSRS 2005 it seems, that they
have build in some "optimization" which doesn't render/calculate hidden
Fields anymore.
So, when I reference a Field that isn't hidden it works just fine - but as
soon as I hide the referenced field in the body it never gets a value, thus
the textbox in the header stays empty as well.
Initially I referenced Textboxes embedded in a table, but it neither works
for texboxes which are directly contained in the body-region. As soon as an
element is hidden it seems to be ignored by the rendering engine.
Any help would be appreciated.
Thanks,
FlorianA suitable workaround would be to set the font color to the same color as
the background color.
-Tim
"Florian" <Florian@.discussions.microsoft.com> wrote in message
news:AB31608E-EFF9-4D0B-865C-956519A96859@.microsoft.com...
> Hi,
> I just created a Report in SSRS 2005 and wanted to use the "old" trick to
> display data values in the header (reference body-elements from the
> header).
> I know this worked fine in SSRS 2000, but in SSRS 2005 it seems, that they
> have build in some "optimization" which doesn't render/calculate hidden
> Fields anymore.
> So, when I reference a Field that isn't hidden it works just fine - but as
> soon as I hide the referenced field in the body it never gets a value,
> thus
> the textbox in the header stays empty as well.
> Initially I referenced Textboxes embedded in a table, but it neither works
> for texboxes which are directly contained in the body-region. As soon as
> an
> element is hidden it seems to be ignored by the rendering engine.
> Any help would be appreciated.
> Thanks,
> Florian

hi,need help.....

hi all...
i need help in writing a SQL query to display the date and time of the client last visited.

Quote:

Originally Posted by rocpraveen

hi all...
i need help in writing a SQL query to display the date and time of the client last visited.

Hi rocpraveen,

We are more than happy to help you with your query. But the only problem is we are not good at guessing other people's requirements with absolutely no information to go with. I might decide upon my own set of tables and columns and arrive at a suitable query but I guess it would not serve your purpose. So either you have not given enough information or we are just not good enough.

P.S: It's absolutely irritating when someone assumes that others will guess their requirements.|||Can u please post your table structure n what exactly u want to retrive.

And if possible post how u have tried to solve the problem .

It makes it easier for the experts in the forum in understanding your problem better.

Hi

I have a field that I would like to only display the date as mm/dd/yyyy. Current field shows mm/dd/yyyy hh:mm:ss AM.

I would most likely create a view that will create a field that will display the date only.

Answered there: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=619822&SiteID=1