0

Filter by Value or Blank

Jet Reports Historic Posts

April 08, 2010 19:36

None

Follow

Hi DMDG,

I believe you could use DEP*|''. Notice that those are 2 single-quote characters after the |. Does that work for you?

Regards,
Hughes

• Facebook
• Twitter
• LinkedIn

6 comments

• 
  Jet Reports Historic Posts June 08, 2011 14:42 Official comment

  Hi,
  
  So first of all, as I said in the previous post, the filter for blank is 2 single quote characters. In your example you have double quotes with a space in between which is incorrect. You might want something more like this:
  
  01.01.2011..|''
  
  Notice those are 2 single quote characters, NOT a double quote character. However, date type fields often do not allow blank values and blank values actually come through as zeros, so if that filter does not work for you, you should try filtering for 0 instead:
  
  01.01.2011..|0
  
  Do either of those work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts April 08, 2010 19:36

  Hi All,
  
  I want to filter my records to only return if the record's Document No. is equal to a wildcard value or a blank value. I was thinking something like…
  
  DEP*|""
  
  …would return both records whose external document number start with DEP, or any records which have no external document number at all. But I'm guessing my syntax is wrong as no results are returned. Can someone offer a suggestion?
  
  I'm sure this is going to be a really simple answer, but so far I haven't been able to find it in the Knowledge base or here on the forum.
  
  Thanks for the help!

• 0
  
  Jet Reports Historic Posts April 09, 2010 19:04

  Thanks Hughes! That was the info I needed. For future reference is there documentation that contains this type of information? That could prove to be a great resource for me in future.
  
  Thanks!

• 0
  
  Jet Reports Historic Posts April 09, 2010 20:59

  Hi DMDG,
  
  I'm not sure if it has this particular example, but if you open the Jet Reports Help file and go to Reference\Filtering Reference, there are examples of all the different wildcards and filter types in Jet Reports. Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts June 08, 2011 09:51

  Hi there,
  
  I fail to apply this solution in options …
  I would like to option-filter by contract end date (talking employees here) or blank (for open-ended contracts).
  
  I tried all sorts of quotes etc. with no luck.
  
  This is what I tried first (to get the idea) :
  >01.01.2011|" "
  
  What would be the right syntax ?
  
  Thanks a ton !

• 0
  
  Jet Reports Historic Posts June 15, 2011 15:18

  Thanks a ton, Hughes !
  
  The 2 times single strokes work - sorry to have missed that on your previous replies.
  
  Cheers,