HideZeros

Comments

• gordk St.Catherines On. Canada.

  December 2007 edited 8:58PM

  what version are you using, are you working with a memo or a cross tab?
  is the value a true 0 or a decimal like 0.0001 and memo's display format is set to 2 decimals?
  
• BJL Brussels, Belgium

  December 2007 edited 8:58PM

  Hi Gordk,
  
  Version 4.4.47
  TfrxMemoView
  DisplayFormat:
  fkNumeric
  %2.2n
  DecimalSeparator ,
  
  Of course, it is always possible to test the value and make the Memo invisible, when 0.
  
  Regards
  
  BJL
• BJL Brussels, Belgium

  December 2007 edited 8:58PM

  I found the problem.
  It was due to the use if the function f_if in an SQL-request. Adding a cast solves the problem.
  Like
  
  cast(f_if(L.DC,'>',0,L.montant, 0) as NUMERIC(15,2)) as MTD
  
  BJL
• gordk St.Catherines On. Canada.

  December 2007 edited 8:58PM

  Glad to hear you found it
  yes it is a usual problem with currency values even though display prop is 2 decimals
  the underlying value holds at least 4 places so depending upon calculations (usually taxes) a stored value may actually be 0.0010 or more decimals depending upon the precision the dbengine uses for currency fields.
  
• BJL Brussels, Belgium

  December 2007 edited 8:58PM

  Gordk,
  
  In my case, it was a true 0. But the function f_if returns a string, well recognized by Fastreport under the format fkNumeric. But the Hidezero does not work if the value is a string. So the cast is necessary.
  
  BJL