I'm very new to Crysal Reports and need some help. I'm trying to create a report that consists of the following from the invmaster and invprice so that the report should have the columns in this order:

altkey2, stockcode, discription, longdiscription, altkey1, pricecode(A), sellingprice, pricecode(R), sellingprice

The problem I'm running into is that when I set the first pricecode to equal A the second pricecode changes to A also. I was able to make it so the pricecode would alternate between A and R by rows, but I need them to be in their own column. Any help would be great!

Thanks,

Brad