Custom People Reports

In addition to the preset reports available on the People Screen, you can also create and print your own Custom Reports with the fields and format that you choose. The customized report formats you create will be saved for future use.

• How to Create a Custom Church Report
• Formatting the Custom Church Report
• Individual vs. family reports
• Custom Church Report - Advanced Settings

Below is how to create a custom report:

Add a New Custom Report

To begin the process of creating a custom church report...

1. Click "Setup" tab on the People screen and choose "Custom Reports"
2. Choose who to include in the report by selecting a Smart List
3. Give your custom church report a name
4. Choose the fields you want to include from the selection boxes

Click on "Advanced Report Settings" to set up your margins, orientation and the number of columns you want for your report.

Based on this information, determine what the width of each column will be.

For example, if you select half-inch margins, portrait orientation, and one column, the actual size of the column (based on an 8.5x11in paper size) will be 7.5 inches. For two columns (including a half-inch margin between columns), the size of each column will be 3.5 inches.

Now, determine if you want multiple fields on the same row or if you want each information field to have its own row.

If you have two or more columns, you may want each of the fields to have their own row (like a mailing label). To do this, make each field width equal to the size of the column width. For a three column report (based on the advanced options described above): Formal Greeting = 2.5", Address 1st line = 2.5", Address 2nd line = 2.5."

You can use this for positioning purposes or as a blank row between fields. If you insert a picture with information next to it, the picture field will take up the first inch (or however large you make it) across and down. So you will need to use blank fields to position the information fields around the picture. For a two column picture directory: Family Picture = 1", Family Name = 2.5", blank = 1", Address Line 1 = 2.5", blank = 1", Address Line 2 = 2.5", blank = 1", Email Address = 2.5"

Click on the "Generate Report" button to view the report format and then make adjustments as needed.

Reports created with individual fields (fields from the top "individual" fields section of the People Screen such as name, email, mobile phone, etc.) will print individual entries for each name in the Smart List you have selected.So each member of the family will be listed separately in the report.

Reports created with family fields (fields from the bottom "family" fields section of the People Screen such as family name, address, family picture) will print one entry per family.

For instance, you can't have one family photo with each individual's email address or cell phone. It would result in duplicating the family photo for each individual.

You can further customize your church report with the advanced settings.

Advanced Settings - "Sort By"

By default, your custom report will be sorted by Name (last, first). If you want to change the sorting field, go to the "Advanced Report Settings" screen and select a new "Sort By" field from the selection box.

For example, if you want to print a master list of envelope numbers, you would change the "Sort By" field to "Envelope Number."

Advanced Settings - "Group By"

By default, your custom report will be sorted by None. If you want to change the grouping, go to the "Advanced Report Settings" screen and select a new "Group By" field from the selection box. When this option is selected, it will give you additional options below to add certain information.

For example, if you wanted to print a list of individuals within a family, you could Group By family, as shown below.