Home > IT Answers > Business Intelligence > Crystal Reports 8.5 iMIS 10.6 database
Mystic
15 pts.
 Crystal Reports 8.5 iMIS 10.6 database
Crystal Reports 8, Crystal Reports 8.5, iMIS, SQL Server
I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to AF_2011 after 5/1/2010 to date, but gave to no other Annual Funds (AF_2010 and below.) My results continue to include those who gave to previous Annual Funds.

Software/Hardware used:
Crystal Reports 8.5, iMIS 10.6 Windows SQL server
ASKED: January 24, 2011  3:11 PM
UPDATED: January 24, 2011  4:28 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _