Format Currency in a Visual Studio Report

Comments

• Options

  Torben_Wind_Meyhoff[MSFT] Member, Microsoft Employee Posts: 22

  2010-09-17

  In the RDLC designer you should go to the text box you added. If you total field was called MyField and was of type decimal, then there will be an extra field in the data set called MyFieldFormat, that would contain the decimal information, so on the Format property of the text box you would add the value from the data set: =Fields!MyFieldFormat.Value
  
  BR
  Torben

  “This posting is provided "AS IS" with no warranties, and confers no rights.”

  0
• Options

  Votuc Member Posts: 206

  2010-09-17

  I looked through the data sources (on left in Visual Studio) and I replaced
  
  Sales_Invoice_Line_Amount
  with
  Sales_Invoice_Line_AmountFormat AKA "=First(Fields!VATAmountLine__VAT_Amount__Control117Format.Value)"
  
  
  Now when the invoice prints, it shows this:
  
  #,##0.00
  
  I tried to expand the width of the table column but it still shows the same (#,##0.00).
  
  

  0
• Options

  Torben_Wind_Meyhoff[MSFT] Member, Microsoft Employee Posts: 22

  2010-09-20

  The properties on that particular text box should be following:
  Format: =Fields!Sales_Invoice_Line_AmountFormat
  Value: =Fields!Sales_Invoice_Line_Amount
  
  Format field Sales_Invoice_Line_AmountFormat contains the decimal information, like what you see: #,##0.00
  Value should then still be your decimal value: Sales_Invoice_Line_Amount
  
  BR
  Torben

  “This posting is provided "AS IS" with no warranties, and confers no rights.”

  0