Symptom
Reproducing the Issue
1. Create a simple database table with a field that can accept multilingual data (e.g on SQL Server, use the "ntext" data type).
2. Open the attached Excel file (Hebrew+English data.xls) and copy the sample data to the newly created database table.
3. Create a simple Crystal report that accesses the new table.
4. On the field that contains the data, format the field to read from "Right to Left".
5. The formatting of the field, when previewed in Crystal report designer, is correct (The word "Comission" is the first word if read from left to right).
6. Save the Crystal report.
7. Publish the report to the CMS repository.
8. The formatting of the field, when viewing the report on InfoView using the DHTML viewer, is NOT correct (The word "Comission" is the last word if read from left to right).
- The same is true using the following viewers:
- DHTML Viewer
- Advanced DHTML Viewer
Note: a) The formatting is correct using the following viewers:
- Java Viewer
- ActiveX Viewer
b) Also, if the report is exported to PDF, RTF,Excel - Data Only(XLS) the formatting is correct.
9. To replicate the issue on RAS, simply deploy the "view_report" jsp sample.
IMPORTANT NOTE :
- Please note that this issue is encountered on using the RAS SDK and can be replicated on InfoView.
- Also, this issue has been reproduced on InfoView for BusinessObjects XI R2 with SP2.
- Crystal Report Server XI R2.
Cause
- Using Crystal Report Server XI R2 with SP1/SP2/SP3.
- Using RAS SDK on the machine where Crystal Report Server XI R2 is installed to view the Crystal report which contains the fields with Hebrew and English words mixed.
- On the same Crystal Report Server XI R2 machine, viewing the Crystal report (which contains the fields with Hebrew and English words mixed) in Infoview using DHTML and Advanced DHTML viewer.
Resolution
1. This issue had been tracked under ADAPT00804328 and a fix was released for it.
2. The fix was to install SP4 on Crystal Report Server XI R2 machine.
3. After installing SP4 on Crystal Report Server XI R2 machine, carry out the following steps.
4. Copy the new (updated) jar files after installing SP4 from the location C:\Program Files\Business Objects\common\3.5\java\lib and put it in the lib folder of the RAS application.
5. Then try to execute the RAS application to view the Crystal report which contains the fields with Hebrew and English words mixed.
6. The Crystal report data now displays (in the right order) as per required through the application as well.
Keywords
Hebrew, Order reversed, words mixed up. , KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem
Product
Attachments
Hebrew_English_data.xls |