Post reply

Reporting comma and dot

  • January 2, 2008 at 11:11 am

    #185134

    This is my problem...

    I have some money values for example

    330,345.011

    22,345.22

    i won't in report to get 330.345,011

    22.345,22

    any idea please???

  • January 3, 2008 at 9:24 am

    #764415

    Try using Convert and Replace to change the comma to another character (like @) then change the '.' to comma(s) finally change the other character (@) to a dot. Convert might be needed to change from money to varchar and then back to money after manipulating the string.

    Toni

  • January 3, 2008 at 12:44 pm

    #764527

    thx toni i know for that, but i dont know may i do that in report with some expression or something... thx anyway

  • January 4, 2008 at 2:40 am

    #764723

    yes you can do this by using an expression in the format of the textbox which contains that value.

    an example I used is to replace the minus field for negative values for () around that value.

    Example expression

    #,##0.00; (#,##0.00); "-";

    Another example is to use;

    #.##0.00

    (this should work)

    **Be aware of problems with language settings

    Good luck

    Niels Nagle

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply