0

Adding an additional option from a diffrent table

Jet Reports Historic Posts

April 27, 2009 20:24

None

Follow

Hello,

I created a report using 2 different tables. All the options (Branch Location, Posting Date) I created with the 1st table and the wizard are working fine. I added the 2nd table to the report and the information is carrying on to the report but when I tried to add an option (Return Reason Code) from that 2nd table it doesn't work. Please help!!
Please let me know if you need any additional information or explanation.

• RMA's.xls

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts June 10, 2009 23:00

  Hello,
  
  I took a look at the report and I think I know the reason that you may not be getting results (at least not the results that you are looking for). The NL("Lookup") function will generally go through the first thousand records, so it may not be finding all of the ones that you want to see. Instead of pointing to the Return Receipt Header, try pointing to the Return Reason table. This table contains all of the Return Reason Codes that have been defined in your database. The function that you are looking for should be:
  
  =NL("Lookup","Return Reason",{"Code","Description"})
  This will return both the Code and the Description.
  
  I hope this helps!