RDLC and Null Values

Question

Is it possible to allow for null values in an .rdlc Expression box?  

The below code works fine with an actual date value.  However, if the value is blank, #Error results on the page as a column value, and a blank space is the goal if a value is blank.

Thanks in advance! 

=IIF(Fields!DateTo.IsMissing Or Fields!DateTo Is Nothing, "", Fields!DateTo.Value.ToString().Substring(4,2)+"/"+Fields!DateTo.Value.ToString().Substring(6,2)+"/"+Fields!DateTo.Value.ToString().Substring(0,4))

---

robert hellestrae

Answer 1

 Hi there

This forum is not for SQL Server related postings. I would recommend to try posting in one of the appropriate categories at http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Apologies for the confusion and thanks for your understanding -:)
Anastasios

Answer 2

Did you ever find an answer to this question?  I am having the same problem and can't seem to find a solution....

Answer 3

It looks like you are hitting this error
http://www.developmentnow.com/g/115_2006_5_0_0_753682/IsMissing-problem.htm

It seems like the solution is to create a function that will allow you to return if the field is null or missing.

Can be solved using custom code like:

Function ToIntOrZero(ByVal field As Field) As Integer
If field is Nothing Or _
field.IsMissing() Then
Return 0
Else
Return 1
End If
End Function

From http://www.developmentnow.com/g/115_2006_5_0_0_753682/IsMissing-problem.ht

I hope it helps.