on 10-07-2008 3:32 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.