0

Similar reports, doubled running time

Jet Reports Historic Posts

February 25, 2016 14:53

None

Follow

Hello,

In NAV I have a table (”Production Order”) that was customized by adding various fields.
These days, all the customized fields have been replicated to another table (”Item”).

I modified my reports by just replacing the source-table (from ”Production Order” to ”Item”). The running time is now doubled for all my reports, although the two tables have the same no. of lines.
I'm guessing this is because the two tables might have different keys (I haven't checked yet).
Do you have any thoughts why this would happen? Is there anything that I could improve?

Thank you!
Elena

• Facebook
• Twitter
• LinkedIn

8 comments

• 0
  
  Jet Reports Historic Posts February 25, 2016 15:35

  Can you post a before and after example of your NL functions?

• 0
  
  Jet Reports Historic Posts February 26, 2016 06:33

  Before
  =NL("Rows",IF(B34>=0,"Production Order",{""}),,"Initial Unit Price Date",C34,"IO Status","<>Canceled","Direct Customer No.",NL("Filter","Customer","No.","Customer Type","existent"))
  
  After
  =NL("Rows",IF(B34>=0,"Item",{""}),,"Initial Unit Price Date",C34,"IO Status","<>Canceled","Direct Customer No.",NL("Filter","Customer","No.","Customer Type","existent"))
  
  I just replaced the source table…
  
  Elena

• 0
  
  Jet Reports Historic Posts February 26, 2016 14:21

  Obviously, you could be running your business in a way with which I'm unfamiliar, but I've never seen anyone tie a customer directly to an Item. Could it be your NL("Filter") causing the issue?

• 0
  
  Jet Reports Historic Posts February 26, 2016 14:45

  As I said, the tables have been customized. These are not standard NAV fields.
  The logic and the working logic is the same with ”Production Order” and the ”Item”. This is why the Jet Reports formulas have not been changed (except the source table).
  The results are correct.
  
  Just the running tine of the report is doubled.
  
  Elena

• 0
  
  Jet Reports Historic Posts February 26, 2016 15:01

  Yes, I read that, and yet I couldn't make those assumptions based on your initial posting. That's why I asked the specific question. I didn't assume you weren't sharp, only that I was ignorant.
  
  Assuming there aren't any other functions in the report (summing functions that could be impacted by different data in the different tables), I'd try to isolate each filter to see if it points you in a direction. Either remove the filter or add more filter options to see if you notice a big difference in speed. It's methodical, but you've only got so many options and your problem has to be in one of them.

• 0
  
  Jet Reports Historic Posts February 29, 2016 07:07

  Well, the report is very complex. It does have many other formulas (sums, multiple sheets and others). But the new formulas use the same fields as the previous report.
  
  I was just curious to understand what could be the reasons for the doubled running time.
  At this point I don't have the resources to optimize the reports with the new source-table.
  
  Thanks,
  Elena

• 0
  
  Jet Reports Historic Posts March 08, 2016 07:20

  Hi!
  
  No other hint?
  
  Thanks!
  Elena

• 0
  
  Jet Reports Historic Posts March 08, 2016 07:38

  I would take a look at the keys. It would seem to be where the main difference could be between the two tables.