Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Error: The FilterField has an empty Filter argument...


Overview

Sometimes you want to filter an NL function based on the contents of another cell (or the output of another NL function) which could be a blank value.  When you run the report, #VALUE is displayed in the cell and one of two error messages (depending on your version of the Jet Excel add-in) is displayed:

empty-filter.png

Complete text of error message is:

The FilterField {name of field} has an empty Filter argument, which is not allowed.  Use '' to filter for blank, or prefix the Filter argument with @@ if it is a cell reference.

or

Empty filter not allowed.

Cause:

The underlying database does not support blank filters.  Thus, the NL function cannot allow filters to be blank.


Resolution Process

  1. See the article for Referencing a Blank Cell using @@.

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

Comments