Counting individual reps

[Maker1]

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!!

 

[hilfy]

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

 

[Maker1]

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.