Help Making Report

[brad.wt323]

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

[jade1977]

I am assuming that the price codes are formulas, is that correct?

[brad.wt323]

The price codes are not formulas. For example, price code A is what we have set up for wholesale pricing, price code R is set to be the retail pricing.

[jade1977]

If the price codes are coming from the database, then I do not understand how they can be resetting themselves. That is why I thought they were formulas.

Your best bet would be to take some courses on building reports, or run through some tutorials online. Sorry I cannot be more help, but with such a general question it would really require having access to your database and report.