I am in major need of some help here and before I go off and write a SP to handle this for me, I though I would ask here for advice first.
I am writing a report to display on our asp.net site using the ReportViewer component and the report editor in VS.
We have a SQL table that contains a DateTime field (two actually) and those fields also accept null values.
The report I am writing in ASP.NET needs to select the data from the table and determine if the DateTime field is null to show certain values on the report.
Some of the solutions I have found involve testing for DateTime.MinValue, but the problem is that some of the dates in the database legitimately have that value. So I can't check against that.
Is there a way, besides me creating a SP on the SQL server to check for NULL values, for me to do this?
Because I am using a report, my options for codebehind are rather limited. I have tried using the IsNothing() and IsDate() on the field, but it simply throws an error saying the report couldn't be processed.