I'm fairly new at Crystal but have managed to pick up quite a bit in the past week. I've been asked to produce a fairly extensive report containing every donor to our ourganization in the past 10 years. The report is grouped by giving levels (grouped by highest annual giving over 10 years). Within each group, each individual donor is listed on a separate line with their annual giving for each of the past 10 years. At the end of the line is their cumulative giving over 10 years. I've managed to accomplish all of this, but here comes the part where I start to freeze up... At the bottom of each group is a summary of the giving for each year. Not a problem. In addition, they need total # of donors, total # of donors who gave, total # of lapsed donors, total # of new donors. If there are 10 people on the group, but only two gave ten years ago, then the count should only be two donors. If the next year, those two gave plus one more, the total # of donors should be 3 and new donors equals 1. How can I get RE to spit out these counts for me to use in a crystal report? I'd be happy to share a sample document but I'm unable to post files here. I'm in a huge time crunch soi any assistance would be EXTREMELY appreciated. Many thanks. Daniel Sloane [Email Removed] The University of the Arts

"If there are 10 people on the group, but only two gave ten years ago, then the count should only be two donors. " On the menu, select "Insert", and then select "Summary" there is a function called "Distinct Count." Distinct count counts each distinct item of the field you select, so it will give the count of 2 donors whereas plain 'ol "Count" gives the count of 10 donors. Good luck! Kimberly Yang New Directions, Inc. Los Angeles, CA (310) 268-3695 www.newdirectionsinc.org

But what if two donors give $0 and five donors give $100,000? Then my distinct count still only counts two. Daniel Sloane [Email Removed] The University of the Arts

If you want to aggregate across several groups, then the summary field "Distinct Count" should probably be placed in the Report Footer. Placing Distinct Count in the Report Footer will count all donors across all groups. Placing Distinct Count in the Group Footer will give the distinct count of donors just for that group. It also depends on how you set the report form up. Kimberly Yang New Directions, Inc. Los Angeles, CA (310) 268-3695 www.newdirectionsinc.org

Here's a link to the sample report if this helps explain things... http://www.lionsdenweb.com/sample/giving.htm  Daniel Sloane [Email Removed] The University of the Arts