ssrs format amount with $ (dollar) sign

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  March 20, 2014 at 1:03 pm

  #305447

  In an SSRS 2008 r2 report, I am trying to display a transaction amount in the report with dollar and cents amounts. I have tried to used the following:

  =Format(Fields!TransactionAmount.Value, "C")

  but I do not see value that look like the following:

  $25.00

  $166.89.

  I just see:

  25.00 or 166.89.

  I do not see the $ in the amount.

  Note: In a summary line I have code like

  =IIF(Fields!PaymentType.Value=

  "Ch", sum(cdec(Fields!TransactionAmount.Value)),0)

  Thus can you tell me what I can do so the dollar and cents amounts are displayed in the report?

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  March 20, 2014 at 1:13 pm

  #1698867

  Change the format of the textbox from c2 (currency, two decimal places) to n2 (number, two decimal places)