title: format number in ssrs report
body: <p>argh!</p>
  
  <p>Can't stand it that i can't figure it out myself....</p>
  
  <p>i've used this in the formatting of a number in my report:</p>
  
  <pre><code>'€' #,0.00;('€' #,0.00)
  </code></pre>
  
  <p>and that formats to € 1,212.89</p>
  
  <p>which is not exactly what i want, because i want € 1.212,89
  regardless of the regional setting of the server.</p>
  
  <p>So i tried this</p>
  
  <pre><code>'€' #.0,00;('€' #.0,00)
  </code></pre>
  
  <p>but that gives me this:
  1.212.890</p>
  
  <p>Typing this i realize that i don't know what the # and the . and the , mean in the format string.....</p>