People Membership Report

"D" = Today's Date

Count of Active Members

With the People Membership report you can run many types of reports. One of the most useful is a report to get a count of active members. To do so:

Report Type: Expiration
Expiration Date: D To (D + 1 year)
Membership Start Date: (D - 1 year) To D
Filter by Membership Start Date: Yes/checked
Distinct Members: Yes/checked

Note: when the membership term is set to January 1st to December 31st, the report could be simplified to:

Report Type: Expiration
Expiration Date: 1/1/"Current Year" To 12/31/"Current Year"
Distinct Members: Yes/checked

Count of Expired Members

Another useful report would be the opposite of a count of active members, which is a count of expired members. To do so:

Report Type: Expiration
Expiration Date: (D - 1 year) TO (D - 1 day)
Filter by Membership Start Date: No/unchecked
Distinct Members: Yes/checked
Expired Records: Yes/checked

This works only if the membership period is one year.

Report URL​​

/assn/AssnReports.asp?clAssnRpt_ReportType=24