Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count duplicate records returned

Status
Not open for further replies.
dbaker2

dbaker2

Programmer
Dec 18, 2002
2
US
The newly formatted Crystal Decisions did not help me at all with this one.
I need to count the number of times that records duplicate. The report I am developing is using two Excel spreadsheets on shared drive for the datasource. One spreadsheet has a column titled Cust Serv Rep ID. This is the name of the Customer Service Rep. I need to be able to count the number of times the CSR's name is repeated in that column. Thanks!
 
Sort by date Sort by votes
You make no mention of any grouping, or how the report is set up. You also don't mention what version of CR you are using.


The easiest way would be to group on the CSR and then insert a count summary field in the CSR group.

The hard way is to create a set of arrays that tracks the CSR and adds one for each occurance of the CSR

Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Group Sorting Distinct Count Minimum
Replies
2
Views
270
socalvelo
socalvelo
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
380
Paulo R
Paulo R
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
209
socalvelo
socalvelo
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
178
hilfy
hilfy
ryanparks
  • Locked
  • Question
Grouping On Count of Records
Replies
10
Views
624
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top