0

Problem on decimal field filtering

Jet Reports Historic Posts

July 22, 2009 04:33

None

Follow

Hi,
I am very new to Jet and have some question. On one of my PCs , I got error on using this formula
NL("Rows","Customer",,"Sales (LCY)",">0")
Only one PC produce error but the rest are OK. On this PC , it work only if I remove field filter from this formula or I put "*" instead of ">0".
Anyone can suggest what shuold I do?

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts August 11, 2009 09:25

  can you tell us what error message you are getting?

• 0
  
  Jet Reports Historic Posts August 14, 2009 10:31

  The formula result return #Value!

• 0
  
  Jet Reports Historic Posts August 14, 2009 15:39

  if you select the cell with the #Value and then click on Jet, Debug, do you get an error message?

• 0
  
  Jet Reports Historic Posts August 14, 2009 16:06

  Can you try typing in 0.00 instead of 0 into your filter?

• 0
  
  Jet Reports Historic Posts August 15, 2009 01:10

  When I click debug, I get error "Navision C/Front error 5".
  I try "0.00" and get same result.
  
  Thanks

• 0
  
  Jet Reports Historic Posts August 15, 2009 01:49

  Hi Everybody
  Good news to me, I found that my problem is incorrect version of C/Front then I reinstall with the latest one. Problem solved.
  
  Thanks for your good help.