System variable settings overridden by local Region and Language settings

[#1]

Hi Friends,

I see the System Variable settings applied in the document are being overridden by the local Region and Language settings of the OS, to be specific my data uses '.' as decimal separator where as it is being interpreted as a thousands separator according to OS settings.

Is there any known work around to prevent this misinterpretation friends? I have given a try with Num function but didnt help eigther

Thank you,
Raj

[#2]

Hi Raj,

Have you tried setting the separators symbols in Separator section of Number tab?

Might be of help.

[#3 · Accepted solution]

Thanks Shyamal for reply,

I found the problem is at Ms Access selection query level itself, from the Access SQL the data returned is already formatted before it reaches the QV Load statement, resolved this by resetting the Region & Language settings.

Best Regards,

Rajesh