An array's dimention must be an integer between 1 and 1000 RRS feed

  • Question

  • User970540014 posted

    I have the following array routine within my crystal reports formula field:

    dim aryInfo() as string
    dim aryField() as string
    dim sField as string
    dim n as number
    dim iPos as number 
    aryinfo = split({Command.Info},">")
    formula = ""
    for n = 1 to count(aryinfo)
        sfield = aryinfo(n)
        iPos =  instr(sfield,"</LastName") 
        if iPos > 0 then
            formula = left(sfield,ipos-1)
        end if
        iPos = instr(sfield,"</FirstName")
        if iPos > 0 then
            formula = LEFT(sfield,ipos-1) & " " &  formula
            exit for
        end if

    When I run the crystal report, I got erro message "An array's dimention must be an integer between 1 and 1000.

    The error is pointing to

    aryinfo = split({Command.Info},">")

    It is my first time using this method within my formula field.  Not certain how to go about fixing this error.

    Please help!

    Wednesday, February 26, 2014 4:41 PM


  • User-510141866 posted

    If we use variable in formula field with string type,

    the variable's valuse must be less than 1000 characters.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, February 27, 2014 2:35 AM