0

Nested NL

Jet Reports Historic Posts

August 21, 2013 06:08

None

Follow

Can someone tell me what is wrong with the following formula:
=NL("Rows","Subcontract Detail",,"Job No.",$C$2,"Link=",NL("rows","Subcontract",,"Status","<>order"))
I think it has something to do with the <>. This is a customized table and the report still shows records where <> order is true.
Thanks

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts August 21, 2013 14:32

  Hi,
  
  You don't use a nested NL function with Link=. See this help topic from the Jet Reports documentation:
  
  http://help.jetreports.com/14.0/Essentials/Simple%20Linking.html
  
  I don't know what the actual linking fields are between the Subcontrol Detail and Subcontract tables, but it might look something like this:
  
  =NL("Rows","Subcontract Detail",,"Job No.",$C$2,"Link=","Subcontract","No.","=Subcontract No.","Status","<>order")
  Like I said, I don't know the actual linking fields, so this formula is probably slightly wrong, but it should give you an idea of what you need to do. Does this help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 24, 2013 04:34

  Thank you, that works great except I want to eliminate records were the status is blank as well so my filter is "<>Order&<>''" where the second <> is followed by two single quotes and a double quote and I get an error.
  Thanks,
  Patrick

• 0
  
  Jet Reports Historic Posts August 26, 2013 12:50

  Patrick,
  
  When you click the cell with the #VALUE and click the Debug button on the Jet ribbon, what message do you get?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 26, 2013 16:02

  Hughs,
  The error message that I am getting is that the filter doesn't exist and I think that it is because this is an option field and blank is not an option. The reason why it is showing blank is maybe because there is "&" in the description of the field preceding this one. I will try @@ in that field and see what happens.
  Thanks,
  Patrick

• 0
  
  Jet Reports Historic Posts August 26, 2013 22:54

  Hughs,
  There is an & in the subcontract no. field that this formula is referencing. I cannot seem to get the @@ in the correct place in this formula to prevent the error "invalid filter" from appearing.
  =NL("Rows","Subcontract Detail",,"Job No.",$C$2,"Link=","Subcontract","No.","=Subcontract No.","Status","Order|Planning")
  Thanks,
  Patrick