Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Improving Report Performance


In order to speed up the run-time of your reports, follow these guidelines.

  • Apply filters in Jet Reports that match a key that is already in your Navision Database . Also, when applying sorts in lists, use a sort order that matches a Navision key.
  • When returning detail about a record (i.e. Customer Name, No., and Address) if possible, use NL functions to retrieve record keys rather than unique values.  Then use the NF function to obtain field values from those record keys, because an NF function does not have to make a request to the database, while an NL(First) function does.
  • To retrieve a single piece of data that is in a row or column that already contains a replicator (i.e. the name of a customer), use an NL("First") as the "What" parameter.  Generally we do not recommend multiple replicators on the same line unless the goal is to create a grouping report.

  • Avoid making frequent off sheet cell references. If you find yourself doing this, bring the values over to the current sheet using NP ("Eval") and refer your Jet formulas to the copied values instead.

  • Avoid using conditional hides to eliminate large amounts of data in a spreadsheet . In many cases, using an appropriate filter from another table will eliminate the data you do not want to see.

  • Avoid using the NL function for "Rows" or "Columns" to create a summary list against a large table (ex. a list of customers who had transactions in 2010) because Jet Reports must examine every record to find the unique values. If there is a table that holds unique values of the field you are interested in, it is sometimes better to use that table. If necessary, you can conditionally hide rows and columns you do not want, or integrate a Link= or NL(Filter) parameter to filter on data in the transaction table.

  • Avoid using volatile Excel function like NOW() and TODAY(). If you do use them, make sure they are "wrapped" inside an NP("Eval") function, i.e. =NP("Eval","=NOW()"). This will avoid constant recalculation.

  • Avoid inserting manual page breaks into your reports.

  • Avoid using Excel "Grouping" (also known as "Outline") functionality.

  • Eliminate any Named Ranges with errors.  Use Excel's "Name Manager" feature ( Formulas > Name Manager or CTRL-F3 ) to review Named Ranges in your report.  Eliminate or correct any Named Ranges with values of #REF!.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments