Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

assistance on north largest required pls

Status
Not open for further replies.

adnil

Technical User
Oct 29, 2003
50
GB
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.
 
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:

Code:
(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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top