Only show multiple records

[Julliet22]

HI!

Using: Crystal Reports 9

I have data like the following:

code Amount Location
1234 3 B3

3453 8 K4

2344 9 H5
7 G7

I want the report to only show the codes (with amount and location) of which there are more then one record. This way I have a selection of the records which exsist on multiple locations.

Thanx for all the help in advance!!

- Julliet -

 

[CrystalBart]

Julliet,

Insert a count on your code field into your Group footer.
Create a new selection with the selection expert on the count field : Greater then 2. You can suppress the count field so it wont be shown in the report.

This should do the the trick

CB

 

[CrystalBart]

Create a count on the code field in your group footer.
Insert a selection criteria with your selection expert: Count on code greater then 1. Suppress the count field if you dont want the report to show this.

This should do the trick

CB

 

[lbass]

Group on code and then go to report->edit selection formula->GROUP and enter:

count({table.code},{table.code}) > 1

Replace {table.code} with your code field.

-LB