0

Sorting multiple NL(Rows) functions as a single list

Jet Reports Historic Posts

May 28, 2009 16:39

None

Follow

Hi,

Looking for assistance with this report.

I have 4 continguous nl(Rows) functions coming from 4 different tables. Now I am trying to sort them together as one list in order by Ship-to code. Any ideas on how to do?

Thanks,

lauryn

• Master Material List.xls

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts June 02, 2009 10:31

  Use the NP Union to create a unique list with the Ship-to Codes and on second level the 4 NL Rows:
  
  C3 = NL("Rows=5";NP("Union";NL("AllUnique";"Purchase Header";"Ship-to Name");NL("AllUnique";"Purch. Inv. Header";"Ship-to Name");NL("AllUnique";"Sales Header";"Ship-to Name");NL("AllUnique";"Sales Invoice Header";"Ship-to Name")))
  C4 = C3
  This creates rows with unique Ship-to Names. Next thing to do is:
  
  D4 = NL("Rows";"Purchase Line";;"Link=";"Purchase Header";"Document No.";"=No.";"Ship-to Name";C4)
  D5 = Second formula
  D6 = Third formula
  D7 = Fourth formula
  
  This creates your report where the 4 types of documents are grouped-by and sorted on Ship-to Name.
  Ofcourse C3 needs allot more filters…