How do I manage fields longer than 255 characters?

[IreneMcBeatle]

Hello,
I need to put fields into my Crystal Reports 8.0 report, that have VARCHAR2 type in Oracle 9i and are longer than 255. When I put such fields into report there isn't any preview. Error message is: "Not supported". What should I do? Please, help me!

 

[synapsevampire]

What type of connectivity are you using?

If ODBC, make sure that you use the CR supplied ODBC driver, not the Oracle or MS version.

If this is still a problem, use a SQL Expression and CAST or CONVERT it to a VARCHAR. Crystal 8.X will display fields longer than 254, you just can't use them in formulas. If you need to use them in formulas, create multiple fields using SQL Expressions.

-k

 

[IreneMcBeatle]

I've tried SQL Expression Editor, but none of the fields I need to convert are avaliable in Field Tree. I tried to type them in, but couldn't cope with syntax. Could you please post a sample line with Convert function?

 

[IreneMcBeatle]

Thank you. The problem was solved. I tried to use ODBC Oracle connection instead of OLE DB. Now data is displayed correctly, all fields are available.