<div>
Try this<br />
Put the field in the detail section<br />
Right Click the left margin of the detail section<br />
Click FORMAT SECTION<br />
Click the format button next to SUPPRESS<br />
Formula is<br />
&nbsp; &nbsp;PreviousIsNull({YourField}<wbr />) or (ToNumber(Right({YourField<wbr />,6)) - 1 = (Previous(ToNumber(Right({<wbr />YourField,<wbr />6))) <br />
<br />
mlmcc<br />
<br />

</div>


Try this
Put the field in the detail section
Right Click the left margin of the detail section
Click FORMAT SECTION
Click the format button next to SUPPRESS
Formula is
   PreviousIsNull({YourField}) or (ToNumber(Right({YourField,6)) - 1 = (Previous(ToNumber(Right({YourField,6)))

mlmcc



<div>
I get matching } for this field name is missing, if I add the brackets to the field name I get the ) is missing.
</div>


I get matching } for this field name is missing, if I add the brackets to the field name I get the ) is missing.

<div>
Sorry { } go around the Crystal field names.<br />
<br />
Try this one<br />
&nbsp;PreviousIsNull({YourField}<wbr />) or (ToNumber(Right({YourField<wbr />},6)) - 1 = (Previous(ToNumber(Right({<wbr />YourField}<wbr />,6))))) <br />
<br />
mlmcc
</div>


Sorry { } go around the Crystal field names.

Try this one
 PreviousIsNull({YourField}) or (ToNumber(Right({YourField},6)) - 1 = (Previous(ToNumber(Right({YourField},6)))))

mlmcc

<div>
I get field is required here message after: &nbsp; &nbsp;Previous( 
</div>


I get field is required here message after:    Previous(

<div>
That's what I get for copying.<br />
<br />
PreviousIsNull({YourField}<wbr />) or (ToNumber(Right({YourField<wbr />},6)) - 1 = (ToNumber(Right(Previous({<wbr />YourField}<wbr />,6))))) <br />
<br />
mlmcc
</div>


That's what I get for copying.

PreviousIsNull({YourField}) or (ToNumber(Right({YourField},6)) - 1 = (ToNumber(Right(Previous({YourField},6)))))

mlmcc

<div>
Now: To many arguments have been given to this function.
</div>


Now: To many arguments have been given to this function.

<div>
Sorry.<br />
<br />
PreviousIsNull({YourField}<wbr />) or (ToNumber(Right({YourField<wbr />},6)) - 1 = (ToNumber(Right(Previous({<wbr />YourField}<wbr />),6)))) <br />
<br />
mlmcc
</div>


Sorry.

PreviousIsNull({YourField}) or (ToNumber(Right({YourField},6)) - 1 = (ToNumber(Right(Previous({YourField}),6))))

mlmcc

<div>
Now: The string is non numeric
</div>


<div>
Wait, It works!, Now I got it. Thanks
</div>


<div>
It works, but I need a formula that creates a report that continues to show all of the data in the field and somehow marking the gaps. Is that possible?
</div>


It works, but I need a formula that creates a report that continues to show all of the data in the field and somehow marking the gaps. Is that possible?

<div>
Yes. &nbsp;How do you want the gaps marked?<br />
<br />
mlmcc
</div>


Yes.  How do you want the gaps marked?

mlmcc

<div>
Maybe like a formula field with the word missing at the gap. Or highlighting. Any report that keeps all the data in the field while at the same time showing the gaps.
</div>


Maybe like a formula field with the word missing at the gap. Or highlighting. Any report that keeps all the data in the field while at the same time showing the gaps.

<div>
Let me think about it. &nbsp;Rather late here now.<br />
<br />
mlmcc
</div>


Let me think about it.  Rather late here now.

mlmcc

<div>
<div class="content wysiwyg-content">
I have a field with data formated : AB002200, AB002201, AB002203, AB002204, AB002206, etc. The first two characters are always AB followed by 6 numbers. I want a formula to find gaps in the numeric sequence portion of this data. (for example AB002205 is missing in my sample data) I have Crystal Reports 8.5
</div>
</div>


I have a field with data formated : AB002200, AB002201, AB002203, AB002204, AB002206, etc. The first two characters are always AB followed by 6 numbers. I want a formula to find gaps in the numeric sequence portion of this data. (for example AB002205 is missing in my sample data) I have Crystal Reports 8.5

Sequence gap in alpha-numeric field

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.