assistance on north largest required pls

[adnil]

we are trying to identify where a customer's project end date is the same or overlaps with the next project start date. i have used north largest to show the project start dates and it is fine. however when i use north largest on the project end date, it is showing the dates in descending order. what have i miss here?

the data is as follows:

customer name project start date project end date
customer A 1/9/2005 18/5/2009
18/5/2009 19/5/2009
19/5/2009 31/8/2010
31/8/2010 1/9/2010
1/9/2010

customer B 1/9/2003 31/8/2008
1/9/2008 3/1/2010
4/1/2010

based on what we are looking for, the report will show only customer A. how can i achieve that?

thank you.

 

[SmpTraining]

Customer A has several projects where the dates overlap, are you interested in all of them or are you only considering the most recent project?

If you want to show any that overlap, do you need to show both overlapping projects?

If so, you can conditionally suppress the project details with something like this:

(not isnull(next({project_start_date}) 
and next({project_start_date}) = {project_end_date}
and next({customer_id}) = {customer_id})
or
(not isnull(previous({project_start_date}) 
and previous({project_end_date}) = {project_start_date}
and previous({customer_id}) = {customer_id})

Steve Phillips, Crystal Reports Trainer & Consultant

http://www.smptraining.co.uk