0

Index Out of Bounds Error - Jet Express

Jet Reports Historic Posts

July 24, 2014 19:17

None

Follow

Hi!

I'm new to the Jet Express product and have an issue when running large reports which are linked to another table in NAV.

I'm using the following products and versions:

- Jet Express Version: 14.0.14042.0

- Microsoft Dynamics NAV 2013 Version: 7.0.35201.0

The data that I'm working with expands over 334 columns and when I try to refresh the table I receive the following error in the image.

The top of the image displays the "Refresh" portion which includes the error and the bottom portion displays the "Design" phase.

If I reduce the data to 126 columns, running the report is not a problem.

Does anyone know a solution for this issue? Is there a maximum amount of columns allowed?

• JetReport-Error.jpg

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 24, 2014 21:16

  This error usually represents a memory error from my research which would align with the description of the problem.
  The limit is the actual amount of memory available to Excel.
  
  You mention that reducing the number of columns helps, that that is only half the equation.
  If your report ends up with 10,000 rows to go along with your columns, you are looking at 3.34 million cells.
  
  You can go to the Windows Task Manager, and if the Excel memory usage exceeds 1Gb, you may be hitting the limit but is dependent on your version/bitness of your Excel.
  
  Excel can have up to 16,384 columns and Excel should be able to use them all, but your computer may not be able to handle that much data.
  
  Regards,

• 0
  
  Jet Reports Historic Posts July 25, 2014 13:11

  Thanks for the reply JET-btr.
  
  From what I understand, you are able to allocate memory more efficiently with 64 bit versions of software compared to 32 bit version which is what I am running.
  
  Therefore, would you think if I upgrade to 64 bit versions, it may alleviate my issue?

• 0
  
  Jet Reports Historic Posts July 25, 2014 19:05

  Hi Benq
  
  I've moved our conversation back to the Express message board where you can find my most recent response.