• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

formatting Crystal reports

If I have a field  value like 1000000 and I  want to show it in thousands
1000   how do I show it
0
maverickxx
Asked:
maverickxx
  • 2
  • 2
  • 2
1 Solution
 
peter57rCommented:
Creae a formula field as...

{table.field}/1000

Then use format field to set the number of decimal places.
0
 
maverickxxAuthor Commented:
Peter57r,
Is there a way  to  right click -> format field> the apply above formula . or do I have to create a separate formula .. I have at least 15 fields so Do I have to create formula for each one i.e 15 formulas?


0
 
peter57rCommented:
I can't see any way you can do this via formatting.
You have to create a formula field for each one.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
mlmccCommented:
If you have a lot of fields, there is one thing to try.

Select them all
Right Click one of them
Click FORMAT FIELDS
CLick the COMMON TAB
Click the Formula Button to the right of DISPLAY STRING
Trunc(CurrentFieldValue /  1000)

mlmcc
0
 
mlmccCommented:
You might have to use
CStr(CurrentFieldValue /  1000,0,"")

mlmcc

0
 
maverickxxAuthor Commented:
Thanks mlmcc
0
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now