<div>
Are you sure they are numeric fields and not strings?<br />
<br />
What formula are you using.<br />
<br />
mlmcc
</div>


Are you sure they are numeric fields and not strings?

What formula are you using.

mlmcc

<div>
Hi.<br />
<br />
I have figured out the solution:<br />
<br />
CStr({ServiceAreaDetailRep<wbr />ort;1.area<wbr />},0,&quot;&quot;)&amp;CS<wbr />tr({Servic<wbr />eAreaDetai<wbr />lReport;1.<wbr />seq},0,&quot;&quot;)<wbr /><br />
<br />
Thanks for your help.
</div>


Hi.

I have figured out the solution:

CStr({ServiceAreaDetailReport;1.area},0,"")&CStr({ServiceAreaDetailReport;1.seq},0,"")

Thanks for your help.

<div>
Use CStr (totext) function. You should use something like this:<br />
&nbsp;formula = CStr(aaa,0) + totext(bbb,0) <br />
&nbsp;- in Basic syntax<br />
&nbsp;or totext(aaa,0)+ totext(bbb,0)<br />
&nbsp;- in Crystal syntax.<br />
&nbsp;where aaa and bbb are your fields, and 0 is number of decimal places.<br />
<br />
HTH,<br />
ladylinet 
</div>


Use CStr (totext) function. You should use something like this:
 formula = CStr(aaa,0) + totext(bbb,0)
 - in Basic syntax
 or totext(aaa,0)+ totext(bbb,0)
 - in Crystal syntax.
 where aaa and bbb are your fields, and 0 is number of decimal places.

HTH,
ladylinet

<div>
<div class="content wysiwyg-content">
hi.<br />
<br />
I have 2 fields that need to be combined into 1 field. I'm using the formula method and the fields do get concatenated correctly. The problem is the 2 fields data are numbers such as Field1: 2,123.00 and Field2: 12.00<br />
<br />
What i would like is the new field to concatenate the fields but formatted correctly and be seen as 212312 and not 2,123.0012.00<br />
<br />
How do I format the new FORMULA field on the report?<br />
<br />
Thanks
</div>
</div>


hi.

I have 2 fields that need to be combined into 1 field. I'm using the formula method and the fields do get concatenated correctly. The problem is the 2 fields data are numbers such as Field1: 2,123.00 and Field2: 12.00

What i would like is the new field to concatenate the fields but formatted correctly and be seen as 212312 and not 2,123.0012.00

How do I format the new FORMULA field on the report?

Thanks

Crystal Reports and formatting FORMULA fields

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.