I'm trying to put a text field on my Crystal 8.5 report, but it shows up as gibberish. Is there a way to convert it to readable text? I do not have the Baan native driver for Crystal (wish I did!), just ODBC.

Thanks.

The text field is just a numeric value and represents a key to the table that contains the actual text. The Baan interface to your database puts all this together behind the scenes. The data dictionary for the table you are using should be able to tell you which text table to look at. If the numeric value contains a zero, then it is empty.

Thanks, but the numeric field is not the problem. I've already linked the text field in my main table (tdpur040.txtb) to the text table in order to pull the actual text into my report. It's the field from the text table (tttxt010.text) that I can't read. It looks like hexadecimal or something. I was hoping their might be some way to convert it in Crystal.

For ODBC links with SQL 7 Server as the database I use CONVERT(char(250), ttttxt010100.t_text)

Darren - Is that a Crystal formula? If it is then I must be doing something wrong because it's not recognizing it. If it is something else please tell me!

Cheryl:

I've done exactly what you've described in Crystal 8.5. I have not needed to translate the text string in any way to get it readable. Other than double checking your table linking, I don't know what to recommend - it should work as you described without any conversion necessary. (I've done this in both Baan IVb, and Vc).

Regards,

Marc

Marc - Are you using an ODBC driver with SQL Server or do you have the Baan Native driver for Crystal?

the formula used is transact sql I use it in an sql view and this table view is then imported to access or excel.

Cheryl:

Guess I didn't read your opening post well - I have the Baan Native Driver installed which works great. I haven't tried with ODBC/SQL.

Sorry,

Marc