ChurchTrac Online Church Membership Software
 Return to Support Page

Custom Reports


In addition to the preset reports and labels available on the People Screen, you can also create and print your own customized reports with the fields and format you choose. The custom report formats you create will be saved for future use as well. To create a custom report, click on the "Create a New Custom Report" button. First, choose who to include in the report by selecting a Smart List. Then type in a name for your report and select the fields you want to include from the selection boxes. You can choose from any of the regular and user-defined fields on the People Screen, including family and individual pictures (pictures should be cropped in the shape of a square to best fit the space allotted).

Formatting the Report

1.Click on "Advanced Report Settings" to set up your margins, orientation and the number columns you want for your report. advanced report settings2.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.5x11 inch 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. 3.Now determine if you want multiple fields to on the same row or if you want each information field to have its own row.

    • If you only have one column, you may want each person's information fields positioned next to each other all in a row. To do this, set each field at the approximate amount of space it takes up: Name (last, first) = 2", Address = 3", Phone Number = 1", and so on, up to 7.5" total.

sample one column report

    • If you have two or more columns, you may want the fields to each have their own row (like a mailing label). To do this, make each field width equal 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 may also want to include a field for a "Forced Line Break" to put a space between each entry.

sample three column report

    • If the width of the fields exceeds the width of the column, the field will appear on the next row.
    • If you want a blank space, create a new field, leave the "Field" selection box empty/blank, and type in the width of the blank space. You can use this for positioning purposes or as a blank row between fields. If you are inserting 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"

custom picture report4.Click on the "Open Report" button to view the report format and make adjustments as needed.

Individual vs. Family Reports

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. However, if you include an individual field in the report, the report will print the family information for each member of the family so as to include the different individual fields as well. So you may see the family name listed more than once but with a different email, or whichever individual field you included in the report.

"Sort By" Field

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

Note: If you are printing an individual report, make sure you have an individual field in your sort by field. If you are printing a family report, you will need to sort by a family field.