<div>
Creae a formula field as...<br />
<br />
{table.field}/1000<br />
<br />
Then use format field to set the number of decimal places.
</div>


Creae a formula field as...

{table.field}/1000

Then use format field to set the number of decimal places.

<div>
Peter57r,<br />
Is there a way &nbsp;to &nbsp;right click -&gt; format field&gt; 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?<br />
<br />
<br />

</div>


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?




<div>
I can't see any way you can do this via formatting.<br />
You have to create a formula field for each one.
</div>


I can't see any way you can do this via formatting.
You have to create a formula field for each one.

<div>
If you have a lot of fields, there is one thing to try.<br />
<br />
Select them all<br />
Right Click one of them<br />
Click FORMAT FIELDS<br />
CLick the COMMON TAB<br />
Click the Formula Button to the right of DISPLAY STRING<br />
Trunc(CurrentFieldValue / &nbsp;1000)<br />
<br />
mlmcc
</div>


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

<div>
<div class="content wysiwyg-content">
If I have a field &nbsp;value like 1000000 and I &nbsp;want to show it in thousands<br />
1000 &nbsp; how do I show it
</div>
</div>


If I have a field  value like 1000000 and I  want to show it in thousands
1000   how do I show it

formatting Crystal reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.