Large varchar field availability

[JDMiller]

I have a varchar 2000 character field. I can display it on the report but I cannot use it in a selection or a formula. The record field does not display in the available fields lists for a selection or a formula.

We have Crystal 8.5. The field is in a SQL database.

 

[dgillz]

It just doesn't appear in the formula editor tree. Manually key the field name into the formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[JDMiller]

Manually typing the field name in a formula or selection criteria produces an error message in Crystal.

 

[lbass]

There is a character limit in 8.5, so try using a set of SQL expressions, like this:

[substring1:]
substr(table.`string`,1,254)

[substring2:]
substr(table.`string`,255,254)

...where the second argument is the starting position, and the third argument is the length.

If the above syntax doesn't work, try:

{fn substring(table.`string`,1,254)}

...since the syntax depends upon your datasource.

Then drop the SQL expressions into a text box to combine them. Note that the field will not be in the field list, so you will need to type it in. If you are unsure of the punctuation, add another field temporarily to the SQL expression and observe the punctuation.

-LB