suppress the display of a txt box when null

I have a text box in a list, which i only want to display if it is not null.
How can i do this in reporting services.

thx
la

[141 byte] By [lanton] at [2007-12-16]

# 1

You must put in the value the expression:

= IIF(CSTR(Fields!EvaluatedField)="", "", "The Title")
I hope it helps you

VectorR3 at 2007-9-8 >

# 2

Thank you

Is there a way to stop the entire line from displaying on the report if the field is null

thx

lanton at 2007-9-8 >

# 3

Select the list item where your data objects are places, go to the properties and write for example No Data in the NoRows properties. That's all

VectorR3 at 2007-9-8 >

# 4

Yes, you can conditionally set the visibility on both the row and / or group based on the value.

BrianWelcker at 2007-9-8 >

SQL Server Hot Topic