Group header 3 digit comma seprator issue

Group header 3 digit comma seprator issue

Posted by: jonathanlau2828 on 13 May 2019, 9:13 pm EST

• 

  jonathanlau2828

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 May 2019, 9:13 pm EST

  Hi,

  In the Group Header of our report, we are not able to format the summary value with comma separated after every 3 digits (US Format) where as we could format the values present in the detail section.

  Group header has a aggregate Summary function “Sum” and a textbox with format “#,##0.00;(#,##0.00)”. We want to the output like "1,090,000.00 " whereas it is appearing as “10,90,000.00” (Comma after every two digit).

  Please let us know how to achieve the above requirement.

  Regards,
  
  Kamal

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2019, 10:44 pm EST

  Hi,

  For displaying the currency value with comma after 3 digits, you need to set the OutputFormat property of TextBox to “#,##0.00”.

  Thanks,
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 16 May 2019, 5:05 pm EST

  Hello,

  You have to set the property of “Culture” property to “English(United States)” along with the above-mentioned property.

  Thanks.