locked
RDLC report and format for amount fields RRS feed

  • Question

  • User-489008729 posted

    I am using RDLC 2008 and I have an amount field which I want to format like 1,000 or 12,000 or 12,200, 345 ...amount can go upto milion or billion so need thousand seperator accordingly and keep one thing in mind that i dont need decimals as the figure is already rounded.

    What should I write in expression to achieve this.

    Thursday, December 16, 2010 11:29 PM

Answers

  • User-489008729 posted

    I've figured out by myself and did like =Format(SUM(Fields!Amount_AfterDueDate.Value),"#,#") :)


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 17, 2010 1:20 AM

All replies

  • User-442214108 posted

    have you tried right clicking the field and choosing 'Format' (it's been a while and I'm not near my computer with a ReportViewer) from the properties available?

    Thursday, December 16, 2010 11:33 PM
  • User-489008729 posted

    yeah I tried with =FormatCurrency() but I dont know exactly what should be the correct format .. "###,###" ??? when i applied this the output is "#Error" ...I am completly clueless and therefore need help.



    Thursday, December 16, 2010 11:53 PM
  • User-489008729 posted

    I've figured out by myself and did like =Format(SUM(Fields!Amount_AfterDueDate.Value),"#,#") :)


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 17, 2010 1:20 AM
  • User1471008070 posted

    Hi,

    Great sharing, many thanks. I think other members will know the direction when encounter the same issue.

    Monday, December 20, 2010 3:37 AM