Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display Swedish Format Expand / Collapse
Author
Message
Posted Monday, November 04, 2013 2:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
Goal:
Display the number in Swedish format that is "50 000 000,50" instead of 50,000,000.50 in a list containing cells.

Problem:
I have tried using "## ### ###,##" but it didn't work at all.
Any suggestion?

Information:
*I'm retrieving the data from a SSAS data source.
Post #1511301
Posted Monday, November 04, 2013 4:43 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 1,654, Visits: 5,208
The standard way would be to use the format property with a value of "C2", then it will use the user's local region settings to display the value.

If you wanted to force Swedish, then also set the "Language" property on the textbox to sv-FI (or some other suitable value).

This does add a currency symbol though, so if you just want the number, you could try "N2" instead of "C2"


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1511325
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse