How to get "Last contribution amount" and "Last contribution date" into report?

Question

I'm needing a way to add 2 columns to contribution summary report, 1 for displaying "last contribution date" and 1 for "last contribution amount" in a CiviReport. Is there an easy way using the UI to do this? If not, is there a way to write a plain SQL query that shows up as a report?

Answer 1

The way we have approached this in the past is to install/enable the Summary Fields extension, and set that up so it calculates the Last Date and Last amount, which are then available as custom fields you can add to any report.