Formatting a number in Reporting services.

Posted on 2006-03-24
Last Modified: 2012-06-21
i want to format a number "my way" in a MS RS Report.
The number is f.ex. (formatted by N2) gives me 123,400.50. Trying to change it to : 123.400,50
In other words: Change the decimal "point" from  "." to "," and the thousand seperator from "," to ".".

What can i do?
Tried "###.###.##0,00" with no sucess
Question by:KnutUrke
    LVL 4

    Accepted Solution

    Hello KnutUrke,

    as far as I know, numeric format is set by choosing a given "Language" property in the report properties.
    If you want a number to be formatted to 123.400,50 do this :
    1) in the textbox properties, choose Format = Custom and type this :   #,###.000
    2) in the report properties, choose a language that has desired number format, for example "French (Belgium)"

    This is the only way I know to get what you want...

    If you type "#.###,000", it won't give anything, because :
    - decimal point "." only determines the location of the decimal separator in the formatted value (so you can only determine where it appears, not which character is used for decimal separator)
    - comma "," determines the location of thousand separators. Comma must be at the left of the decimal point in your formula.
    Read more about Custom Numeric Format at :

    Hope this helps
    LVL 4

    Expert Comment

    Thoughts ?

    Author Comment

    Thank you!. Choosing my language did it!. The " surrounding the number was of course not there, just for clarification. Once again, thanks for the solution! (Just for the record. I am a Norwegian, not French! he, he!)
    LVL 4

    Expert Comment

    You're Norwegian, but from now, you will work with french numbers !
    Don't worry, nobody will notice the difference...   ;-))

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now