SAP Knowledge Base Article - Public

1297059 - Crystal Reports 2008 does not return NULL to Report.RecordSelectionFormula in Visual Studio .NET


  • A Record Selection Formula used the NOT IsNull function in the report.
  • A Visual Studio .NET application returns the Selection formula without the 'NOT'
  • The report displays all fields that are null rather than all fields with values.

Reproducing the Issue

1. Create a report in Crystal Reports 2008 using a Record Selection Formula with NOT IsNull.

 Not IsNull({Customer.Address2})

2. Run the report in the designer

3. All {Customer.Address2} fields have a value

4. The report runs correctly from Visual Studio .NET 2005

5. In the application, add the line:

6. MessageBox.Show (myReportDocument.RecordSelectionFormula)

7. This will return

 ( ( IsNull({Customer.Address2}) ) )

8. Using the formula returned to myReportDocument.RecordSelectionFormula will incorrectly return the address fields with NULL values.




KBA , BI , Business intelligence solutions , Problem


Crystal Reports 2008 V1