First, we need to create a query to identify the list of donors we'd like to search.For example, if you'd like to find donors who gave to the General Fund in three off the last five years, we'll first create a query to identify the General Fund donations using the steps listed at How to query on donations to a specific Fund. If you are looking for anyone who gave in consecutive years, regardless of which Fund, Campaign, or Approach they gave to, you can use Base/All Constituents as the query.

After you've created a query, we'll run the eTapestry Consecutive Years Report
  1. Click Reports
  2. Click eTapestry Standard Reports
  3. Click Consecutive Years Report
  4. Select your query category and query name from the drop down menus
  5. Select your preference for whether you'd like to search by Calendar Year or Fiscal Year
  6. Fill in the criteria that you'd like to search; for example, "find donors who have given in 3 of the past 5 years" or "find donors who have given in 3 years from 2000 to 2010"
  7. Select your preference for whether the gifts should be in consecutive years or if they could take place any time in that date range
  8. Below the Delivery Options heading, select your Report Format preference
  9. Click Submit
The resulting report will display the following columns:
Account Name- shows the donor's name
Number of Transactions- shows the number of transactions for each constituent
Received- shows the amount received from the donor in the date range that you specified in Step 6 above