Can I display detail row as column format which is aligned vertically?
I have some data stored in table like this:
Column: Item | FOB | Exchange Rate | UOM
Data: Item A 1.1 0.9 pcs
Item B 1.2 0.85 box
Can I display them in Crystal report like this?
Item A Item B
"FOB" 1.1 1.2
"Exg Rate" 0.9 0.85
"UOM" pcs box
The data all above are needed to shown, it's somewhat like a crosstab, but looks like not exactly.
I am wondering whether I need to create dummy resultset to make it like:
Item A, FOB, 1.1
Item A, Exg Rate, 0.9
Item A, UOM, pcs
Item B, FOB, 1.2
Item B, Exg Rate, 0.85
Item B, UOM, box