Count Number of Records

Moderators: Moderators, Tech Support

Post Reply
lmconn
Posts: 56
Joined: Mon May 13, 2013 12:41 pm
Location: Dothan, AL

Count Number of Records

Post by lmconn »

Hello, we're running a custom report that lists our members by category (personal status). For example, we have Member - Active, Member - Inactive, etc. For the custom report, I have each group separated. In the group footer I would like to list the number of records listed in that group. I have played around with COUNT, but I just can't figure this out. Any help?

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Count Number of Records

Post by Zorak »

Take one of the fields you are reporting on, like "last_first" and copy it into the Group Footer. Double click that field on the report, then on the Field Properties screen that pops up, click on the Calculate tab, choose Calculation type: Count and Reset based on: Group.

Post Reply