0

Restrictions on flowfilter field

Jet Reports Historic Posts

January 13, 2016 12:33

None

Follow

Hi,

I'm trying to create a simple report based on item table from NAV. All I wish to include is "No.", "Description" and a flow filter based on item ledger entries we call "Usage".
My problem is I wish to exclude certain document types, within NAV the following filter can be applied: "<>IM*&<>INTM*&<>PSHIP*".

However due to special character restrictions I can't recreate this in JET. I've tried using various single/double quote methods to encapsulate it but still get the standard error about special characters not being allowed.

Is it even possible? Am I just not getting the syntax right?

Any help appreciated.

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts January 13, 2016 17:23

  Hello Linkam,
  
  Can you attach a copy of the report saved in Design Mode so that I can see how it is constructed?
  Can you attach a screenshot of the error you receive and the filter you are using at the time (via the options pane presumably)?
  
  Best regards,
  MWilson

• 0
  
  Jet Reports Historic Posts January 15, 2016 09:46

  Hi,
  
  I've attached a copy of the file as requested. I did a snapshot of the error as an image on the sheet as well.
  
  Thanks for any input you can provide.

  • Usage Query.xlsx
• 0
  
  Jet Reports Historic Posts January 15, 2016 16:25

  Hello Linkam,
  
  Wildcard characters (*), question marks (?) or (at) @ signs are not allowed with FlowFilters in NAV (and in turn in Jet Essentials).
  If you were to try and accomplish this in NAV on say, the Item card by applying a FlowFilter for Location Filter with * an error would be produced.
  
  
  
  Best regards,

• 0
  
  Jet Reports Historic Posts January 20, 2016 12:06

  Hi,
  
  Sorry for delay in responding.
  
  On further investigation I see we have had bespoke that adds a further SETFILTER against "Document No." field. We have a text field within "INVENTORY SETUP" table you can type in the required filter parameters so it is possible within NAV for us to restrict the data returned using "<>IM*&<>INTM*&<>PSHIP*" as a default.
  
  So I guess perhaps because of the way the data is interrogated by JET it's probably not possible to just return the data from the flowfilter as is,
  I assume in essence it's recreating the filter itself and attempting to pass the information and as standard NAV doesn't do it JET can't?
  
  Would the only way to do this be to accept the raw data and filter within Excel afterwards to achieve the same results?
  
  Any further tips very much appreciated.

• 0
  
  Jet Reports Historic Posts January 20, 2016 18:18

  Hello Linkam,
  
  You are correct in the fact that Jet can only do what NAV can do in terms of filtering.
  If NAV doesn't allow for a specific filter against a field or flowfield then Jet will not allow it.
  You should be able to restructure your filter and enter the exact document types rather than using the *.
  e.g.
  "<>DocumentType1&<>Type2&<>OtherType3&<>AnotherType4"
  
  Best regards,
  MWilson

• 0
  
  Jet Reports Historic Posts January 21, 2016 08:10

  Hi,
  
  Thanks for the tip, I'll give that a try.
  
  Thanks