0

Create a report

Jet Reports Historic Posts

February 28, 2012 12:56

None

Follow

Hello Guys,

I am new to Jet Reports,I came to know how to create a report from one table. But now ,I want to create a report that is going to use 2 tables from Navision,for e.g Vendor and Vendor Ledger Entry, I displayed the Vendor No from the Vendor Ledger Entry table and using this I want to bring the field Name from the Vendor table.'

I used this function
C5=NL("Rows","Vendor Ledger Entry","Vendor No.","Link=","Vendor","No.","=Vendor No.")

and now to display the column"Name" from the Vendor table I used the NF function($C5,"Name")….but it is not working any help please

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts February 28, 2012 17:34

  Hi,
  
  You actually have your function the wrong way around. If you want to group the report by vendors, you want to make the Vendor the primary table and the Vendor Ledger Entry the secondary table in this formula. It would look like this:
  
  =NL("Rows","Vendor",,"Link=","Vendor Ledger Entry","Vendor No.","=No.")
  Then you can use NF functions to get the No. and Name fields.
  
  Regards,
  Hughes