title: Crystal report - Conversion from text to decimal?
body: <p>I have a crystal report, which takes data from an XML template. For a particular field of report, say 'Cost' the database stored procedure send data to XSD file in decimal format , but when the crystal report displays data picking from XSD, it is rounded off.</p>
  
  <p>When i right click on other data fields of report, I can see 'Field:table1.columnname',. But when i click on 'Cost' field, it shows 'Text:'.</p>
  
  <p>To my understanding, this is a text field which is mapped to pick data from XSD and since the type is text, it gives result in text hence truncating the decimal.</p>
  
  <p>Please suggest how can I get decimals here.</p>
  
  <p>P.S: This code was created by someone else, so i have no idea on what they had set at that time. I have to fix it and i have no clue about it.</p>