Program other way than sub report?

I have a report :

Order # CAA PBP Amt.

123 100.00

124

124 CAA 100.0

CAA and PBP is a transcode. Order # has row for 001 main transcode, we are not displaying this code, only the 2 shown on their display column.

I want to do as sub report but that will mess up the excel. how else to get one row per order#ut showing if the order# also has the 2 codes?

If I group on order#, I wont get the ones which has also CAA or PBP. If I group on order and code, it sorts it not the way I want.