Reports and Queries

Reports and Queries

Reports are built-in reports that give specific reports about user information. Queries are pre-built queries on the database that return individuals/families.

Built in Reports

• Contact lists
• Reports on groups and roles
• People Directory: Printable directory of all people, grouped by family where assigned
• Letters and Mailing Labels
• Birthdays: Members with birthdays in a particular month
• Family Member Count: Returns each family and the total number of people assigned to them.
• Membership anniversaries: People who joined in a particular month
• Person by Age: Returns any person records with ages between two given ages.
• Person by properties: Returns person records which are assigned the given property.
• Person by Role and Gender: Selects person records with the family role and gender specified.
• Person Count
• Recent friends: Friends who signed up in previous months
• Select all members: People who are members
• Select database users: People who are registered as database users
• Total By Gender: Total of records matching a given gender.
• Volunteers: Find volunteers for a particular opportunity
• Volunteers: Find volunteers for who match two specific opportunity codes
• Advanced Search: Search by any part of Name, City, State, Zip, or Home Phone.
• Class & Attendance Reports

Sunday School Reports: Generate class lists and attendance sheets

• Event Attendance: Generate attendance -AND- non-attendance reports for events
• Class Students: Find students for a particular class
• Class Teachers: Find teachers for a particular class
• Registered students
• Finance Reports

Finance Reports

• Financial Reports: Pledges and Payments
• Pledge comparison: Compare pledges between two fiscal years

What is a Free-Text Query?

A Free-Text Query allows you to run any query on the database. Since ChurchCRM is based on MySQL, anyone who has knowledge of this program can run free-text queries.

What is a Cart-Enabled Query?

A Cart-Enabled Query is one in which the results of the query can be entered into the cart.

How do I use Cart-Enabled Queries?

Once a Cart-Enabled Query has been run, simply click the button entitled "Add Results to Cart".