Dear all,
is there any limitation in number of column in jet report express. I encountered error below :
Jet Express for Dynamics NAV
—————————
Invoking the web service failed with the following message:
Index out of bounds.
This happened when i change the formulas from :
=NL("Table";"Item";$D$24:$AA$24;"Headers=";$D$23:$BB$23;"TableName=";"Item";"IncludeDuplicates=";"True";"Filters=";Option!$C$5:$D$5;"Filters=";Option!$C$6:$D$6;"InclusiveLink=";D22;"InclusiveLink=";E22)
to
=NL("Table";"Item";$D$24:$AB$24;"Headers=";$D$23:$BB$23;"TableName=";"Item";"IncludeDuplicates=";"True";"Filters=";Option!$C$5:$D$5;"Filters=";Option!$C$6:$D$6;"InclusiveLink=";D22;"InclusiveLink=";E22)
Date
Votes
1 comment
-
Jet Reports Historic Posts This error usually represents a memory error.
There is not a built in limit in Jet.
The limit is the actual amount of memory available to Excel.
To test this, you could add the extra column(s), but limit the rows to see if it reports within the amount of memory.
You can also wanted the Windows Task Manager, and if the Excel memory usage exceeds 1Gb, you may be hitting the limit.
As an aside: I do see your number of columns for the table, does not match the number of columns for the headers, and you have two filters= entries.
Regards,
Please sign in to leave a comment.