We have a report that will pick donors which meet certain requirements. We have a mandatory and 5 groups. When I run it all groups work except the last.
|Select all Corebio where the Id from the Basic data page is greater than '0'|
|and where the Constituent from the Gifts page is not equal to 'Chapter'|
|and where the Amount from the Gifts page is greater than or equal to '1000.00'|
I keep getting donors with less than $1,000.00. Part of them were pledge payments so I tried adding that to the criteria but they still pulled so I used the select expert in Crystal to remove Pledge Payments, however, I still get Gift Transactions from people who gave less.
Any help is most appreciated. I've tried several things to no avail.