I am working on a student report (using Crystal 8.0). At the Summary footer, I want to display the total number of students listed on the report. Since students can enroll for more than one programs of study, they show up more than once in the report. Despite this, the total count will reflect the total (unduplicated) count of students not the number of times they've been enrolled. To make capturing this report more challenging, users can sort this report in a variety of ways. Their main sort can be by student name or programs of study or start date or grad date and so and so on. With that setup, how can I define a summary count field?
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
unduplicated count 1
- Thread starter rq
- Start date
-
1
- #2
The following formula should give what you're looking for. It will give you a total number of unique student names for the entire report:
distinctcount({student.name.field})
You could also us the distinct count summary operation to get a count at the group level.
Mike
distinctcount({student.name.field})
You could also us the distinct count summary operation to get a count at the group level.
Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question