1277328 - Problem with NCHAR when migrating from Crystal Reports (CR) 10 to Crystal Reports XI

SAP Knowledge Base Article - Public

1277328 - Problem with NCHAR when migrating from Crystal Reports (CR) 10 to Crystal Reports XI

Symptom

  • In the report filters, the queries get automatically modified for example: WS.CD_BOX = 'XXX' is changed to WS.CD_BOX =N'XXX'
  • Indexes are not recognised by the database
  • Queries take much longer to be executed

Reproducing the Issue

  • Open report which has been created in CR 10 in CR XI
  • Run report, the query is changed in the report filters

Crystal Reports 10

Crystal Reports XI

Oracle 10

Cause

Although there is no official ADAPT id for this defect, this is a regression in CR XI.

Resolution

  • Install Crystal XI Release 1 OR
  • Install Crystal XI Release 2 Service Pack 4

Note: it is highly recommended to install the latest release of Crystal Reports together with the last Service Pack which contains the latest fixes.

Keywords

CR XI R2 SP4 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 10.0 ; SAP Crystal Reports XI