I need to have a report show a "new business user"
A new business user is identified where :
a record was ordered by them in current month(passed in via parameter )
and was not in the 12 months leading up to the current month

Report is to be run once a month.

How or can this be done with crystal reports?

Many thanks in advance!

Current Month = 03/2009

OrderUser      Date
a                    05/30/2008
a                     03/16/2009
b                     03/12/2009
c                     02/12/2009

User 'b' is a new user






Edited by sammy636 - 24 Mar 2009 at 6:19pm