crystal reports number to 1000 place

How do I format a number field so that it only go to the 1000 place? Example 1,000,500 would be 1,001. I am using Crystal XI
kcjstarlingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Try this

(({YourField} + 500) \ 1000) * 1000

mlmcc
0
kcjstarlingAuthor Commented:
There is not a formating option to do this? I do not want to create a formual for every number field on the report?
0
mlmccCommented:
Had never looked.

Right click the field
CLick FORMAT FIELD
Choose the NUMBER TAB
Choose CUSTOMIZE
Set Decimals to 1
Set rounding to  1000

You can format many fields at once
Just select them all then right click one of them

The same format is available under
FILE --> OPTIONS  --> FIELDS Tab
That may only affect new fields and new reports.

mlmcc
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

kcjstarlingAuthor Commented:
I had already done the above, the rounding does not drop the zeros so you end you with 1,001,000 instead of 1,001
0
mlmccCommented:
The only way will be with a formula.

mlmcc
0
James0628Commented:
You can do this in the formatting.  On the Common tab, click the formula (X+2) button to the right of "Display String" (near the bottom) and enter the following formula.

CStr (Round (CurrentFieldValue / 1000), 0, ",")


 CurrentFieldValue is a generic name that you can use in formatting formulas for the current value in that field.  The advantage is that if you use that, you can use the same formula for more than one field, without having to use the specific field name.  So, you can select several numeric fields, right-click and select "Format Objects", and enter that formula for all of them at the same time.

 What you're doing is basically formatting the field manually by converting it to a string.  Note that the field value is still numeric, so you can do summaries on it, _however_, the field value will be the original value, so if, for example, you wanted an average of the altered values, you'd probably still need separate formulas for that, in which case you might as well just use those on the report, instead of using "Display String".  You might be able to get around that by doing a summary of the original values and then just dividing the result by 1,000 too.  I suppose it might depend on the type of summary and your data.

 James
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.