Topics

Given X Times

Created: 11/07/2017Updated: 11/08/2017


The Given X Times lists the donors who have given over a certain number of gifts based on the date range, funds and people you select.

To run this report:

  1. Expand the Contributions menu.
  2. Click on Reports.
  3. Click Given X Times on the left sidebar.
  4. From the criteria tab, select the date range that you wish for this report.
  5. Next enter the number of times you are searching for. The report will search for those folks who have given at least that many times over the date range.
  6. Next under the Who tab, select the donors you wish to see on the report. Do you wish to see all donors, or certain associations or certain groups, etc.? Once you’ve chosen who, click on the What tab. From here, select the funds you wish to consider for this report.
  7. Click on the Columns tab. Choose the columns you wish to view on the report. There are default fields already set up for this report, but you can drag additional fields from the left side to the Selected column. You can rearrange the ordering in the Selected column by dragging and dropping in the order you wish to see them in the report.
  8. If you’d like to change the sort order, move the columns from the Selected column to the Sort column.
  9. Click GENERATE.

givenxtimesgif

As an example, lets say we’d like to view people who have given at least 6 times this year. We want to evaluate everyone in the database and we want to consider giving to all funds.

  1. Highlight Given X times on the left sidebar.
  2. From the Criteria tab, select “This Year” from the date range drop down.
  3. Enter 6 as the Times.
  4. Click on the Who tab. Leave “Everyone” selected.
  5. Mark the box for Combine Families if you want contributions from families lumped together. givenxtimescriteria
  6. Click on the What tab. Click the double arrow to move all funds to the Selected column.
  7. Mark the box to include non-cash gifts if you want to include property gift amounts in the report as well.
  8. Click on the Columns tab. Drag the address, city, and state fields from the left side column to the Selected column on the report. givenxtimes columns
  9. Click GENERATE to produce the report.

On the right side of the Report Output Window are actions that can be performed for the report. givenxtimesreport

  1. Click on PAGE SETUP to set your printer and paper size and orientation.
  2. Click on PREVIEW to preview the output. Do not send the report to the printer from this preview window, it will only send the first page to the printer.
  3. To change fonts, column sizes etc., click CUSTOMIZE. The report will be displayed in 4D View, Roll Call’s spreadsheet program. Make your modifications here.
  4. Click on PRINT to send the report to the printer.
  5. Click ZOOM IN to make the font in the report larger on your screen.
  6. Click ZOOM OUT to make the report font smaller on your screen.
  7. To save the report as a tab delimited file or html document, click SAVE. Enter the location and name of the file to be saved.
  8. Click SAVE SET to save the list of people for use later within Roll Call.
  9. Click CREATE LABELS to create address labels (3 across 10 down size) for this list of people.
  10. Click WRITE LETTER, to compose a mail merge letter to this list of people.
  11. Click EMAIL to send an email to this list people or to email the report to another individual. If you choose Email people, it will send the email to everyone listed in the report.

Was this page helpful?