<div>
You're limited in string length by the version of Crystal. &nbsp;What you can do is to have more than one formula - the first returns 254 characters, the next returns 254 more, etc. &nbsp;Position as many as necessary to get the full results.
</div>


You're limited in string length by the version of Crystal.  What you can do is to have more than one formula - the first returns 254 characters, the next returns 254 more, etc.  Position as many as necessary to get the full results.

<div>
or you could upgrade. i think from cr 9 on you can use 64,000 chars.
</div>


or you could upgrade. i think from cr 9 on you can use 64,000 chars.

<div>
Yes CR9 can handle longer strings. &nbsp;The formula frodoman is using must be either in the database or an external dll. &nbsp;Crystal 8.5 cannot use a string that is longer than 254 in a formula.<br />
<br />
mlmcc
</div>


Yes CR9 can handle longer strings.  The formula frodoman is using must be either in the database or an external dll.  Crystal 8.5 cannot use a string that is longer than 254 in a formula.

mlmcc

<div>
<div class="content wysiwyg-content">
I'm using 8.5.<br />
The report is using a formula to format a string that exceeds 254 characters and therefore truncates. How do I get the formula to return more than 254 and get it display on the report?<br />
Thanks
</div>
</div>


I'm using 8.5.
The report is using a formula to format a string that exceeds 254 characters and therefore truncates. How do I get the formula to return more than 254 and get it display on the report?
Thanks

Crystal Reports - Problem with Max String Length in formula

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.