Update Report Viewer Currency Based On Region
<p>I'm trying to have my report adjust to computer's local region that generates the report. May I ask how abouts do I do that?</p>

<p>I tried two things.</p>

<p>First thing I tried</p>

<p>Set Computer Region Location to be UK and set the field to be an expression </p>

<pre><code>=FormatCurrency(Fields!CurrentBalance.Value,2)
</code></pre>

<p>Second thing I tried was Set computer Region to be UK and set the thread culture</p>

<pre><code>System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("en-GB");
Application.CurrentCulture = cultureInfo;
Thread.CurrentThread.CurrentCulture = cultureInfo;
Thread.CurrentThread.CurrentUICulture = cultureInfo;
</code></pre>

<p>using the above methods didn't quite work. I would like to be able to change back and fourth for testing. </p>