0

Filter the Item Card No. 2 Field that has a symbol.

Jet Reports Historic Posts

September 05, 2016 01:13

None

Follow

Hi all,
In our Item Card, we use a suffix .01, .02, .03 to identify versions of an item card.
E.g: 1234 (Original)
1234.01 (Version 1)
1234.02 (Version 2)
1234.03 (Version 3)

5678 (Original)
5678.01 (Version 1)
5678.02 (Version 2)
5678.03 (Version 3)

I'm looking for a way to filter the item card, and exclude all the .01, .02, .03 so that I can see only the "original" Items.

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts September 05, 2016 06:38

  I use "<>*.*" as a filter in a similar situation. Will give you everything that isn't "something.something"

• 0
  
  Jet Reports Historic Posts September 05, 2016 06:43

  Hi TeresaRoberts,
  I did try that, however I get;
  Result: #VALUE!
  Dynamics NAV C/Front reported the following error:
  
  The filter '<>*.*' is invalid.
  
  You entered
  an invalid expression in the filter on the SAP Code field in the Item table.
  
  This is the query that I used;
  =NL("Rows","Item","","Customer No.",$G8,"No.","<>*ACS","+Description","*","No. 2","<>*.*")

• 0
  
  Jet Reports Historic Posts September 05, 2016 07:11

  Managed to replicate your problem, very odd. Works fine in text fields but the code field doesn't like it.
  
  It's a bit horrible (slow, I should think) but since "*.*" works you could use a difference function. Something like this…
  
  NL("Rows","Item","","Customer No.",$G8,"No.","<>*ACS","+Description","*","No. 2",NP("Difference",NL("Filter","Item","No. 2"),NL("Filter","Item","No. 2","No. 2","*.*")))

• 0
  
  Jet Reports Historic Posts September 06, 2016 06:33

  Strange. When I evaluate the Function it appears to be OK, however when I refresh the report it only returns #VALUE!, with an error message of Empty filter not allowed.
  
  I am using Jet Essentials 2013 Update 1 14.1.14226.0 (64-bit) on Excel 2010 connecting to Microsoft Dynamics NAV 2009 R2 if that has any bearing on the result.
  
  
• 0
  
  Jet Reports Historic Posts September 06, 2016 06:53

  You seem to have an item in there with no item no.
  
  To get around that, I'd add a filter to the part that gets all the items, to not get ones with a blank no.
  
  e.g.
  
  NL("Rows","Item","","Customer No.",$G8,"No.","<>*ACS","+Description","*","No. 2",NP("Difference",NL("Filter","Item","No. 2", "No.","<>''"),NL("Filter","Item","No. 2","No. 2","*.*")))