Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Service Packs and Patches

Interview Question :: Crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding

Hai ,

subject: crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding

Software environment :
I am using crystal report 8.5 installed with the following patches:
1. actxviewwin_en- ACTXVIEWWIN_EN_200312.EXE
2. cr85mainwin_en- CR85MAINWIN_EN_200312.EXE
3. dbexdrvrwin_en- DBEXDRVRWIN_EN_200401.EXE

I am using the crystal report for an application with Microsoft Visual Basic 6.0 service pack 6 installed and Microsoft Sql server 2000 service pack 4 installed with the machine having operating system Windows XP Professional Service pack 2 installed.

The SQL Server 2000 Database collation has been set to SQL_Latin1_General_CP1_CI_AS.

problem in three scenatiros explained::

1.When i query from database - sql query analyzer, the data stored in database appears in arabic but when i view the crystal report, the data appears in ?????????? something like this. (database displays correctly and crystal report displays incorrectly on manually opening the report)

2.Similarily, when i entered data in arabic from vb application, the data is stored in some junk format (probably unicode), this data in the crystal report shows the current entered data in arabic correctly. (database displays incorrectly and crystal report displays correctly on manually opening the report)

3. But when i view the crystal report through my VB application, the crystal report for arabic column was garbled or overwritten for the data that was entered in arabic in step 2. while all the previous data in database that shows arabic in database is shown as ??????? in the crystal report.
(database displaying correctly and crystal report displays incorrectly)
(database displays incorrectly and crystal report displays correctly)

I even tried installing with the service pack 3 - cr85win_en_sp3.exe. i also have arabic fonts installed, regional settings and language inputs also available for english UAE and arabic.

Please advise... what i have to do to resolve this error and what is the error thats causing the arabic characters not to be displayed.

Again, If it is Jeff B or hossan ahamed gonna reply me, please provide me a sample report with data in arabic and send me to noor.siraj @ yahoo . com

Answers to "Crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding"

RE: Crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding?
Hi Noor, When I responded to your previous question (the one at http://answers.yahoo.com/question/index?... I provided a reference link to a Crystal Reports Technical Paper. The link to that doc is http://resources.businessobjects.com/sup... . If you look at Page 2 of that document it states: "A new feature in Crystal Reports (CR) version 9 is Unicode compliance. The Unicode Standard defines codes for characters used in all the major languages written today. Scripts include the European alphabetic scripts, Middle Eastern right-to-left scripts, and many scripts of Asia. Unicode provides a unique encoding for characters, no matter what the platform, program or language. Unicode is required by modern standards for XML, Java, ECMA Script (JavaScript), LDAP, CORBA 3.0, WML and so on. Unicode is supported in many operating systems, all modern browsers, and many other products. Unicode enables a single software product or website to be designed to target multiple platforms, languages and countries without re-engineering. It allows data to be transported through many different systems without corruption." I found another Crystal Reports 9 Technical doc that seems to confirm the same thing. The doc can be found at http://www.bbi.ch/bi/Premium/Documents/c... . If you look at page 30 it says: "An important new feature of Crystal Reports 9 is support of Unicode data. With the CR 9 Unicode-compliant database drivers, you can report off Unicode data types. In earlier versions of CR, you can report off standard ASCII characters. Unicode uses two bytes of information to describe each character. Unicode is required to describe characters that are not standard ASCII characters. For example, international characters, such as Greek and Chinese, require Unicode support." If Crystal Reports 9 is indeed the first version of Crystal Reports that support unicode (as stated in the docs) then you will not be able to use Crystal Reports 8.5 to display Arabic data. I realize that you managed to pass some Arabic data from VB6 to CR8.5 and that it appeared to display properly, however you have not been able to query Arabic data from a DB and have it display properly. I suspect it's because unicode isn't fully implemented in Crystal Reports 8.5. I have never worked with unicode data and I cannot provide you with a sample report containing Arabic data. But I did do some internet searches to try and find some help for you. Here's what I found: 1. http://techrepublic.com.com/5208-6230-0.... "In order to display Arabic characters in VB6 you need to... Change the computers locale to Arabic in Control Panel/Regional Options and reboot the computer. That should do the trick. For some languages it is also neccessary to set all controls to use the MS Arial Unicode fontset before all characters will display correctly. Scripted, double and triple byte languages will not correctly display characters in VB6 unless the regional setting is set to the languages locale." 2. http://www.codeguru.com/forum/archive/in... "QUESTION: I'm having problem with a report (CR 8). I have to use it also in different countries that are using particular characters, such as Greece, Russia, Czech Republic. Which font do I have to use? I've tryed with Arial Unicode, but in CR I have always to specify the set (Cyrillic, Central Europe, Greek, etc.) and it is working only in the correspondant country. Is there a solution? ANSWER: stromberg45June 7th, 2005, 06:47 PM i have successfully used unicode strings on a crystal report, (crystal 9). it was my only option after trying hard to get it working on previous version, it just doesn't support unicode before v9." 3. http://www.vbforums.com/showthread.php?t... "QUESTION: Classic VB - Does Visual Basic 6 support Unicode? ANSWER1: Yes and no. For yes, VB strings can hold 16-bit characters and is thus Unicode compatible. The problems come from several directions {REMAINDER OF ANSWER AVAILABLE AT LINK ABOVE} ANSWER2: Let me provide an alternative. You can use Office 2000 activeX controls, otherwise known as the Forms 2.0 (FM20.dll) I use in all the senerios (at least I think I have) that you mentioned. But you say "But I have to purchase Office 2000 in order to use it. My clients will have to purchase Office 2000 to use it." Nope, luckily you and they don't have to. Microsoft provided a legal free version of using the control, but you have to download and install a program to do so... READ HERE -> INFO: Usage and Redistribution of FM20.DLL -> http://support.microsoft.com/default.asp... Download -> MS ActiveX Control Pad -> http://msdn.microsoft.com/en-us/library/... " Why don't you upgrade to CR 2008 and VB.NET? They are supported products unlike CR 8.5 and VB6.
Vote for this answer ::

RE: Crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding?
actually the above discussion did not resolve my problem ... but from Jeff's reply, one could understand the latest features of unicode support available from crystal reports 9 onwards. In the code, instead of CRAXDRT.Report, i solved by using crystal.CrystalReport objects in vb codes. thanks.. Report Abuse
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Service Packs and Patches

Interview Question :: Crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding

Top Tags