 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
meo giaquat
Guest
|
 Posted: Mon Apr 09, 2007 3:19 pm Post subject: Crystal Report XI does not support Unicode parameters? |
 |
|
Hello,
In my Delphi 7 project I have the code: CRPrintEngine.ParamFields[0].CurrentValue := MyUnicodeStr;
But in the report the result is just ???????
Any help is very appreciated.
meo |
|
| Back to top |
|
 |
meo giaquat
Guest
|
| Posted: Tue Apr 10, 2007 8:13 am Post subject: Re: Crystal Report XI does not support Unicode parameters? |
|
|
Hello,
I have just search the word "widestring" in all the source files of CR VCL XI and the result is so surprise that only few widestrings are found but all of the rest is "string".
It is so ashamed for BussinessObject that they lied us that CR supports Unicode from version 9.0.
This is not the first time I have problem with Unicode in CR. CR does not recognize Unicode data of User Defined Function that made in Delphi then compiled into DLL file.
meo |
|
| Back to top |
|
|
Troy Wolbrink
Guest
|
| Posted: Wed Apr 11, 2007 3:58 pm Post subject: Re: Crystal Report XI does not support Unicode parameters? |
|
|
If you really need Unicode, I'd suggest scrapping the use of the CR XI VCL
components, and use the CR XI RDC ActiveX components (or the .NET
components). I have a Delphi application that uses the RDC ActiveX control,
and it works quite well w/ Unicode. The other thing I found w/ Crystal is
that for reading Unicode from my SQL Server database, I have to use
Crystal's OLEDB database connectivity, and not their SQL Server database
connectivity.
--Troy |
|
| Back to top |
|
|
meo giaquat
Guest
|
| Posted: Thu Apr 12, 2007 8:13 am Post subject: Re: Crystal Report XI does not support Unicode parameters? |
|
|
"Troy Wolbrink" <troy.wolbrink (AT) ccci (DOT) org> wrote:
| Quote: | If you really need Unicode, I'd suggest scrapping the use of the CR XI VCL
components, and use the CR XI RDC ActiveX components (or the .NET
components). I have a Delphi application that uses the RDC ActiveX control,
and it works quite well w/ Unicode. The other thing I found w/ Crystal is
that for reading Unicode from my SQL Server database, I have to use
Crystal's OLEDB database connectivity, and not their SQL Server database
connectivity.
--Troy
|
Thank you so much Troy. I didn't know that there is another method to connect with CR in Delphi. All of our reports are using CR VCL. If I change to RDC ActiveX control, do I have to change the report unit structure (I means the way to pass the dataset to CR Engine)? Now I create the CR VCL component at runtime and pass the dataset to the CR dataset.
In general, CR works well with Unicode data. I just found the problem when I want to put some more info to my report such as report title, user name, ect. I intent to put these data into a temp table and pass it to CR. Not a nice solution at all.
May be I will try to use the RDC ActiveX control. I don't want to move on to .NET now. I bought Delphi 8 just for getting the Delphi 7. I also use your former TntUnicode Controls.
Thank you
meo |
|
| Back to top |
|
|
Troy Wolbrink
Guest
|
| Posted: Fri Apr 13, 2007 2:30 am Post subject: Re: Crystal Report XI does not support Unicode parameters? |
|
|
| Quote: | In general, CR works well with Unicode data. I just found the problem when
I want to put some more info to my report such as report title, user name,
ect. I intent to put these data into a temp table and pass it to CR. Not a
nice solution at all.
|
I don't pass in entire TDataSets or anything. What I did was used Delphi to
create custom User Defined Functions (CR UDF) that are specific to my
application that I refer to from the report. It's been a long time since I
written this, but it does support Unicode.
--Troy |
|
| Back to top |
|
|
meo giaquat
Guest
|
| Posted: Fri Apr 13, 2007 8:13 pm Post subject: Re: Crystal Report XI does not support Unicode parameters? |
|
|
"Troy Wolbrink" <troy.wolbrink (AT) ccci (DOT) org> wrote:
| Quote: | I don't pass in entire TDataSets or anything. What I did was used Delphi to
create custom User Defined Functions (CR UDF) that are specific to my
application that I refer to from the report. It's been a long time since I
written this, but it does support Unicode.
--Troy
|
Hosnestly I cannot imagine how CR get the data from dataset by CR UDF. I will learn about it. But I also got a Unicode problem with CR UDF. I need to convert number to Lao words in my report. So I use Delphi 7 to create a function to do this work and the return value of the function is widestring. I followed the instruction in the Crystal Reports Developer's Help and I had a dll file. I registered the dll file and the dll works well in my Delphi project. But when I use the function in CR, it always returns ?????? string.
Kind regards
meo |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
