SAP Knowledge Base Article - Public

1273152 - Hebrew and English words get mixed up (order of the words gets reversed) while viewing Crystal report using RAS SDK and also through Infoview

Symptom

Report's field with mixed languages (e.g. Hebrew and English) and set to read from "Right to Left" does not format the text correctly (text appears in the reverse order) when viewed using the RAS SDK or through  InfoView(DHTML and Advanced DHTML viewer).

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

Crystal Reports Server XI R2

Attachments

Hebrew_English_data.xls