Query is not a reporting tool - LOL Kate, RE has a a LYBUNT report format. Have you tried under Reports > Analytical Reports > LYBUNT Report?

Query is not a reporting tool - LOL Kate, RE has a a LYBUNT report format. Have you tried under Reports > Analytical Reports > LYBUNT Report?

Can anyone tell me if it is possible to add Constituent ID# as a column in the LYBUNT report? It is suprising to me that this is not a default. Thanks for any help you can give! Lisa

I am trying to run a LYBUNT report with both donor and soft credit recipients to get an accurate count of the number of donors who gave to the Annual Fund FY09 but did not give to the Annual Fund in FY10. The end result will be a mailing to those who didn't give in FY10 but gave in FY09. We have...

I do this every year and do some customized reports in excel to get the graphical representations my boss likes to see. The terminology we use is New, Renewed and Reactivated and dropped. New being a new donor in the year being analized Renewed being a donor in the year being analized and the year prior...

Oh, and packages are segments of a mailing. They could be actual variations of a letter or simply groups you want to track for analysis. I always segment my mailings by date of last gift (Current 0-12 months, LYBUNT 13-24 months, and Lapsed 25-36 months) but will also track particular groups for some...

I'm not seeing many posts on using LYBUNT & SYBUNT reports. I'm trying to determine which constituents gave to the annual fund last year, and have not yet given to this year's annual fund. I get fewer entries when I don't state a fund; more when I indicate a specific fund. It makes...

HELP! I am trying to run a list of donors who gave between 7/1/97 and 6/30/05 then DID NOT give between 7/1/05 and 6/30/07 but then DID give again between 7/1/07 and 6/30/08. I can't figure it out. I have tried queries, comparative reports, LYBUNT, SYBUNT. My problem is that I don't know how...

Which reports have you tried? I recommend you try the new donor report, Lybunt report, Sybunt report, Upgrade/Downgrade report, etc. There is also a donor giving analysis dashboard which has all of this in one report but it has flaws!!! - you can ONLY run it on a full year period such as this calendar...

An option do a summary query to pull donor whose gifts totaled $500 or over in 2006. Then you would use that query in the LYBUNT report in analytical reports which is designed to show donors gifts last year but not this. See if it gets you what you need.