how to change 0(zero) to -

putukaca

hi

i have data in DB which contain 0 (zero) value. how can i change that 0 to - when i display on report. the 0 value will be placed in master detail.

thank's
yudi

micropro

Hi,

In your memo, enter this statement:
[IIF(<DATASET."FIELD"> = 0,'-',<DATASET."FIELD">)]

here is what it means:
if (value = 0) then (show "-") else (show value)
so [IFF(CONDITION, IF TRUE, IF FALSE)]

hope this answers your question,

micro

putukaca

why it's raise error project invoice.exe raised exception class EVarianTypeCastError with message 'could not convert variant of type (string) into type (double)'

gordk

you probably have the display format for the memo set to numeric.
if you wish to keep display format then do your mods in the obp event of the band and modify the memos properties and contents from there, and reset the memo's props in it's oap event.