Crsytal and Memo Fields

[Former Member]

I have a column in a SQL table as VARCHAR(MAX)

However, Crystal recognizes the column as Memo field.

Unfortunately, the column in the SQL table is greater than 65536 bytes.

The Crystal report truncates the column.

Is there anyway to overcome this limitation?

Thank you,

Michael

[Former Member]

Have you considered creating an SQL expression field and cast it as varchar and then use it in the report?

[former_member11696]

It may be the field type you have it defined as. Try using a BLOB field type and see if that works for you.

32 bit app's do have a 64K limit for strings.

You also have not mentioned what database driver you are using, it may be a limitation of the driver buffer size also.

Thank you

Don

[Former Member]

I do not think it is possible.

If you go to the Crystal Reports 2008 Online Help and search on 65534, it returns three topics.

The Crystal Syntax topic states:

For reference purposes, here are the sizing limitations of the formula language:

The maximum length of a String constant, a String value held by a String variable, a String value returned by a function or a String element of a String array is 65,534 characters.

[former_member11696]

What version of Crystal are you using?

Later version support more than 65K.

Thank you

Don

[Former Member]

Crystal 2008. The column is treated as MEMO even though the SQL table treats it at varchar(max).

The report is being truncated.

Is there a more recent version than SQL 2008.

Edited by: michaelh99 on Jul 8, 2010 8:41 PM

[Former Member]

I'm on CR XI R2 sp4 and I'm getting the same thing. I created a VarChar(MAX) field a populated with 1,000,000+ characters. CR is only displaying 65,534 of them.

I also tested it as a nVarChar(MAX), Text & nText... All were seen as "Memo" fields by CR and only displayed 65,534 characters.