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!

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

Counting individual reps

Status
Not open for further replies.

Maker1

Technical User
Joined
Jun 20, 2003
Messages
73
Location
US
I am using Crystal 8.5 and pulling from an access database. I have a table that lists the phone monitors on our reps. I am trying to count the number of reps listed in the table. the problem I am having is that the reps will be listed more than once and I only want to count the individual reps. I looked up Distinct Count in the help file and it looks like it would work but keeps returning 1. When I use count() it give me all the records in the table. Am I missing something?

Any help appreciated!!
 
What are the groupings on the report and how are you using DistinctCount()?

If you are grouping on reps as your top level group, you'll use this:

DistinctCount({key field identfying the rep})

You would also use this if you only want the count for the entire report, regardless of what level the reps are identified at.

If you are not If you have one or more groups "above" where the reps are identified, you'll do:

DistinctCount({key field identfying the rep}, {group field})

-D

 
Each rep has a unique identifier and I am grouping by site as well as call group. I tried using distinctcount({agents.agentID},{agents.Location}) but it tells me the summary/running total field could not be created.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top