sum option

[aishaaa]

Hi ..

I need a help .. I have a report with amount field which need to be sum but this field in the data base is varchar .
so when I use this formula give me error it should be a numeric field ...

sum ({fieldname})

I think I need to convert the amount field to numeric field but only in crystal report
and I don’t know how to do this ...can u please advice

 

[Naith]

Aisha,

Substitute your database field with a formula that says Val({FieldName}). You can then right click on this field, and activate the summary function.

Naith

 

[aishaaa]

thanks for your reply .. i have tried this option but
it's giving error ( the result must be string )

 

[Naith]

Can you post the formula you're using, and point out where the cursor is when you're getting the error.