0

NL(rows) and NL(columns) TOO SLOW

Jet Reports Historic Posts

October 28, 2013 12:33

None

Follow

I have NL(rows) replicator for GL accounts and NL(columns) for one of the global dimensions.
The report can return up to hundred columns and it takes 20 min to run such a report.
Any suggestions how to improve the speed?

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts October 28, 2013 13:21

  Hi Andrjam,
  
  I can not test your report as I don't have data in these tables, sorry.
  What I would try is add a NP("EVAL") to every reference to values in the options-sheet.
  
  Also try to limit off-sheet reference as much as possible. Create a header on the P&L sheet retreiving the data from the options-sheet once using the NP("EVAL"). Refer to these header from all other formulas.
  
  Kind regards,
  Gerard

• 0
  
  Jet Reports Historic Posts October 28, 2013 16:44

  Hi,
  
  What exact version of Jet and NAV are you using?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 28, 2013 16:55

  Nav 2009
  
  Jet Essentials 2012 (12.0.12187.0)

• 0
  
  Jet Reports Historic Posts October 28, 2013 18:14

  Replacing offsheet references with NP("Eval") cut the report running time from 20 to 19 minutes.
  Any other suggestions?
  
  Thanks

• 0
  
  Jet Reports Historic Posts October 28, 2013 21:25

  I've noticed that if I Use NL("SUM","G/L Entry"…..) Instead of G/L Balance function, it increases the speed of report running significantly.
  I'm down from 20 to 13 min.
  
  Any advice to improve that is welcome