SQL -255 E

[ReportGuy]

Software: CR9
Database: Informix
Driver CR Informix 9

I'm using the Remedy database (version 4.5), and in order to get around a blob field issue, we broke a memo field into 5 text fields. When I try to "CONCAT" the fields together using a SQL Expression, I receive the following error"

Error Message
Resulting String length must be less than or equal to 255

SQL Expression
{fn CONCAT( hpd_helpdesk.description_part1 , hpd_helpdesk.description_part2 )}

I am able to CONCAT the 5 Description fields in a Formula, but I'm trying to improve the performance of this report.

Any Suggestions??

 

[synapsevampire]

What version of Crystal?

If you want to concat them for use in the report, drop them in a text object (Insert->Text Object).

-k

 

[ReportGuy]

I'm running Crystal Reports 9.

I have 5 description fields that I need to string together. From a performance stand point, I thought using a SQL Expression would be best. I
have two work arounds:

1. Build a formula, and CONCAT the 5 fields together.
2. Drop the fields into a text object.

Both of these work, and I get the data that I want. However, I'm trying to improve the performance of this report. It is my understanding that
the best way to improve performance, is to add SQL Expressions.