Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is there a character limit for a field in CrystalReports?

Is there a character limit for a field in CrystalReports?

Hello,

I'm trying to display a long text (+100.000 characters) stored in a MySql database in CrystalReports but CR is not showing the complete text. Is this because there is a length limit for fields in CR?

Thanks,

Eddy G.

Former Member
replied

hi EddyGr,

what are you trying to use the workaround for?

if you're trying to just get the length of the field, then you can try to use a sql expression field on the blob...here's some transact sql that may work with your database...

{fn LENGTH(`yourtable`.`yourblobfield`)}

i say "may" because sql expressions are database dependent so you have to find the correct syntax for your database.

when you create the sql expression, please note that you will not see the name of your blob field in the sql expression editor...just type it in manually.

jw

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question