Start Free Trial

asked on 2/27/2007

Suppress every 2nd and 3rd record

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?

Crystal Reports

Last Comment

2/27/2007

2/27/2007

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.

2/27/2007

ASKER

No that does not work.

2/27/2007

ASKER

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

ASKER CERTIFIED SOLUTION

2/27/2007

Blurred text

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

2/27/2007

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

2/27/2007

If that doesn't work try

(RecordNumber MOD 3) <> 1

mlmcc

2/27/2007

ASKER

You are awesome! Thanks.

2/27/2007

Glad I could help.

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.

36K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY