0

Background on the JetReport Functions

Jet Reports Historic Posts

January 11, 2008 17:05

None

Follow

As a new user, I am just wondering if you can tell me what the "NL" in the NL function stands for? NP? NF? (I assume GL is general ledger)

Is there a quick and dirty summary of when it is best to use each function and to optimize the report structure (processing time etc.)

Thanks.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 11, 2008 21:21

  NL() = Link. This is where you make the "Link" to the database record. NF() = Field. You get the "field" from the record. NP() = polymath (or utility), Jet Reports orginally wanted to use NU(), however, this translated in Dutch to the Excel Now() function, so it was changed to NP(). This is for all non-database related functions. GL() = General Ledger. Link to General Ledger only.

  
  Triva: Did you know Jet Reports was orginally called GL Link and the GL() was written long before the NL, NF, and NP functions.
  
  As to optimization of reports, I would start with this article here on the support site (registration required).
  http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=72&nav=0,2,9,18
• 0
  
  Jet Reports Historic Posts January 11, 2008 21:22

  PS:
  
  Don't forget to post a little about yourself in the "introductions" section of the community site.

• 0
  
  Jet Reports Historic Posts December 17, 2009 11:57

  hey
  
  I was watching a Jet repor Video and since am new want to find out whether it is a must have two excel worksheets to use when designing Jet reports? Please help me
  
  Victor