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 Business View Manager , Problem
Product
SAP Crystal Reports 10.0 ; SAP Crystal Reports XI