title: Use comma for decimals and period for thousands rdlc report
body: <p>I'm using Report Viewer Control (rdlc) to generate reports. One of my columns represent a decimal value from a SQL database, for example: </p>
  
  <pre><code>5199.9800 
  </code></pre>
  
  <p>and at the end of this column, all the amounts are summed. So, the amounts rows are represented this way: </p>
  
  <pre><code> =Fields!DEBIT.Value 
  </code></pre>
  
  <p>And the total row is represented this way:</p>
  
  <pre><code> =Sum(CDbl(Fields!DEBIT.Value), "dtsItems")
  </code></pre>
  
  <p>Currently all the values are formatted in the standard way, using comma for thousands and period for decimals like this:</p>
  
  <pre><code>  5,199.98      
  </code></pre>
  
  <p>but i need to format it the opposite way: using period for thousands and comma for decimals, like this:</p>
  
  <pre><code>   5.199,98 
  </code></pre>
  
  <p>I've been searching for a way to do it with an expression or just changing the TextBox properties in the rdlc file, but nothing seems to work.</p>