Crystal Reports Need to identify old customers

Data Connectivity
Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity

Topic: Need to identify old customers

Author	Message
stevbren Newbie Joined: 20 Nov 2007 Online Status: Offline Posts: 33	Topic: Need to identify old customers Posted: 16 Mar 2009 at 5:21am
	I have been asked to provide all clients who have not done work with us in at least two years. I have customer ID number and job date entered field. Only two tables. Seems easy, but I am not getting results that are correct. How should I set this up? Thanks
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 16 Mar 2009 at 1:20pm
	If I understand you correctly, you need to get a list of customers with one or more orders over two years ago but no orders in the last two years. Correct? What version of Crystal are you using? What type of database are you using? Are you familiar with writing SQL? -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.