Open Source Church/Data and Reports

From the top menu, selecting Data/Report --> Query Menu, you can run the following Queries:

    Advanced Search:
    Search anywhere in the Name, City, State, Zip, Home Phone, Email, or Work Email string.
    Birthdays:
    Birthdays of Persons in a given month
    CustomSearch:
    Find people with a custom field value
    Households to be surveyed:
    People in households that are good for taking surveys.
    Count of family members:
    Returns each household and the total number of people assigned to it.
    Family Pledge by Fiscal Year:
    Commitment summary by family name for each fund for the selected fiscal year
    Membership anniversaries:
    Members who joined in a particular month
    Missing people:
    Find people who didn't attend an event
    Missing tasks:
    Find people who have pledged a commitment in one year but not another
    People by age:
    Returns any person record with ages between two dates.
    Persons per property:
    Returns records of people who have been given the specified property.
    People by role and gender:
    Select the records of people with the specified family role and gender.
    Commitment Comparison:
    Compare commitments between two fiscal years
    Recent friends:
    Friends who signed up in the previous months
    Registered students:
    Find registered students
    Select all members:
    People who are members
    Select database users:
    Persons registered as database users
    Total by gender:
    Total records matching a given gender.
    Volunteers:
    Find volunteers for a particular opportunity
    Volunteers:
    Find volunteers who match two specific opportunity codes