First, we'll create a query to find all of the auto process gifts
  1. Click Queries
  2. Click Manage Queries
  3. Select the category where you would like to store this query
  4. Select New Query under the Tasks menu
  5. Name the query All Active Auto Process Gifts
  6. Set the Starting Query to Base/All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Under Criteria Matching select Match Each Criteria
  9. Select Journal from the Browse Fields drop down menu and click on Transaction Schedule Auto Process Status
  10. Mark the check boxes for Active and Pending Stop
  11. Click Save and View Queries

Then, we'll run a report to show the Expiration Dates
  1. Click Reports
  2. Click Manage Reports
  3. Select a category that you want to store this report in 
  4. Select New Report under the Task Menu
  5. Name the report Expiration Dates for All Active Auto Process Gifts
  6. In the Group By drop down menu, select Accounts
  7. Under the Group selection choose to Hide Group Totals
  8. Select Commonly Used Fields from the Browse Fields drop down menu and click on Account Name
  9. Select Scheduled Gift Type Fields from the Browse Fields drop down menu and click on Scheduled Credit/Debit Card Expiration Date
  10. Arrange the columns into order by clicking on the middle of the field column and dragging up or down
  11. Click Save and Run under the Task Menu
  12. Under Query select your category in the top box and your All Active Auto Process Gifts query in the bottom box
  13. At the bottom of the page select a Delivery Option and then click Submit