Crystal - Getting data from the next record

[jbarbato]

i am using crystal reports xi. i have a report that lists packages - each package has several milestones. each milestone has a date associated with it. i would like to reference the date located in the next milestone record in my report. here is what it looks like now:

Package 10
Milestone1 2/2/95
Milestone2 2/10/95
Milestone3 2/24/95
Milestone4 3/2/95

Package 12
Milestone1 2/23/95
Milestone2 2/28/95
Milestone3 3/5/95
Milestone4 3/15/95

----------------------------------------------------

what i would like it to show:

Package 10
Milestone1 -> Milestone2 2/2/95 - 2/10/95
Milestone2 -> Milestone3 2/10/95 - 2/24/95
Milestone3 -> Milestone4 2/24/95 - 3/2/95

Package 12
Milestone1 -> Milesone2 2/23/95 - 2/23/95
Milestone2 -> Milesone3 2/28/95 - 3/5/95
Milestone3 -> Milesone4 3/5/95 - 3/15/95

-----------------------------------------------------------

I am using this data to build a gantt chart, so this is definately a question about how to get the information from one record to include data from the following record.

Thank you!

 

[dgillz]

Try this:

ToText({yourDatabaseField})&" - "&ToText(Next({YourDatabaseField}))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[lbass]

I would add a clause to dgillz formula so that it begins with:

if {table.package} = next({table.package}) then//etc.

Not sure you will be able to chart on formulas using the next function though.

-LB