- There should be a group for the constituent record (ex: Constituent ID or Constituent Sort Key)
- 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
- 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
- Right-click on Details and select Section Expert
- Click X+2 next to Suppress (No Drill-Down)
- Enter the formula: {#RecordCount} > x
- Where x is the number of gifts/events/actions that you want to see for each constituent
- Click Save and Close
- Click OK
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.