Question about output

[sahernandez]

Hi, I have this table in ORACLE

Field0 Field1 Field2 Field5 Discount Field7
A Dis $10 $0 $10 "Discount for!!"
B N/A $5 $0 $0
C Dis $5 $0 $25 "Discount for++"





I want to view this report like this

Field0 FIELD1 Field2 Field5
A Dis $10 $0
B N/a $5 $0
C Dis $5 $0
___ ____
$20 $0
_______ ________


// as a comment I like to see

A. Discount fot!! = $10
c. Discount for++ = $25


How can I do this with CR9 , this is the crystal that is part of VB.NET.
Now I'll try to use the while loop for each group, but I don't know if this is the best way to do it.

Thxs for the Help

 

[lbass]

It's not really clear what your fields are, but if I understand correctly, you could insert a crosstab in the report footer (or group footer, if you have a higher order group) which uses {table.field7} as the row and {table.discount} as the summary. For fields 2 and 5 in the main report, you can right click on the fields and insert summaries (sums).

-LB