Hi there
I am using Crystal 8.5 off a clipper database
I am trying to build a report that shows the last time a donantion was received from donors... then group that information by year
So far it looks like this (grouped by donor number)
{Donor Number}
{payment number} {amount} {date}
eg
123465
6543 $45.00 16/04/2003
2547 $100.00 22/03/2003
i can do a maximum ({date},{donor number}) in order to find the last donation date for each doner. the problem is then when I add a higher level of group - ie by Year it will then give the maximum donation date for each doner in that year.
The aim of my report is to show exactly when each donor last donated... NOT their last donaiton for each year.
Any ideas???
thanks
K
I am using Crystal 8.5 off a clipper database
I am trying to build a report that shows the last time a donantion was received from donors... then group that information by year
So far it looks like this (grouped by donor number)
{Donor Number}
{payment number} {amount} {date}
eg
123465
6543 $45.00 16/04/2003
2547 $100.00 22/03/2003
i can do a maximum ({date},{donor number}) in order to find the last donation date for each doner. the problem is then when I add a higher level of group - ie by Year it will then give the maximum donation date for each doner in that year.
The aim of my report is to show exactly when each donor last donated... NOT their last donaiton for each year.
Any ideas???
thanks
K