locked
Number formatting in SRS Reports FOR MS CRM 4.0 RRS feed

  • Question

  • Hi,

     Ihave few problems with number formatting of US and Germany

    for US (123,123.00) and form Germany(123.123,00)( dot is replaced by comma and vice versa)

     

    How to convert the number format dynamically  ?

     

    Does CRM support this,

     

    Ex: I have a report column  which needs to be displayed in german format 123.123,00 ( dot is replaced by comma and vice versa)

     

     

    I have used some formula on the field to replace the separators (as replacing the dot with comma )

     

    Report works fine , but when we export to excel formating goes off.

    please help me on this...

    Friday, January 9, 2009 12:48 PM

Answers

  • right click the field that you want to format navigate the format tab on the fotmat code text write ###.## it will formats both excell and report
    • Marked as answer by Jim Glass Jr Thursday, April 15, 2010 3:42 PM
    Monday, December 14, 2009 11:24 AM