Hi,

    By using use formula method in Crystal Report,I want to change "0" (numberic value) to "-" at run time, If it is not 0, I want to display the same value in the field.I had tried by using following code.

 if{tb_test.n2}=0 then
 "-"
 else
{tb_test.n2} // Error: Use string value, But the field is numberic.

        If I remove the "Else" part also it is not showing "-", Please help me in this regard.

 Best Regards,

   Sayeed.

Hi Sayeed

The problem is due to the mix of numeric and text. A solution I often use requires 2 formula fields as follows:

[u]field1</u>
if {tb_test.n2}=0 then '-' else
totext({tb_test.n2})

[u]field2</u>
if {tb_test.n2}<> 0 then tonumber({@else})

Using the 'suppress' option in format field ;

[u]field1</u>
{tb_test.n2} <> 0 // suppress field1 if true

[u]field2</u>
{tb_test.n2} = 0 //suppress field2 if true

By laying one field on top of the other you will have the represenative information on your report.

Good luck
FD

you can try this,
if{tb_test.n2}=0 then
 "-"
 else
totext({tb_test.n2},2,'')

usually when u use the formula the result fld muat be of same datatype.
here i assumed that u want 2 decimal places no thousand seperator.
Thanks,
Kavitha.