- 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
- Crystal Reports XI
- Crystal Reports XI Release 2
- Crystal Reports 2008
- Microsoft Excel 2000, 2003
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.
- Use an alternative way to write the symbols for example '>='
- Check Microsoft website for the latest Microsoft patch : www.microsoft.com
CR XI R2 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem