0

NL Table Function

Jet Reports Historic Posts

March 17, 2011 11:56

None

Follow

Does anyone know if it's possible to add an additional field from another table whilst using the NF Table function. for example:

=NL("Table","Cust. Ledger Entry",{"Customer No.","Document Date","Document No.","Document Type","Amount (LCY)"},"TableName=","Cust. Ledger Entry")

Then adding to this "Name" From the "Customer" Table.

I could then show the Customer name in a Pivot Table Etc…..

Thanks

Chris

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 17, 2011 17:51

  Hi Chris,
  
  Unfortunately, currently it is not possible to add fields from secondary tables to an NL(Table) function. This is functionality that we have considered so it may be available in a future release, but currently it is not.
  
  Regards,
  Hughes