Decimal Sign - load XML with wrong decimal sign
How can I load a XML file that does have a Currency format #,##0.00 into a FastReport that is running with a windows format #.##0,00. (XML has a dot as decimal sign, local windows settings is the comma the decimal sign).
My problem is that the data is multiplied with hundred.
XML file:
<Price>2.50</Price>
In the report the field Price is printed as:
250,00
Can I overrule the Windows Currency settings in FastReports (in code) ?
My problem is that the data is multiplied with hundred.
XML file:
<Price>2.50</Price>
In the report the field Price is printed as:
250,00
Can I overrule the Windows Currency settings in FastReports (in code) ?
Comments
Are you trying to load xml in the "Data/Add Data Source..." menu via the "XML database" connection? If so, there is no way to use specific locale while loading xml. You can change the current thread locale before running a report designer, but it's not a good solution.
I found a solution for my problem. When I change the attribuut msdata:UseCurrentLocale from "true" into "false" in the XML file then it works.
Thanks
Hans