hi,
I need some help here.
I have a simple table with the following fields and data:
Table Name: Bundles
BdlNo T W L Qty
----- --- --- --- ---
1 1 2 7 10
1 1 2 8 10
1 1 2 9 10
2 1 2 6 10
2 1 2 7 10
2 1 2 8 10
2 1 2 9 10
2 1 2 10 10
I would like to present this data in crystal report as such (in a grid like format):
(Length, L)
BdlNo T W | 6 7 8 9 10 FT Units
----- --- ---|
1 1 2 | 10 10 10 240 1.2378
2 1 2 | 10 10 10 10 10 400 1.9232
FT and Units are formulas that calculate based on the fields, T, W, L and Qty.
i.e I would like to group up bundles that have the same thickness(T) and width(W) and show its quantity with respect to lengths.
I can't really mnake use of cross-tabs as I am not able to insert the last two columns as formulas.
Thanks.
Eric Lye
I need some help here.
I have a simple table with the following fields and data:
Table Name: Bundles
BdlNo T W L Qty
----- --- --- --- ---
1 1 2 7 10
1 1 2 8 10
1 1 2 9 10
2 1 2 6 10
2 1 2 7 10
2 1 2 8 10
2 1 2 9 10
2 1 2 10 10
I would like to present this data in crystal report as such (in a grid like format):
(Length, L)
BdlNo T W | 6 7 8 9 10 FT Units
----- --- ---|
1 1 2 | 10 10 10 240 1.2378
2 1 2 | 10 10 10 10 10 400 1.9232
FT and Units are formulas that calculate based on the fields, T, W, L and Qty.
i.e I would like to group up bundles that have the same thickness(T) and width(W) and show its quantity with respect to lengths.
I can't really mnake use of cross-tabs as I am not able to insert the last two columns as formulas.
Thanks.
Eric Lye