SAP Knowledge Base Article - Public

1669367 - Error: 'Record Selection: {Database Field: <null>}', when refreshing a report in Crystal Reports that uses a SQL Expression Fields

Symptom

  • Error: '{Database Field: <null>}'
  • When refreshing a report in Crystal Reports that use Perform Grouping on Server, and having a group based an SQL Expression fields, it fails with the error:
          
    Error: 'Record Selection: {Database Field: <null>}'

Environment

  • SAP Crystal Reports 2008

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Create a SQL Expression Fields.
  3. Create a group using the SQL Expression Fields.
  4. Insert a numeric database field in the Details section of the report.
  5. Insert  a summary "Sum" for the database field inserted in the details section
  6. Suppress or Hide the Details section.
  7. Create a Record Selection using a database fields that is not in the report design yet.
  8. Select the Report Options: Perform Grouping on Server.
  9. When refreshing the report the “Formula Workshop – Record Selection Formula” will open and it is written in the upper left corner:
      
    'Error: Record Selection: {Database Field: <null>'

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01367773

Resolution

  • This issue is resolved in the following product update:
        
    • Crystal Reports 2008:
      • Service Pack 4, and above
         
    • Crystal Reports for Visual Studio 2010
      • Service Pack 2

Keywords

Perform grouping on server, Record Selection: {Database Field: <null>}, Record selection in crystal. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-DEV-NET-SDK , .NET SDK / COM SDK , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1