Multiple records, select by field type, report on same line?

[oneiblnd]

Field 1 types "A thru Z".

Record 1 = Field 1 contains the value "A", Field 2 contains amount.
Record 2 = Field 1 contains the value "B", Field 2 contains amount.
Record 3 = Field 1 contains the value "C", Field 2 contains amount.
Record 4 = Field 1 contains the value "D", Field 2 contains amount.
etc...

I want a report that only reports Field 1 type "A & B" amounts on the same report line. How?

Example:

Record1 A 750
Record2 B 900
Record3 C 1000
Record4 D 500
etc.

Report
(A)price (B)price
-------- --------
$7.50 $9.00

 

[oneiblnd]

i forgot to mention I am using Crystal Report 7.0.