Page 1 of 1

Excel error from prchoice

Posted: Mon Dec 19, 2016 11:37 am
by omni
Roger,

Getting this error, express 263 on 1.9. Just on one report so far, but does not make a lot of sense, other than the column counter is off (it appears)

-> VALTYPE: A VALUE: {"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "INTERNATIONAL FUEL TAX REPORT", "", "", "", "", "", ""}

-> VALTYPE: N VALUE: 27
oError:description : Error in array index
oError:filename :
oError:genCode : 4
oError:operation : <A of 26>[<27>]
CALLSTACK:
Called from DC_ARRAY2EXCEL(5147)
Called from DC_PRINTEROFF(3813)
Called from PRINTOFF(631)

The headers and columns are fairly complex and landscape, but I cannot get it do error on any other report in my testing.



Fred
Omni

Re: Excel error from prchoice

Posted: Mon Dec 19, 2016 2:52 pm
by rdonnay
Are you sure you are using build 263?

Line 5147 of _DCFUNCT.PRG should not cause that kind of error.

Re: Excel error from prchoice

Posted: Mon Dec 19, 2016 3:41 pm
by omni
Yes, I saw that also..it does not make any sense. I have seen error messages with wrong line numbers, but I do not know how to check that issue on that code.
Now we did recompile dclipx for a change you gave us, but it should not have impacted that line number.
That was one line changed on dcprc.prg.

I can try with another version(?). Or retry the compile to see if it may have compiled wrong for some reason.

Fred

Re: Excel error from prchoice

Posted: Mon Dec 19, 2016 4:30 pm
by Auge_Ohr
hi,
The headers and columns are fairly complex and landscape, but I cannot get it do error on any other report in my testing.
can you reproduce that Error ? how does Header Text look like ?

Re: Excel error from prchoice

Posted: Tue Dec 20, 2016 7:03 am
by omni
Roger,

Recompiled and its line 5042. That one makes sense matching with the error...

this report is landscape...I moved the page counter (far right which is 135 column) one row down from the top row and then it worked. Odd...just a trial and error.

Fred