0

Performance Issues

Jet Reports Historic Posts

September 11, 2009 14:09

None

Follow

Hi there,

thanks for your quick response.
I think now after doing some more tests that it doesn’t depend on the number of sheets I have in the whole workbook how often the data will be queried – it looks more like it depends on the number of NL functions which are accessing the database or something like that.
Well anyway, thanks to your tipps I think I could improve the speed at least a bit.


Thanks for your help & kind regards

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 11, 2009 14:09

  Hi there,
  
  I am quite new to this forum (but also to JetReports & Navision), although I am quite an experienced Excel user.
  I have created a rather small report in Excel dimensions, but apparently a big in Navision dimensions.
  My query takes about 50minutes – but should be at 25mins max.
  
  The problem is the following:
  I have a sheet “options” where I can set some filters and stuff, and I have another sheet with the NL/NF functions / queries.
  And maybe a third sheet that is blank.
  After the JetReport engine has finished calculating the first time, it starts another time for each sheet in the workbook. So if there are 3 sheets – the same calculation takes place 3 times – which is really annoying.
  
  Is there any way to avoid that? The problem is that I want to do more calculations in more sheets with pivot tables, diagrams etc. but I can not wait 25 minutes x (number sheets) in order to get the data.
  Every time I close the workbook and open it again, it wants to update the JetReport data again…
  
  Maybe its just a simple option I have to set or maybe there is another small hint for me to avoid that?
  
  
  Thanks in advance and kind regards

• 0
  
  Jet Reports Historic Posts September 11, 2009 14:32

  Cyrrel,
  
  First, I would make sure that any offsheet references are enclosed in an NP("Eval") function. For example, you say you have an options sheet. And a report sheet. On the report sheet I would bring over the values from the options sheet by using a cell reference.
  
  =Options!$D$6
  and make all of your formulas in the report sheet point to this cell on your report sheet instead of your options sheet.
  
  Also, I would then enclose the new formula in a NP("Eval") formula
  =NP("Eval","=Options!$D$6")Also, any =NOW() or =TODAY() formulas should be in NP("Eval").
  
  Second, I would make sure that there is an Auto+Hide+Values in Cell A1 of your report worksheet.