1584095 - A boolean NOT is added at the beginning of a record selection formula when the report is loaded by the Crystal Reports .NET SDK

SAP Knowledge Base Article - Public

1584095 - A boolean NOT is added at the beginning of a record selection formula when the report is loaded by the Crystal Reports .NET SDK

Symptom

  • Report is being viewed, printed or exported in the Crystal Reports .NET SDK.
  • A Boolean NOT is added at the beginning of the record selection formula.
  • For example
    • Original record selection formula:
      • {Table1.Field1} >= 5
    • Is changed to this:
      • ( NOT {Table1.Field1} >= 5 )

Environment

  • Crystal Reports 2008 FixPack 3.5
  • Web Application developed using the Crystal Reports .Net SDK

Cause

  • The problem is with the first evaluative statement with the ">=" comparison.
  • It appears that record selection formula where the first evaluation is "<=" (less than equal to) or ">=" (greater than equal to), a Boolean 'NOT' gets added in front.
  • The issue has been identified and logged under Problem Report ID ADAPT01541121.
  • Also note: this was once again tracked for more complex record selection formula and resolved.

Resolution

Workaround

  • The problem is with the first evaluation using a >= or <= in the record selection formula.
  • To get around this problem until a fix is released, add true AND at the beginning of the record selection formula.

Original Formula

{Table1.Field1} >= {?StartDate} And {Table1.Field1} < {?EndDate} + 1

 

Formula with Workaround

true AND {Table1.Field1} >= {?StartDate} And {Table1.Field1} < {?EndDate} + 1

Keywords

RecordSelection ReportDocument NET dotnet CRNET , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio