Custom Report Example - Family Mailing Labels w/ Phone Number

1. First you will need to define a query. Do this from the Family Mailing List module by selecting Custom Reports. If you have never created a Custom Report in this module, PowerChurch will prompt you to enter a title for your query (otherwise click on the button labeled Add). Enter a title for this query and click OK.
2. Your next step is to build a filter that will select who will show in your output. To print labels for all families: From the Pick a Field window, double click on Household Key Last Name. Next, choose Is not empty. Click Done. To print labels for selected families: From the Pick a Field window, double click on Mailing Category. Next, choose exactly matches. Finally, select the desired code such as Member. Click Done then Done again.
3. At this point you will be asked, "Do you want to run this query now?", click Yes. A dialog box will be shown that briefly describes how to use the Field Picker Dialog Box. After reading, click OK.
4. Next, select the fields that you want to print on your labels. Normally, you will select the following fields: Mailing Name, Address Line 1, City+State+Zip/Postal Code, Home Phone. To select, double click on the field name. If you would like additional fields, such as visit area, select them now. When you are finished, click Done.
5. On the query Overview Screen, you will need to check the Hide Duplicate Records box. This will prevent multiple labels from printing for the same family. You will need to uncheck the Browse Query Results box.
6. Click on the button Edit Sort Order in order to define how you want your labels sorted. Select the following fields, in order, to sort alphabetically: Household Key Last Name, Household Key First Name and Address Line 1. When you are finished, click on Done.
7. At this point, click on Run Query. PowerChurch Plus will display a screen titled Setup for Column Layout Report. Click on Edit Form.
8. You will now see the Report Designer Screen. Double click on the grey band Page Header and set the height to 0.5 inches. Do the same to the Page Footer band. Double-click on the Detail band and set it's height to 1.0 inch.
9. You will now need to direct the Custom Report Writer to print the names in columns. To do this, click on File and go to Page Setup. If you have a 20 label sheet, set the columns to 2. For 30 label sheets, set the number of columns to 3. In addition, you need to set the Print Area for this report to Whole Page. Click OK.
10. Just above the Page Footer band at the bottom of the screen, you will notice three fields; date(), page, and pageno_. Click on each field once and press the Delete key on your keyboard.
11. Now you will need to line up the fields in the detail band (just below the gray Column Header bar). You do this by clicking on the fields, holding down the left mouse button, and dragging them underneath one another.
12. Once all of these steps are completed, you can close from the Report Designer and save your changes. Do this by clicking on the File Menu and selecting Close. Start the report by clicking Start Report from the Setup for Column Layout Report Screen.