Symptom
- Wrong display in Crystal Report after inserting Excel OLE object
- Special characters for e.g '≤' are converted to '?'
Reproducing the Issue
- Create a new Excel Sheet
- Add '≤' in one cell
- Save the Excel sheet
- Launch Crystal Reports
- Create a new report
- From the Menu, click Insert > OLE Object
- Select 'Create from File'
- Browse to the location where the Excel file has been saved
- Click ok
Environment information
- Crystal Reports XI
- Crystal Reports XI Release 2
- Crystal Reports 2008
- Microsoft Excel 2000, 2003
Cause
This issue is related to the OLE interface which is used by Crystal Reports and other applications such as Wordpad to display OLE objects. Crystal Reports only uses the the OLE object container and displays the object as does WordPad and all other applications. According to Product Group, this is not a bug that can be fixed within the Crystal Reports product itself.
Resolution
Workaround:
- Use an alternative way to write the symbols for example '>='
- Check Microsoft website for the latest Microsoft patch : www.microsoft.com
Keywords
CR XI R2 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem