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

• 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 )

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

• 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.

• The issue is fixed in Fix Pack 4.1 for Crystal Reports 2008
• This issues was fixed in Service Pack 3 for Crystal Reports for Visual Studio 2010 
• This issues was fixed in Service Pack 4 for Crystal Reports for Visual Studio 2010  for more complex record selection formula

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

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

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