<div>
Crystal Report does not evaluate the reserved variable &quot;RecordNumber&quot; at record selection time, but you could put this in your detail section for the &quot;Suppress&quot; option.<br />
<br />
Just right-click on the detail section, go into Section Expert, select the X-2 for the Suppress, and enter the following formula:<br />
<br />
&nbsp; &nbsp; Remainder (RecordNumber, 3) &lt;&gt;&nbsp;0<br />
<br />
That will suppress the 2nd and 3rd records.
</div>


Crystal Report does not evaluate the reserved variable "RecordNumber" at record selection time, but you could put this in your detail section for the "Suppress" option.

Just right-click on the detail section, go into Section Expert, select the X-2 for the Suppress, and enter the following formula:

    Remainder (RecordNumber, 3) <> 0

That will suppress the 2nd and 3rd records.

<div>
Record 1<br />
109039 - L9090 - DCR001<br />
Record 2<br />
109039 - L9090 - 999999<br />
Record 3<br />
109039 - L9090 -888888<br />
Record 4<br />
109040 - L9777 - YW1004<br />
Record 5 <br />
109040 - L9777 -9912323<br />
Record 6<br />
109040 - L9777 -8888888<br />
<br />
I need to see....<br />
Record 1<br />
109039 - L9090 - DCR001<br />
Record 4<br />
109040 - L9777 - YW1004
</div>


Record 1
109039 - L9090 - DCR001
Record 2
109039 - L9090 - 999999
Record 3
109039 - L9090 -888888
Record 4
109040 - L9777 - YW1004
Record 5
109040 - L9777 -9912323
Record 6
109040 - L9777 -8888888

I need to see....
Record 1
109039 - L9090 - DCR001
Record 4
109040 - L9777 - YW1004

<div>
Put the Record Number in your report temporarily, and you'll see which number record is being allowed.
</div>


Put the Record Number in your report temporarily, and you'll see which number record is being allowed.

<div>
If that doesn't work try<br />
<br />
(RecordNumber MOD 3) &lt;&gt;&nbsp;1<br />
<br />
mlmcc
</div>


If that doesn't work try

(RecordNumber MOD 3) <> 1

mlmcc

<div>
You are awesome! &nbsp; Thanks.
</div>


<div>
<div class="content wysiwyg-content">
I need to suppress every 2nd and 3rd record that comes through. &nbsp;I am using Crystal Reports 9. &nbsp;I need to add this in the Formula Editor.<br />
<br />
Any examples?
</div>
</div>


I need to suppress every 2nd and 3rd record that comes through.  I am using Crystal Reports 9.  I need to add this in the Formula Editor.

Any examples?

Suppress every 2nd and 3rd record

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.