Field Length: Crystal seems to truncate my varchar fields from SQL

[BakedSkinny]

Crystal 7.0 only displays 255 characters of my varchar field from SQL. I can store up to 8000 characters in my varchar field, but can't display...would use a text data type, but Crystal won't allow me to use text in a formula.

Is there a setting or option that I'm missing??

Thanks,
Bryan

 

[synapsevampire]

Crystal won't let you use an Oracle field over 255 in a formula either.

It sounds like the field has been truncated to 255 chars, I do this with long fields in Stored Procedures and Views to allow for reading them (use multiple fields).

So the answer is that you need to do this on the server side, create a view or a stored procedure to allow for these looooong datatypes.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Check out the Long String fields post in the Fromulas section, it covers this.

I learned myself how to truncate these from within Crystal, though I do so on the database, but it's good to know.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[netcashin]

synapsevampire

Could you provide me what post you were speaking of in the Crystal Formulas section, I haven't been able to find it.

thanks

 

[BlurredVision]

Here ya go!

http://www.tek-tips.com/faqs.cfm?spid=149&sfid=276&CFID=64211363&CFTOKEN=35719684

Brian

http://www.crystalinfo.net

 

[BakedSkinny]

I was able to use a memo field overlayed on a string field, using a formula to format I suppressed the string field when my memo field wasn't blank.

I tried all different variations, don't think crystal can display over 255 characters in any field other than a Memo field.


Thanks for your suggestions.

 

[synapsevampire]

Not sure about a memo field, you can use the SQL Epression to parse long varchars, so it probably works for a memo too.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com