0

Filtering out Item No.'s beginning with '0'

Jet Reports Historic Posts

August 16, 2012 17:11

None

Follow

Hi all,

Have a strange one.

Set up a simple report based on the Item table.

Filters set at "No." <> 0219* (C4), "Shelf No." = 2M* (C2) and Vendor No. = * (C3)

In D7: =NL("Rows","Item",,"No.",$C$4,"Vendor No.",$C$3,"Shelf No.",$C$2)

But for some reason, my result list has:

No.
021952
021987
021988
021998

If I filter <> 021952 for example, I get:

No.
021987
021988
021998

I know that Filters with Wildcards don't work on ranges, but I am not using a range right?

[size=85]Nav 5.0 SP1, Jet Essentials 2012 12.0.12187.0 64-Bit, Excel 2010 64-bit, Windows 7 64-bit.[/size]

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 16, 2012 18:06

  Hi,
  
  Similar to ranges, filters with wildcards also do not work with <> as you have observed. Actually I believe that's not quite correct; my recollection is that they don't work on NAV native but they do work with NAV SQL. I could be remembering incorrectly but I think that's right. You'll need to do this with a range instead of a <>. It might look something like "..021899|022000..". Does that work for you?
  
  Regards,
  Hughes