I have done a Crystal Report on reasons why donor records are archived, with a group for the main reason (e.g. Goneaway, Complaint, but there are two items I would like to include but don’t know how (Blackbaud say that it can be done, but is not covered by our support contract.):
I have exported the number of donations, but merely wish to count records in each ‘reason’ group where the number is 0, or is greater than 0 - i.e. non-donors and donors.
I would like to do a cross-tab report where the columns will be the year of the Archived Attribute date, so that we can see how the different reasons relate to different years – e.g. are more or fewer people complaining now than 5 years ago?
Ann
IP Logged
