Empty or Null value display in SSRS text boxes

reporting-servicesssrs-2008

Using SSRS (2008) what is the best way you have found to handle null or empty values and replace them with something else to display. The quite obvious solutions is

=IIF(IsNothing(Fields!MyField.Value),"NA",Fields!MyFields.Value)

That works though it is tedious, my hope was to find something like an EmptyText property on the textbox but alas nothing. Any ideas? Should I make a custom report item from the TextBox base that creates this property?

Best Answer

=IIF(ISNOTHING(CStr(Fields!MyFields.Value)) or CStr(Fields!MyFields.Value) = "","-",CStr(Fields!MyFields.Value))

Use this expression you may get the answer.

Here CStr is an default function for handling String datatypes.

Related Solutions

Sql – SSRS can’t conditionally filter “nil” values from XML Data Source

I didn't have a problem using:

 =Iif(cstr(First(Fields!RegInceptionDate.Value, "spimRptPerfSummary")) = "", "-", First(Fields!RegInceptionDate.Value, "spimRptPerfSummary"))

This is what my dataset looks like:

<Query>
   <Method Namespace="http://www.abc.com/" Name="TWRPerformanceSummary"/>
   <SoapAction>http://www.abc.com/TWRPerformanceSummary </SoapAction>   
   <ElementPath IgnoreNamespaces="true">
        TWRPerformanceSummaryResponse/TWRPerformanceSummaryResult/diffgram/NewDataSet/table{PkRegistration, InceptionDate(date),RegInceptionDate(string)}
   </ElementPath>
</Query>

My expression was in a textbox, thats why I have it wrapped in a First() on the DataSet. I cast the RegInceptionDate on the dataset as string (its really a date, but since its coming back null it didn't matter). I'm not sure the cstr() in the expression is necessary since I have the cast on the dataset itself.

Best Answer

Related Solutions

Sql – SSRS can’t conditionally filter “nil” values from XML Data Source

Related Topic