Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schema file elements not recognised as numbers

Status
Not open for further replies.

jesperengel

Technical User
Nov 7, 2005
18
DK
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!
 
Hi,
Try an explicit conversion formula using the
ToNumber({xsdfield})
function and use that formula in your report instead - format it as you like..


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top