While there may be a more elegant solution for you, this is somewhat straightforward (hopefully ).
Trap the two lines showing ABC and Bus 13,224 as a detail template. Set "Trap on Line 2" and trap the word Bus. Define ABC as a field, and 13,224 as a field.
Trap your GRP line as an append template. This will add the GRP to each detail record.
Trap your Date line as a footer template. It must be a footer because it appears after the detail record in the report.
That should do it for you. Please do let us know how you make out.
Thank you for that idea!
The output I now receive is:
Grp Type Bus Date
1100 ABC 13224 1/1/2001
1100 XYZ 6850 1/1/2001
1200 ABC 12000 1/1/2001
I was trying to generate an output of:
Grp ABC XZY Date
1100 13224 6850 1/1/2001
1200 12000 <Null> 1/1/2001
Thank you for your time and assistance!