4 Replies Latest reply on Feb 29, 2016 1:08 PM by NancyatUCM

    Sub summary report for a set date range

    NancyatUCM

      I need to print a report of donors who gave (possibly multiple times) within a specified date range. Here is a screenshot of my sub summary report in layout mode:

      Screen Shot 2016-02-26 at 1.34.34 PM.png

       

      When I sort by LastName (from Mailing List table), and key and giftdate (from Gifts table), and view in Preview mode I get a nice list of my donors in alpha order with a list of gifts they have each given (dates, amts, and reason) below each donor, a subtotal of what each gave, and a grand total at the end.  My problem is that it shows all of the gifts they have ever given, not just the date range I want.  How could I get the report to show (and total up) only gifts given between 1/13/2015 and 1/13/2016?

       

      I'm a pretty basic user, so please answer accordingly - Thanks!