0

Filter based on multiple tables

Jet Reports Historic Posts

November 03, 2008 05:29

None

Follow

Hi All,

Is it possible to filter based on multiple tables? What I want to do is this:

=NL("Sum","Prod. Order Component","Cost Amount","Item No.",$L20,"link=","Prod. Order Line","Prod. Order No.","=Prod. Order No.","Line No.","=Prod. Order Line No.","Item No.",$F20,"Prod. Order No.",NL("Filter","Production Order","No.","Finished Date",$H$6,"Status","Finished"))


Thanks! :)

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts November 08, 2008 16:03

  auds,
  
  correct me if i'm wrong, but do you want to get the sum of the "Cost Amount" from the "Prod. Order Component" table where there is a "Prod. Order Line" and the Production Order is within the "finished date" and it is finished?
  
  Then you could use
  
  =NL("Sum","Prod. Order Component","Cost Amount","Prod. Order No.",NL("Filter","Production Order","No.","Finished Date",$H$6,"Status","Finished"),"link=","Prod. Order Line","Prod. Order No.","=Prod. Order No.","Line No.","=Prod. Order Line No.","Item No.",$F20)I suspect that your problem was the NL("Filter") after the "Link=". I don't think you can use NL("Filter") within a "Link=".
  
  Also, I have never worked with this tables, so I'm not 100% sure of the relationship between them.