CODEWITHSUNDEEP
sql-serverreporting-services
nav100
nav100

Reputation: 3133

Reporting services Expression doesn't work

I am trying to check the field(date field) value if it is null or empty. If it is empty or null then do not display anything. If there is a value then display the value of another field. But the following expression doesn't seem to be working. Could you please let me know if there are any suggestions?

=IIF(Trim(Fields!field_date.Value) = "", "", Fields!field_name.Value)

Upvotes: 2

Views: 2198

Answers (2)

gbn
gbn

Reputation: 432180

=IIF(String.IsNullOrEmpty(Fields!field_date.Value), "", Fields!field_name.Value)

Upvotes: 1

Bryan
Bryan

Reputation: 17693

This will check if the field_date value is empty:

=IIF(IsNothing(Trim(Fields!field_date.Value)), "", Fields!field_name.Value)

Upvotes: 1

Related Questions