SSRS 2008 R2 Remove White Space if Null

Question

I have a simple SQL Server 2008 R2 report with a textbox containing a few fields. I want to suppress the line if the value of a field is null. What would be the syntax for the expression?

So my fields are...

Name
AddressLine1
AddressLine2
AddressLine3
CityStateZip

and I have expressions like this...

=First(Fields!AddressLine2.Value, "dsPersonData")

I was trying the expression below but getting errors

=IIF(Fields!AddressLine2.Value, "",True,False)

In other words I was trying to set the visibility to false if the value was an empty string but I'm not sure what the syntax would be.

score 1 · Answer 1 · edited Nov 21 '11 at 12:59

1

you can try

=IIF(First(Fields!AddressLine2.Value, "dsPersonData") is Nothing ,False,True)

edited Nov 21 '11 at 12:59

Mr.Wizard

24,179
5
44
125

answered Nov 21 '11 at 12:52

Opabid

11
1

score 0 · Accepted Answer · answered Jun 20 '11 at 20:55

0

Is easy to do this in the sql query, For example:

in SQL Server:

ISNULL(Name, '') as Name
ISNULL(AdressLine1, '') as AdressLine1
ISNULL(AdressLine2, '') as AdressLine2
ISNULL(AdressLine3, '') as AdressLine3
ISNULL(CityStateZip, '') as CityStateZip

and if you want to set the visibility to false:
=IIF(First(Fields!AddressLine2.Value, "dsPersonData") = "",False,True)

answered Jun 20 '11 at 20:55

Marco Hurtado

534
3
13

Thanks, I think I can use this to get my result. – 2boolORNOT2bool Jun 21 '11 at 15:18

SSRS 2008 R2 Remove White Space if Null

2 Answers2