0

Purchase Header & Lines filter

Jet Reports Historic Posts

October 29, 2009 14:56

None

Follow

Hi All

Im pretty new to Jet but trying to write an outstanding order report using the Purchase Header & Purchase Line Table.

I have done a filter on the purchase line to only show lines with a >0 Outstanding Qty. The only problem with this is if there are no lines outstanding the header information is still shown. Purchase order no and supplier.

Would appreciate any help :)

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts November 13, 2009 08:46

  Use =NL("Rows=2","Purchase Header",,"Link=","Purchase Line","Document No.","=No.","Outstanding QTY","<>0")