Search code examples
conditional-statementsssrs-2008reportbuilder3.0

SSRS Show line only if data is present

I am putting a persons name, their organization, and address block on a report. Sometimes the Applicant_Organization is NULL. When this happens I want to omit that line. With the code I have, an empty line shows below Applicant Name when there is no value for Applicant_Organization value. How can this be worked around?

=UCase(First(Fields!Applicant_Name.Value, "DataSet1") & Chr(10) & Chr(13) & 
 First(Fields!Applicant_Organization.Value, "DataSet1") & Chr(10) & Chr(13) & 
 First(Fields!Applicant_Address_Block.Value, "DataSet1"))

Thank you for your help.

Solution

  • You can use IsNothing() function :

    For Example :

    =UCase(First(Fields!Applicant_Name.Value, "DataSet1") & Chr(10) & Chr(13) & 
 IIF(IsNothing(First(Fields!Applicant_Organization.Value, "DataSet1")), "", First(Fields!Applicant_Organization.Value, "DataSet1") & Chr(10) & Chr(13)) & 
 First(Fields!Applicant_Address_Block.Value, "DataSet1"))