Page tree

You can select which records to include in your report. In the Reports wizard, the Selection window displays tabs that relate to the report you selected. On the tabs, you can select a group of records based on certain conditions.

You can sort your data and include active/inactive records in your report.
  

Additional Field Information

Sortation
You can determine the order of the printed report data. The available options change depending on the type of report you select. Print options also display in the Sortation section if they pertain to the selected report.

Email the Letter/Item If
Email the letter/item to ministers instead of printing a copy for regular mail. Also select one of the following options:

  • To include ministers whose Pref. check box is selected in the Contact Information window, select Preferred is Checked.
  • To email to ministers who have email addresses entered, select Has an Email Addr.

Useful Information

This check box is saved per report and is not part of the saved selection. The options default to the same options you selected last time you ran the report.

Send to Multiple Emails
If you're emailing the letters/items, you can send them to multiple emails. If selected, the letter/item is sent to all the email addresses in the minister's Contact Information window. If cleared, the letter/item is only sent to the preferred email address (if you selected Preferred is Checked) or the first email address in the list (if you selected Has an Email Addr).

Useful Information

This check box is also saved per report and isn't in the saved selection.

Select which ministers to include in your report.

To include minister records

  1. On the selection tab, select one of the following options:
    • Include ALL Ministers
    • Include Ministers with ID
    • Include ANY of the following Ministers
  2. If you select to include ministers with certain ID numbers, enter the ID number(s).

    Tip

    Separate IDs using a comma, such as 1, 2, 10, 30, 100. You can also enter a series of IDs separated by a colon, such as 30:100.

  3. If you select to include ANY of the ministers, select each record you want to include.
  4. To locate a minister quickly, click Quick Lookup.
  5. To view the report with the selections you've made, click Preview.
  6. If you plan to use these report criteria in the future, click Save.

 

Select which mass records to include in your report.

To include mass records

  1. On the Mass selection tab, select one of the following options:
    • Include ALL Masses
    • Include ANY of the following Masses
  2. If you select to include ANY of the masses, select each record you want to include.
  3. To locate a mass quickly, click Quick Lookup.
  4. To view the report with the selections you've made, click Preview.
  5. If you plan to use these report criteria in the future, click Save.

 

Use the Additional Selections tab to create a specific set of criteria for a report. The fields and values available depend on the type of report being run. You can use the selections on this tab to filter your list of report criteria to a very specific level, for example:

  • Ministers who last served between June 1 and June 7
  • Ministers commissioned as lectors or Eucharistic ministers
  • Ministers whose ZIP Code starts with "85"
  • Ministers who served as lectors on a specific date

Practice using the Additional Selections tab to learn more about how to use it efficiently. Right-click field names to see a description.

  

 View information about conditional relations.

Useful Information

Some relationships are not available for certain fields such as remarks.

  • Is equal to — Field = Value. Ex: Fam City is equal to Phoenix.
  • Is not equal to — Field ≠ Value. Ex: Fam State is not equal to Arizona. This relationship is useful when you want everything other than a specific value.
  • Is less than — Field < Value. Ex: Fam ID/Env Number is less than 3000.
  • Is less than or equal to — Field ≤ Value. Ex: Famy ID/Env Number is less than or equal to 3000.
  • Greater than — Field > Value. Ex: Fam ID/Env Number is greater than 3000.
  • Greater than or equal to — Field ≥ Value. Ex: Fam ID/Env Number is greater than or equal to 3000.
  • Is in list — The field is within a list of values. Each value must be in quotation marks and separated by commas. Ex: Fam City is in list "Phoenix", "Glendale".
  • Is not in this list — The field is not within a list of values. Each value must be in quotation marks and separated by commas.
  • Starts with — The field has the same beginning character or characters as the value in question. Ex: Fam Name starts with A.
  • Does not start with — The field has a different beginning character or characters than the value in question. Ex: Fam Zip does not start with 85.
  • Contains — The field includes the value. Ex: Fam E-Mail contains "hotmail". This returns a list of all family email addresses that include the word "hotmail."
  • Is not between — The field falls outside of two values. Ex: Fam ID/Env Number is not between 300 and 800.
  • Is between — The field falls between two values. Ex: Fam ID/Env Number is between 300 and 800.
  • Is ever equal to — The value in the field is equal to at least one of the fields entered. You could, for example, enter three conditions: Ministry is ever equal to Choir, Ministry is ever equal to Hospitality, and Ministry is ever equal to Baby Sitting. When you run the report, if Ministry is ever equal to Choir, Hospitality, or Baby Sitting, the member’s name is included in the report.
  • Is never equal to — The value in the field is not equal to one at least one of multiple fields entered. You could, for example, enter two conditions: Sac. Confirmation is never equal to Yes, and Sac. Confirmation is never equal to Approximate. When you run the report, if Sac. Confirmation is never equal to Yes or Approximate, the member’s name is included in the report.
 View information about the numbered button menu items.

As you add conditions on the Additional Selections tab, a numbered button displays beside the statement. When you click the numbered oval , the following options are available:

  • Add Condition — Adds a new field, relation, and value for your condition line.
  • Add Sub-section — Adds a new set of criteria to be considered as a group. Condition statements within the subsection are evaluated, in order, before condition statements outside of the subsection.
  • Enable/Disable Row — Condition lines can be turned on and off without being deleted. This way, you can test conditions and combinations more quickly. Any disabled rows are considered when the report is run. Disabled rows are gray.

   

Additional Field Information

Clear Additional Selections
Removes all condition lines.

Exclude rather than include selected records
When selected, the main condition phrase at the top of this window changes from Choose records to Exclude records. All items that match the given conditions are excluded, and the rest are printed.

Use Optimizer
In most cases, to improve the speed with which PDS searches for records that match the conditions you set, select Use Optimizer.