Unable to export the largest gift (that is also the most recent gift)

Denise Covington

According to Blackbaud, when we export the largest gift in export and there are several of the same amount, it exports out the oldest.  I would prefer it to export out the newest largest gift.

Have any of you found any work-a-rounds?  It is for a Crystal Report.

Thanks!

Melissa Graves 2

Denise Covington:

According to Blackbaud, when we export the largest gift in export and there are several of the same amount, it exports out the oldest.  I would prefer it to export out the newest largest gift.

Have any of you found any work-a-rounds?  It is for a Crystal Report.

Thanks!

I do not know how to override this. Are you sure you want the most recent? I think the oldest is most appropriate since that would tell you when they first hit that level of giving.

Joshua Bekerman bCLO bCRE

Denise Covington:

According to Blackbaud, when we export the largest gift in export and there are several of the same amount, it exports out the oldest.  I would prefer it to export out the newest largest gift.

Have any of you found any work-a-rounds?  It is for a Crystal Report.

Thanks!

 I don't know of any way to do this in RE, but it can be done in your Crystal Report.  You would have to export all applicable gifts and then, using formula fields, have the report only show the maximum gift date and gift amount.