0

Compare fields in the same table

Jet Reports Historic Posts

November 28, 2008 21:14

None

Follow

Hi all

I am pretty new to this, after having bougth Jetreport.

I am planning to make a report with our delivery stastics, and I would like to count the number of entries in the "sales shipment line" table, where "shipment date" equals "planned shipment date"

Does abyone knows if this is possible?

In advance - thanks

Lars

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts December 03, 2008 14:58

  You could do this a couple of different ways, but this works for me.
  
  =NL("Count","Sales Shipment Line",,"Shipment Date",$D$4,"Planned Shipment Date","<>''","Link=","Sales Shipment Line","Document No.","=Document No.","Line No.","=Line No.","Shipment Date","=Planned Shipment Date")
  I'm attaching a workbook so you can see it better.
  
  LinkEquals.xlsx