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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: albertleung
- Order by date
-
Combined the continuous records into one
One record for eliminating continuous records. Actually the first Date2 is as same as the second Date1 and you will see it goes along these records. However, the blank Date2 means the person (ID: 1111111) is not done yet, so that's the final Date2 I need. And I need the very beginning Date1...- albertleung
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Combined the continuous records into one
Yes, I have changed the requirement. From the following records: ID Date1 Date2 ... 1111111 10/14/2009 11/9/2009 1111111 11/9/2009 1/11/2010 1111111 1/11/2010 (blank) 1111111 1/11/2010 1/11/2010 1111111 1/11/2010 6/9/2010 ... I only need...- albertleung
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Combined the continuous records into one
Thank you so much lbass. What if I need the multiple Date1 and Date2 for the same ID? Do I have to sort by ID, Date1, and Date2 in ascending in order to make the formula work? Original Data: ID Date1 Date2 1111111 3/16/2009 6/27/2009 1111111 8/20/2009 9/10/2009...- albertleung
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Combined the continuous records into one
Hi there, I use Crystal Reports XI. I have a question and need helps ASAP. I have to compare the records' dates to determine whether they can be combined to one record or not. For example: ID Date1 Date2 1111111 10/14/2009 11/9/2009 1111111 11/9/2009 1/11/2010 1111111...- albertleung
- Thread
- Replies: 8
- Forum: Business Objects: Crystal Reports 1 Formulas
