Schema file elements not recognised as numbers

[jesperengel]

Using CRvXI

I am using a xsd scema file as my data source, where some of the datatypes are strings and some are numbers.

In CR I can see in the Database field that the datatypes are Numbers but I cannot format them as numbers, i.e. no matter what I do to the number it is only displayed as in the original xsd file.

Thank you!

 

[Turkbear]

Hi,
Try an explicit conversion formula using the
ToNumber({xsdfield})
function and use that formula in your report instead - format it as you like..




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jesperengel]

Hello Turkbear,

Thank you for your reply. Unfortunately it did not do the job. Somehow it seems as if CR still interprets the number data type from the schema file as a string. Allthough I can add as many decimals to the number as I like, but not format it in any other way.

Can I use another datatype for the schema file besides "double"???

Thank you!