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.

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.

• This issue is resolved by installing Service Pack 2 for Crystal Reports 2008.
• https://www.sdn.sap.com/irj/boc/downloads 
• This is tracked under ADAPT01187176.

KBA , BI , Business intelligence solutions , Problem