0

Filtering

Jet Reports Historic Posts

June 18, 2014 08:33

None

Follow

hi,

in which table is the field "Barcode"? is there also a field for item-no?

regards
jetsetter

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts June 20, 2014 06:25 Official comment

  Hi,
  your "NL,Rows"-function looks good, but there is no filter on a Barcode.
  You just linked the two tables, but you don't have a filter on a specific Barcode
  
  is that your Problem?
  
  regards

• 0
  
  Jet Reports Historic Posts June 18, 2014 08:33

  Hi all,
  
  I have 4 options, item no., Variant Code, posting date and barcode(from another table) to find records in the value entry table. When i try to filter by barcode, the results will take all of the records instead of the item of the barcode.
  
  This is my fomula
  =NL("Rows","Value Entry",,"Item No.",$C$2,"Posting Date",$C$3,"Variant Code",$C$4)
  
  Please help.
  
  Thanks!

• 0
  
  Jet Reports Historic Posts June 19, 2014 01:27

  Hi Jetsetter,
  
  The barcode is from BARCODE table. There is a field for item-no in the barcode table.
  
  I have tried this method, but it still does not display the results out.
  
  =NL("Rows","Value Entry",,"Item No.",$C$2,"Posting Date",$C$3,"Variant Code",$C$4,"Link=","Barcodes","Item No.","=Item No.","Variant Code","=Variant Code")
  
  Please advice.
  
  Thanks

• 0
  
  Jet Reports Historic Posts June 20, 2014 08:59

  Hi Jetsetter,
  
  Yes. I figured it out. I forget to add in the barcode filter in the function. Thanks for helping!