Accumulate, compare, supress

[ksaab2002]

Hello,

I have a set of data based on flight segments. I want to display it grouped by passenger and firstdepart date - but -the data is organized by segments.

Like :
Pass dep date origin destination Seq#
Bob Mould 1/1/2005 Seattle Chicago 1
Bob Mould 1/1/2005 Chicago Boston 2
Bob Mould 1/7/2005 Boston Chicago 3
Bob Mould 1/7/2005 Chicago Seattle 4

What I need to come up with is a way to accumulate segments - compare and print the 1st and last segment on one grouped line..

??

Many many thanks,

KSaab

 

[lbass]

First group by {table.passenger} and then create a formula {@seq1} and place it in the detail section:

if {table.seq#} = 1 then
totext({table.departdate},"M/d/yyyy")+" "+{table.origin}+" "+{table.destination}

Then right click on {@seq1} and insert a maximum. This will appear in the group footer. Drag the passenger name and the detail fields (except {@seq1}) into the group footer. The detail fields will pick up the information from the last detail, while the summary on {@seq1} will pick up those from the first record.

-LB

 

[ksaab2002]

Thank you! Worked brilliantly! Thanks again!