0 down vote favorite
I am currently using an XML datasource and I have the date patterns as well as the number pattern set up as dd/mm/yyyy and #,##0.00 respectively, however the data I am pulling from the fields with Xpath is not following this pattern.
an example of a date I am catching is : 2014-02-12 16:00:15 while a price will appear as 40.0000000000.
I also clicked on the aforementioned fields and went into properties, and under pattern I changed it to currency as the numbers refer to prices and set decimals to 2, the problem remains.
I was told that I also needed to change the fields that have numeric values gotten from OPENERP to double instead of string, I did, I was also told to change the pattern to currency with 2 decimals and I did, the problem persists.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/20/14, 12:25 PM|
|Seen: 754 times|
|Last updated: 3/16/15, 8:10 AM|