Crystal Reports - Finding date where a Certain Giving Level has been reached
Posted on 2013-11-13
I am trying to get the date that a donor has reached a certain level and am not really sure how to approach it.
Here is what I have:
Date Amount Total Giving
01/26/2006 $200.00 $200.00
03/01/2007 $100.00 $300.00
07/14/2008 $200.00 $500.00
09/24/2009 $200.00 $700.00
10/29/2009 $200.00 $900.00
10/06/2011 $200.00 $1,100.00
12/04/2012 $500.00 $1,600.00
10/17/2013 $500.00 $2,100.00
The Total Giving column is a running total formula, while the Date and Amount columns come directly from the data.
What I need to do is report on the date where giving has reached the $1,000+ threshold.
How can I get the 10/06/2011 date to appear in the report footer?
This seems like a fairly simple issue, but I just can't wrap my head around how to get this information out....
Any help would be greatly appreciated.