Limitations

For reference purposes, here are the sizing limitations of the formula language:

• The maximum length of a String constant, a String value held by a String variable, a String value returned by a function or a String element of a String array is 254 bytes.
• The maximum size of an array is 1000 elements.
• The maximum number of arguments to a function is 1000. (This applies to functions that can have an indefinite number of arguments such as Choose).
• The maximum length of the text of a formula is 64K.
• The maximum number of loop condition evaluations per evaluation of a formula is 30,000. (See safety mechanisms for loops for the precise meaning of this).
• Date-time functions modeled on Visual Basic accept dates from year 100 to year 9999. Traditional Seagate Crystal Reports functions accept dates from year 1 to year 9999.