0

Invalid filter @@ error message jet 10.

Jet Reports Historic Posts

January 27, 2012 15:17

None

Follow

Hi,

all my jetrports are made in Excel 2003/Jetreports 7.1.2 build 1830. We are now in de proces of starting to use Excel 2010 and Jetreports version 10.1.10314.0. This goes without any problems for 99.9% of the reports. However some reports that run perfect in the old version return the error "Invalid filter @@." in the new version. The error is on a cell with formula "=NL("Last";"Delivery date history";"Creation DateTime";"Document No.";"@@"&D8;"Date Type";"Promised Delivery Date";"Delivery Schedule Line No.";"@@"&O8)". Cell O8 is an empty cell with an NF function retrieving the schedule line no.

Any suggestions are much appreciated.

Regards,

Arnoud Rottinghuis

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts January 27, 2012 22:59 Official comment

  Hi Arnoud,
  
  What type of field is "Delivery Schedule Line No."? I'm assuming it's probably an integer field in Nav. The reason this filtering change was made (back in Jet Reports 2009 actually) was that blank is an ambiguous filter for integer type fields. Navision itself will not let you set a filter for blanks '' (2 single quotes) on an integer field, which is what the "@@" in Jet Reports is doing when you don't specify a value. I believe Jet Reports v7 and earlier may have been converting the "@@" to 0, but doing this can have unintended consequences since you could technically have a 0 as a field value for an integer field. Since the blank filter value was ambiguous, and since Navision itself does not allow it, we decided not to allow it in Jet either.
  
  Now you say you have an NF retrieving the schedule line no. in another cell and it's coming back as blank. This is curious but I'm guessing there could be 2 causes for this. Either you're either retrieving it from a different table and that the field type in that table is actually Code instead of Integer. Code fields are allowed to be blank, so this mismatch in field types could cause the problem. The other possibility is you have an NF to an NL function which is returning no values, so the NF comes back as blank. In this case, you could do something like this in the NF in O8 (assuming 0 is not a valid value for schedule line numbers in your database):
  
  =IF(NF(B8,"Schedule Line No.")="",0,NF(B8,"Schedule Line No."))
  Of course you could also split the IF function out to its own cell and reference that cell instead of O8.
  
  Does this work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts January 30, 2012 10:00

  =N(NF(B8,"Schedule Line No."))

• 0
  
  Jet Reports Historic Posts January 30, 2012 12:25

  Hello Hughes an Sebastiaan,
  
  thanks for your help. =N(NF(B8,"Schedule Line No.")) did the trick.
  
  Regards,
  
  Arnoud