0

Empty Filter Not Allowed

Jet Reports Historic Posts

July 28, 2009 20:32

None

Follow

I am getting the error message 'empty filter not allowed". How do I get fix this error and the #value! in those cells? I am trying to get columns L thru AK to pull balances based on posting date, g/l account, project code and expense code filters but I am getting the error messages. Also, in column H, I do not want any blank project codes but it's pulling in those blank codes. Any help would be appreciated. Thanks!!!

• Expense by Project Code - All Accounts 3.xls

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 29, 2009 01:36

  to stop the "Empty Filters Not Allowed" error put "@@"& before any cell references which could refer to an empty cell.
  
  if you are still getting the error and there are "@@"& before cell references, check to see if your formula is longer than 256 characters.
  All formula must be less than 256 characters.
  
  -Bromy

• 0
  
  Jet Reports Historic Posts July 29, 2009 09:06

  If it is for the NL("Sum") better is to put a condition in like:
  
  =IF($F15="";0;NL("Sum",TABLE,FIELD,FIELD,$F15))
  
  This is a MAJOR performance improvement instead of doing all sums with @@

• 0
  
  Jet Reports Historic Posts July 29, 2009 21:33

  Both of those suggestions worked. Thanks!!!