Counting the number of object records in a report
HandsOn Connect has hidden fields that allow you to easily count the number of objects in a report.
There are "number of" fields for:
- Number of Contacts
- Number of Organizations
- Number of Connections
- Number of Occurrences
- Number of Volunteer Opportunities
For example, in a report that shows all the occurrences that took place in a given time period, you could group the occurrences by the volunteer opportunity name -- but what if you wanted to know how many volunteer opportunities that represented?
In this report we have grouped based on Volunteer Opportunity Name -- but we want to know how many volunteer opportunities this represents - without manually counting them.
We are going to show details and add the field "Number of Volunteer Opportunities"
Each object in HandsOn Connect has a field called "Number of...." that has a value of 1 populated in it.
By summing these "Number of" numeric fields - we're able to get a count.
First -- add the field "Number of Volunteer Opportunities" to your report: (you can double click and add it to the end of the report)
You'll see it has a value of 1 (1 for each occurrence)
At the bottom of the report, you'll get the sum of the number of volunteer opportunities
This report has 1267 Records (Occurrences), and 135 separate volunteer opportunities.