Hi,
There is a workaround for this.. May be this will help you to resolve this issue...
Try to find the length of the String and the using Left, Mid and Right string functions you may display the data.
Left({Database_field},255) & Mid({Database_field},256,510) & Mid({Database_field},511,765)......
Please note that In Crystal
Reports (CR), a report is created using the Microsoft Excel Add-In. In
Excel, some cells in a column may have more than 255 characters so CR
should see this column as a memo field. However, when the report is
created in CR, this column appears as a string field.
Crystal
Reports sees this column as a string field because the cell in the
second row of this column has less than 255 characters.
In
Excel, the first row of a column will be the field title in CR. The
second row, where the data begins, determines what the value type of the
field will be. If this second row has 255 characters or less, it will
be a string field in CR. If subsequent rows in this column have more
than 255 characters they will also be considered string fields and
therefore truncated at 255 characters in CR.
A
probable work around for this, in Excel, move a cell with more than
255 characters into the second row of the column. CR will now see this
column as a memo field.
--Praveen G
IP Logged
