Skip to Content
avatar image
Former Member

How do I create culturally sensitive number fields

If my data is (en-US format):

1.1

2000

123.15

...

I want to see the following if I've set my regional settings to en-US:

1.1

2,000

123.15

...

And I want to see the following if I've set my regional settings to fr-FR:

1,1

2.000

123,15

...

I'm not nearly as concerned about the thousands separator as I am about the decimal separator.

How do I accomplish this?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2008 at 05:37 PM

    What is the version of Crystal that you are using?

    You can get the desired format by right clicking on the object and selecting the format field and select desired format or use customize button to customize the format.

    If you want to change the format only by changing the regional settings then go to control pannel and select the regional settings and you can customize the formats for each data type using customize button.

    This works fine if you are using Crystal XI or XI R2 but in Crystal 2008 I think you need to use menu option view>preferred viewing locale>select en-US or FR

    Regards,

    Raghavendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 06:50 PM

    If you're using Enterprise/Infoview and want the report to adjust to whichever locale the server is in you can use "System Default Format" for your number format setting then it will adjust to the server's locale.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 12:55 PM

    Thanks for the replies. To clarify: I am using the version of Crystal Reports which comes with Visual Studio 2008 and I am primarily concerned with the report when it is in the report viewer/finished application. How it looks in the editor is not important to me.

    1st reply: Simply changing the format will not suffice. I need it to detect the client's regional settings and change them at runtime.

    2nd reply: This is a client app so I don't believe we're using the technologies you mentioned; no servers are involved.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2008 at 07:50 PM

    I sort of answered my own question and then raised another issue. I've opened a post about the second issue.

    Add comment
    10|10000 characters needed characters exceeded