SAP Knowledge Base Article - Public

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


  • 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


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


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


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


SAP Crystal Reports 10.0 ; SAP Crystal Reports XI