What would you like to know more about?

Create and Modify Reports

Choose a predefined report or create your own, and change what's in it.

Selecting a report to run

PDS offers many ready-to-use reports that include the fields you need! Review the Reports section to find one that fits what you're looking for.
  • In PDS, click the Reports tab, and expand the categories to see the available reports. This list will be different for each PDS program.

    Example of the All Reports list in PDS Church Office showing categories like Family Reports, Financial Reports, Member Reports, and so on

  • Use the Find button to search all reports for a specific name or subject.

    Gif showing how to click the Find button, enter a term, and see the matching report names

  • Click a report to see its description and a sample of what the report might look like. When you find the report you want to run, click the Next button to start the report process.

  • Did you recently run a report and need to run it again? Recent reports show at the top of the list under Most Recently Used. Double-click a report to re-run the report process.

    Example of the Reports list showing a section at the top for "Most Recently Used" with the last five reports listed

  • Is there a report you access often? You can add it to your Favorites list, which shows when you select the Show Only * Favorite Reports option at the top of the Reports window. Locate the report, right-click it, and select Add to * Favorite Reports. To remove it from Favorites, right-click it, and select Remove from * Favorite Reports.

    Example of the Reports list showing the option for "Show Only Favorite Reports" selected at the top, and each section showing only the reports previously marked as a favorite

Copying and modifying an existing report

Before you create a new report from scratch, see if there's a similar one you can copy and modify. This is much more convenient!
  • In the Reports window, click Find to locate a similar report. Click it to see if the description and fields are similar to what you need.
  • Select the similar report, and click Copy at the bottom.

    Example showing the Select Report window with the Family Welcome Letter report selected and the Copy button highlighted at the bottom

  • Rename the copied report so that it makes sense for your purposes. Choose a Reports section that your report should be categorized under, or create a new section. Click Build to create your copy.

  • Modify the copied report to fit your needs. To do this, double-click your report in the list, and go to the Layout window. Depending on the type of report, you'll see a Modify button. For example, if you copied a letter, you'll see Modify the Body of the Letter. Click the button to make changes to your report.

    Examples of Modifying Different Types of Reports
    Letter

    Letter Layout window showing the button to Modify the Body of the Letter

    List

    Listing Layout window showing the button to Modify the List of Fields to Print

    Label

    Label Layout window showing the button to Modify the Layout of the Address Information

    Export

    Export Setup window showing the button to Modify the List of Fields to Export

  • Make any necessary changes, and save your report.

  • For more options on changing how your report looks, see Customize Reports.

Creating or adding a new report

If you can't find or modify a PDS report to suit your needs, create a new one.
  • In the Reports window, click Add, and select the type of report you want.

    Example showing the Add Report dialog box that displays when you click the Add button, with options to create a List, Letter/Email/Text, Label, Envelope, Form, Export, Custom Report, or an advanced report

  • Give your new report a meaningful name and description. If needed, select the level of access other users can have to this report. (You won't see this option if you don't have users set up in PDS.) Select where to save the report, then click Build.

  • For some reports (like lists and exports), the List of Fields to Print dialog box displays. This is where you can define which fields to include in your report.

    Example of the List of Fields to Print dialog box that displays when you add a new list or export report with "Fields available to print" on the left and "Fields you want to print" on the right
    • Use the Find button to locate the field, then click the right arrow button square button with black arrow pointing to the right to add it to your list of fields to print. Use the up arrow square button with black arrow pointing up and down arrow square button with black arrow pointing down buttons to reorder the fields so they display exactly like you want in your report.
    • Define each field's properties to further determine what displays in your report. Choose a Position for the field to show the data either in a new column or the same column as the previous field. Edit the column's Width and Heading, if needed. To print a label in each field of the selected column, enter text for the Left Label. By default, a blank line prints after each list item, but to print the list without these, select Try to Merge Lines Together.
  • For other reports (like letters, labels, and envelopes), the Editing window displays. This is where you can write the main body of your correspondence.

    Example of the Editing <Letter Name> dialog box that displays when you add a new letter report with a text editor form and options to insert fields and other items

    • Enter your text, and use the available font and formatting options to create your report.
    • Use the Insert button to add things like images to your report. To add a web link, enter the webpage address manually (instead of copying and pasting the link from an outside source). Then, highlight the link text, and click the hyperlink icon globe behind a link chain.
  • When you're finished, save your changes. Always preview your report to make sure it looks as expected!

  • For more options on changing how your report looks, see Customize Reports.

Running a report

Once you select or create a report, each step in the process presents options that shape your report. Here's a quick understanding of each window and its purpose.
  • Report Overview – Provides information about the report. If you've run the report before, the options you selected last time display, including the printer, layout, and selections.
  • Select Printer – This is where you select your printer and set any properties for your specific printer, like duplex printing, grayscale, print quality, paper source, and so on. You can also tell the program whether to print in black and white (for reports that offer color photos), select the type of duplex printing to use, and select the paper size, source, and orientation. Make sure your printer properties and program settings match; for example, if you want to use duplex printing, ensure you select the Duplex Printing (or similarly named) option in your printer properties and select an option for Duplex in this window of your PDS program.

  • <Report Type> Layout (such as Listing Layout) – This is where you can customize your report to look exactly like you want it to. For more information on these options, see Customize Reports.

  • Select <Record Type> (such as Select Families) – This is where you tell the program which data you want to include in your report. For more information on these options, see Filter the Data in Reports.

Here are the options you have in PDS when your report is ready to run.
  • Preview and Preview Report – See what your report will look like when printed. If you click this button before defining your selections, your report will either show all of your records (if you've never run the report) or use the selections you previously defined. Use the page navigation buttons, like Next Page and Last Page, to review your entire report.
  • Print and Print Report – Print the report without seeing a preview. If you click this button before defining your selections, your report will either include all of your PDS records (if you've never run the report) or use the selections you previously defined. You have the option to print out your report on paper, or you can print to file, which saves the report on your computer.
  • Save Directly to File – Save the report as a file on your computer. You can choose from one of our supported file types, like PDF, TXT, or an Excel document.
  • Export List – Save the report as a file in a simple column format.
  • Build and Build Export – Create the report as an export file. For export reports, this replaces the Print button.
  • Start Email – Start the process for sending the letters that you chose to email instead of print.
For more information on these options, see Print, Email, and Export Report Data.
Note: Some windows and options only display for certain types of reports, so you won't see all of these for every report.

Also see our video on the basics of running reports. Click here to watch now: Watch a Video