<div>
You should be able to use the ISNUMERIC function to check if the value is a number -<br />
<br />
= IIF(IsNumeric(Fields!SSN.V<wbr />alue), format(cdec(Fields!SSN.Val<wbr />ue), &quot;###-##-####&quot;), Fields!SSN.Value)<br />

</div>


You should be able to use the ISNUMERIC function to check if the value is a number -

= IIF(IsNumeric(Fields!SSN.Value), format(cdec(Fields!SSN.Value), "###-##-####"), Fields!SSN.Value)


<div>
still has error:<br />
Here is the code:<br />
<br />
=IIF(IsNumeric(Fields!SPOU<wbr />SE_SSN.Val<wbr />ue),format<wbr />(cdec(Fiel<wbr />ds!SPOUSE_<wbr />SSN.Value)<wbr />, &quot;###-##-####&quot;), Fields!SPOUSE_SSN.Value)<br />
<br />
Error show in the field: &nbsp;#Error<br />
<br />
Warning message:<br />
[rsRuntimeErrorInExpressio<wbr />n] The Value expression for the textbox SPOUSE_SSN contains an error: Conversion from string &quot;&quot;&nbsp;to type 'Decimal' is not valid.<br />
Preview complete -- 0 errors, 1 warnings<br />
<br />
<br />
<br />

</div>


still has error:
Here is the code:

=IIF(IsNumeric(Fields!SPOUSE_SSN.Value),format(cdec(Fields!SPOUSE_SSN.Value), "###-##-####"), Fields!SPOUSE_SSN.Value)

Error show in the field:  #Error

Warning message:
[rsRuntimeErrorInExpression] The Value expression for the textbox SPOUSE_SSN contains an error: Conversion from string "" to type 'Decimal' is not valid.
Preview complete -- 0 errors, 1 warnings





<div>
It works. &nbsp;Thank you very much for your help!!!
</div>


It works.  Thank you very much for your help!!!

<div>
<div class="content wysiwyg-content">
Here is the format:<br />
<br />
=format(cdec(Fields!SSN.Va<wbr />lue), &quot;###-##-####&quot;)<br />
<br />
Error if the value is &quot;&nbsp;&quot;. &nbsp;How to check before convert this field value to decimal?
</div>
</div>


Here is the format:

=format(cdec(Fields!SSN.Value), "###-##-####")

Error if the value is " ".  How to check before convert this field value to decimal?

MS SQL Reporting format error

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.