0

Puzzled - not all Sales Invoice Lines are listed.

Jet Reports Historic Posts

September 16, 2014 18:05

None

Follow

Hello Everyone!

Can please someone explain, why I don't get all sales invoice lines listed (for all line types, such as "item", "resource") when I am writing =NL("Rows","Sales Invoice Line","Document No.") ? What I am getting is one unique invoice number per line, even though some invoices have several lines.

It works when I am doing =NL("Rows","Sales Invoice Line") and refer =NF(B6,"Document No.") to that cell.

Just want to understand the principle. I thought it should have worked in the first case too. Thank you!

• Sample-Sales Invoice Line.xlsx

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts September 17, 2014 06:17

  Hi,
  
  NL("Rows","Sales Invoice Line","Document No.") says, that you (only) want to see ALL "Document Numbers" from the table "sales invoice lines"…
  NL("Rows","Sales Invoice Line") and refer =NF(B6,"Document No.") says, that you want to see every sales invoice line AND from every sales invoice line you want to see, what is in field "document no".
  
  so, in the first example you only see a single "document no." once (unique), not more…
  
  
  hope that this is to understand with my englisch Explanation
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts September 17, 2014 13:18

  Thanks a lot for the answer, Jetsetter!
  
  Do you think it is possible to get the same information with only NL functions, or NF is necessary in this case? I wonder if NL functions can ALWAYS do what NF is doing. Thank you.

• 0
  
  Jet Reports Historic Posts September 18, 2014 11:37

  Hi,
  
  NF-Function in combination with the NL-function is nessecary, because you want to get a few fields (more than one field) from one specific dataset/datarecord.
  So the NL-function will get the record(s) with your filters, and the NF-function will get the fields and values you want from this record.
  
  have a look at this => http://kb.jetreports.com/article/AA-00548
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts September 22, 2014 15:43

  Thanks for the answer.
  
  The link you have provided explains the NF function. The guide says that NF is simply "to save time" but not that there are cases where it does something that NL can't. I am confused.

• 0
  
  Jet Reports Historic Posts September 22, 2014 19:57

  Don't be confused ;)
  in the link it says "The NL function works great if you want a single field from a record, but if you want to retrieve more than one field from the same record, retyping all the filters for each field can be tedious."
  
  "The guide says that NF is simply "to save time" but not that there are cases where it does something that NL can't. I am confused."
  
  So it is saving time when designing a report, but also, and that is very important (for me ;) ), one NL-Function in combination with the NF-Function in a row is much better for the performance and run-time of your report, then 2 or more NL-Functions in a row ……( as in your example )
  
  Hope, this helps …
  
  regards
  jetsetter