How can i set xml element value as double in crystal report?

[Former Member]

Hi all,

I'm using xml as datasource of crystal reprot. The problem is all the data fields of xml datasource are expressed as a string type. Which means I can't have summary group of some fields that should be double type. Even, the type setted dataset are not helpful. All data fields are string type.

So, is anybody has any iear about that?

[ido_millet · Accepted solution]

In Crystal, you can simply create a formula using ToNumber() or cDbl() to convert the text to a number.

[Former Member · Accepted solution]

thanks man, it's work. but some time the reports viewer give "The string is non-numeric." message and can't fix it.

[ido_millet · Accepted solution]

Add logic to the expression to check if the value is numeric.

For example, IF IsNumeric(...) Then ToNumber(...) Else 0

[former_member11696]

Moved to Report Design forum