1. There should be a group for the constituent record (ex: Constituent ID or Constituent Sort Key)
  2. Sort the records by date (event date, gift date, action date, etc)
    • Go to Report > Record Sort Expert (or Report > Sort Records in Crystal 8.5)
    • Select the date field
    • Change the Sort Direction to Descending (so the most recent date shows first)
    • Click OK
  3. Create a Running Total to count the records
    • From the Field Explorer, right-click on Running Total Fields and select New
    • Running Total Name: RecordCount
    • Field to summarize: Gift IDKEY or Action IDKEY or Event ID
    • Type of summary: Count
    • Evaluate: For each record
    • Reset - on change of group: Group #1 Constituent ID/Sort Key
    • Click OK
  4. Right-click on Details and select Section Expert
  5. Click X+2 next to Suppress (No Drill-Down)
  6. Enter the formula: {#RecordCount} > x
    • Where x is the number of gifts/events/actions that you want to see for each constituent
  7. Click Save and Close
  8. Click OK