I have a report :
Order # CAA PBP Amt.
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.