Hi guys,
I try to put Text field from ttttxt010 into Crystal 7 report. But the field contains numbers and letters (binary). Does anyone know how to show this field in the report as not binary?
Thanks.

just curious, did you ever solve this, and get the text to show properly in your crystal reports?

Did you manage to put the text field to Crystal Report? If yes, can you tell me how?

Thank you.

Regards,
Danny Kat

Danny,
Yes, I did manage to get the text to show on my crystal reports. It is a workaround, and not very elegant, but the only thing I could think of at the time. I created a second custom copy of the std "text" table in Baan, with the same index, but with text field as type String instead of binary. I then created a script to convert the original binary text into a string and store this in my custom table. This script runs on a frequent schedule to keep my custom table updated. The crystal reports read the converted "string" text from my custom table, not the std baan binary text.

Hi,

thanks for your idea.

Have you any idea on the Baan Native driver?

Regards,
Danny Kat

I just created View for the text table using following SQL and use the new View in all Crystal reports.

SELECT t_ctxt, t_clan, t_seqe, t_text, CONVERT(char(250), t_text)
AS EXPR1
FROM dbo.ttttxt010200

EXPR1 has the text inside. Don't forget to present Views in Crystal along with Tables.

All the versions I have seen of the Crystal native driver Baan deal fine with Baan Text fields.