Post reply

Reporting Servies

  • January 26, 2011 at 12:15 am

    #245863

    Hi

    I have designed report in reporting services. I'd like to format number(###,###,###.## to ###.###.###,##),but I can't reach my goal.

    Are there any solutions for this?

    Thank for your reply,

    Ketteyous

  • January 26, 2011 at 12:44 am

    #1278313

    Sounds like a 3-part replace:

    replace(replace(replace(Column, '.', '|'), ',', '.'), '|', ',')

    I'm not sure what the SSRS statements would be :(, but you should be able to look it up if necessary.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • January 26, 2011 at 10:43 am

    #1278631

    ket.teyousbbaac (1/26/2011)

    Hi

    I have designed report in reporting services. I'd like to format number(###,###,###.## to ###.###.###,##),but I can't reach my goal.

    Are there any solutions for this?

    Thank for your reply,

    Ketteyous

    I'm guessing this is because you are not in the US. To achieve this format you could specify it using N for the format string, and based on the Regional settings for your computer it should put it in the appropriate format. Have a look at this BOL article which eventually references this MSDN article about proper numeric formatting strings... Using the format string allows users in various locales to view the numbers and interpret them based on their individual locale settings.

    -Luke.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • January 26, 2011 at 6:29 pm

    #1278891

    OK thank you for your help. Now I can achieve this format with using text properties and change language to gl or vi-VN.

    Thankfully,

    Ketteyous

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

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