Create an export with 20 different Gift Summary fields. Each Gift Summary field would have the appropriate fiscal-year date range as a filter. In the Crystal report each total gift amount per Class year would be represented by one of these 20 Gift Summary fields. Each year these summary fields in the Raiser's Edge export would have to have their Criteria/filters changed to accommodate any additional year summary totals and the possible removal of old year summary totals.
Connect and collaborate with fellow Blackbaud users.