Solved

System Default Number Format

Posted on 2006-10-23
9
509 Views
Last Modified: 2011-10-03
How can I use "System Default Number Format" and specify no decimals when I format a number?

If I select "System Default Number Format" and customize it for no decimals, I lose the thousands separator specified in the Regional Options.

For example, if I use "System Default Number Format", numbers display correctly with two decimals:

999999.99 is displayed as 999,999.99 for English
999999.99 is displayed as 999 999,99 for French

I want to format a number so that:

999999 is displayed as 999,999 for English and
999999 is displayed as 999 999 for French
0
Comment
Question by:northeyk
  • 3
  • 2
  • 2
9 Comments
 
LVL 13

Expert Comment

by:crgary_tx
ID: 17789015
File-->Options-->Field-->Number-->Number

If you dont find the format you want in the available list you can customize to yourr requirement as well

Gary
0
 

Author Comment

by:northeyk
ID: 17789023
Sorry - I forgot to mention I'm using an old version of Crystal (8.5).
0
 
LVL 13

Expert Comment

by:crgary_tx
ID: 17789254
I havent worked in version 8.5. This works in 10 and XI. May be you might have to write a formula?

Gary
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 42

Expert Comment

by:frodoman
ID: 17789261
You're going to need to select a custom number format - the 'system defaul' uses Windows default formats which are largely based on the language and customs of the country you're working in.

If you follow the menu options that Gary gave you, you can customize Crystal so that it will use the default format that you specify.  After going through the menus listed, click the 'Number' tab and click the 'Customize' button.  You can then set the decimals and separator to anything you want and Crystal will use this value as the default.

frodoman
0
 

Author Comment

by:northeyk
ID: 17790126
This is what I want.  If I change the number format (customize), it ignores the Windows default.  I am in Canada.  I have English and French customers.  I want the format to reflect their Windows number format - only with 0 decimals.

>> 'system default' uses Windows default formats which are largely based on the language and customs of the country you're working in.
0
 

Author Comment

by:northeyk
ID: 17790262
If their Windows number format it English (Canada), I want 1234 to display as 1,234

If their Windows number format is French (Canada), I want 1234 to display as 1 234

Windows number formats:
English (Canada) is 123,456,789.00
French (Canada) is 123 456 789,00

If I select "System Default Number Format", I get the correct thousands separator for both, but it gives me two decimals.
0
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 17790976
The only way you could handle this in Crystal is to have a parameter for the report so the user can select their language, then you would have to conditionally format each field based on the language parameter.  This can be accomplished but it's a lot of effort to copy the conditional formatting to each field plus your users have to specify their language every time.

You can ease one portion of that if you're developing within an application.  The Windows registry contains the language settings so your application could check the registry and then pass in the appropriate language parameter automatically.  Still makes it a lot of work on the developer's side though.

Otherwise, the system default format is intended to handle the language differences, you just can't customize it that I'm aware of.

frodoman
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 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

11 Experts available now in Live!

Get 1:1 Help Now