<div>
I took into account this maybe just for the first number and there wouldn't be 2 or 3 preceding zeros.<br />
<br />
IF LEFT(field,1) = 0 THEN<br />
&nbsp; &nbsp; MID(field,2)<br />
ELSE<br />
&nbsp; &nbsp; field<br />

</div>


I took into account this maybe just for the first number and there wouldn't be 2 or 3 preceding zeros.

IF LEFT(field,1) = 0 THEN
    MID(field,2)
ELSE
    field


<div>
Keep getting an error that a number is required here, it seems that the {serial} number field I'm applying this formula too is a string.
</div>


Keep getting an error that a number is required here, it seems that the {serial} number field I'm applying this formula too is a string.

<div>
The second formula worked great.<br />
<br />
Thank you.
</div>


The second formula worked great.

Thank you.

<div>
Thank you, like always - that was perfect.
</div>


Thank you, like always - that was perfect.

<div>
<div class="content wysiwyg-content">
I have a field in Crystal Reports 2011 with serial numbers : (No grouping is being done, only sorting accending - so they show up first)<br />
<br />
123456789<br />
987564321<br />
023456789<br />
<br />
I need to create a formula that checks each number and if it has a preceding zero, to remove it and just show the remaining numbers :<br />
&nbsp;023456789 <br />
&nbsp; &nbsp; will be changed to <br />
&nbsp;23456789<br />
<br />

</div>
</div>


I have a field in Crystal Reports 2011 with serial numbers : (No grouping is being done, only sorting accending - so they show up first)

123456789
987564321
023456789

I need to create a formula that checks each number and if it has a preceding zero, to remove it and just show the remaining numbers :
 023456789 
    will be changed to 
 23456789



Remove a preceding zero from report in crystal

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.