cancel
Showing results for 
Search instead for 
Did you mean: 

Can I display detail row as column format which is aligned vertically?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I think I should make my new question more clearly:

Actually I would like to make my crosstab as below because I would like to add some formula fields into it.

Dtl* fields are DB column field; Fml* are formula fields and would possibly refer to other Dtl* fields

Group A | Group B

DtlA FmlA | DtlA FmlA

DtlB <empty> | DtlB

DtlC FmlC | DtlC FmlC

Say my example would be:

Item A | Item B

11 11 * 0.9 | 2 2 * 0.85

0.9 | 0.85

pcs 11 pcs | box 2 box

Former Member
0 Kudos

Yes, you are right.

I haven't "figure out" that before.

But now I have a question,

Is it possible to make one group in the crosstab has several column under it?

Group A | Group B

DtlA DtlB DtlC | DtlA DtlB DtlC

Say my example would be:

Item A Item B

1.1 0.9 pcs | 1.2 0.85 box

Former Member
0 Kudos

That looks exactly like a Cross-Tab to me, I dont see how you are wanting it different?

Just put a text box heading next to a cross tab. Surely that is what you looking for?