<div>
Do you need to display the full string even if it is over 64K?<br />
<br />
You can do this<br />
<br />
If Len(x) &lt;&nbsp;64533 then<br />
&nbsp; &nbsp;x := x + {Database.NOTES}<br />
<br />
If you need to display the full string there are ways using arrays of strings.<br />
<br />
mlmcc
</div>


Do you need to display the full string even if it is over 64K?

You can do this

If Len(x) < 64533 then
   x := x + {Database.NOTES}

If you need to display the full string there are ways using arrays of strings.

mlmcc

<div>
I don't need to print if it is over 64. when I use this formula I receive an error: The ) is missing. and it highlights (x)
</div>


I don't need to print if it is over 64. when I use this formula I receive an error: The ) is missing. and it highlights (x)

<div>
Did you add that to your formula as shown below.<br />
<br />
whileprintingrecords;<br />
stringvar x;<br />
If Len(x) &lt;&nbsp;64533 then<br />
&nbsp; &nbsp;x := x + {Database.NOTES}<br />
<br />
mlmcc<br />

</div>


Did you add that to your formula as shown below.

whileprintingrecords;
stringvar x;
If Len(x) < 64533 then
   x := x + {Database.NOTES}

mlmcc


<div>
I left out the ;. I think this formula will work for me. Thank you for your reply.
</div>


I left out the ;. I think this formula will work for me. Thank you for your reply.

<div>
After validating my data how would display the text if it is over 65534? 
</div>


After validating my data how would display the text if it is over 65534?

<div>
<div class="content wysiwyg-content">
I am receiving the following error with this formula in Crystal XI.<br />
<br />
A string can be at most 65534 characters long.<br />
<br />
How do I limit the number of characters returned?<br />
<br />

<pre><code id="code-99089">Here is the formula that the report is bombing out on. 
whileprintingrecords;
stringvar x:=x+{Database.NOTES} 
Type = String and Length is 1000
</code></pre>
</div>
</div>


I am receiving the following error with this formula in Crystal XI.

A string can be at most 65534 characters long.

How do I limit the number of characters returned?


How do I limit the number of characters returned in a variable.

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.