sql server reporting services: Table row visibility property -- sql server reporting services

Table row visibility property

Anonymous
3/29/2007 11:18:04 AM

sql server reporting services:

I have a row in which I am trying to hide if there is no data. However, I
can't seem to get it to work. The value returned in the stored proc is
null. I have tried the following:

=IIf(First(Fields!Judge.Value Is Nothing, "dsAttorney"), True, False)

=IIf(First(Fields!Judge.Value = 0, "dsAttorney"), True, False)

=IIf(First(Fields!Judge.Value = "NULL", "dsAttorney"), True, False)

RE: Table row visibility property

Anonymous
3/29/2007 11:58:06 AM

Got it. Since the table is associated with a dataset there is no need to
include the dataset name with the field.

I had fields on the report that were not in a table and these fields require
the field name + the name of the dataset so I just assumed that all of the
expressions on the report required the same which is does not.

=IIf(Fields!Judge.Value Is Nothing, True, False)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.