Reports and Queries

Reports and Queries

ChurchCRM provides built-in reports and database queries to help you extract and analyze your church data.

---

Overview

Type	Purpose
Reports	Pre-formatted documents ready for printing (directories, labels, letters)
Queries	Database searches that return lists of people or families

Tip: Many query results can be added to the Cart for further processing.

---

Built-in Reports

Contact & Directory Reports

• Contact Lists - Phone and email lists
• People Directory - Printable directory grouped by family
• Letters and Mailing Labels - For postal mailings

Membership Reports

• Birthdays - Members with birthdays in a specific month
• Membership Anniversaries - People who joined in a specific month
• Family Member Count - Families with their member totals
• Person by Age - People within a specified age range
• Person by Properties - People with specific properties assigned
• Person by Role and Gender - Filter by family role and gender
• Person Count - Total counts by various criteria
• Total By Gender - Gender statistics

Group Reports

• Reports on Groups and Roles - Group membership details
• Class Students - Students in a specific Sunday School class
• Class Teachers - Teachers for a specific class
• Registered Students - All enrolled students

Other 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".