Hello,

I am relatively new to Crystal Reports w/ .NET. I have a database table in SQL Server 2000 that has a few Nulls in the "Date" field. Is there a way to skip over the <nulls> when I'm running a count? For now the report doesn't even load in the CrystalReportViewer because of these nulls. Here is my code so far:

VB Code:
  1. Dim objDate_AccountRep As CrystalDecisions.CrystalReports.Engine.ReportDocument

  2.         objDate_AccountRep = New crDate_AccountRep()

  3.         objDate_AccountRep.DataDefinition.RecordSelectionFormula = "CDate({TD2.Date}) >=#" & strStartDate & "# and CDate({TD2.Date}) <=#" & strEndDate & "#"

  4.         ReportViewerDate_AccountRep.ReportSource = objDate_AccountRep

  5.         ReportViewerDate_AccountRep.RefreshReport()

Is the below code the correct way to exclude a null in my report?

VB Code:
  1. If (isNull({TD2.Date})) Then

  2.         {TD2.Date} & " "

  3.         End if

Thanks!

Chris