Concatenate First and Last Value in a Group in Crystal Reports
I am grouping a report by Trip # which have Legs (not all trips have the same number of legs). I would like to show the Origin of Leg 1 of a trip and the Origin of the last leg of a trip in the Trip # header. Any ideas? Here's what the data looks like (roughly):
Leg 1 CA OR
Leg 2 OR WA
Leg 3 WA CA
I would like the Trip #3583 to read CA to WA (origin of first leg and origin of last leg).
Any help would be greatly appreciated.
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst