Cross-tab help needed
I am trying to construct an FR3 cross-tab report with a design as set out below but can not get it to work correctly.
Product Group
Location---Sales
SQty
$STot
($STotal/SQty)
Purchases--PQty
$PTot
($PTotal/PQty)
Sub-Total
(SQty-PQty)---($STol-$PTot)---($STot - $PTot)/(SQty - PQty)
Grand Total
(SQty-PQty)---($STol-$PTot)---($STot - $PTot)/(SQty - PQty)
Only the SQty, $STotal, PQty, $PTotal values are supplied in the dataset. All other cell values are to be calculated In FR3 at runtime.
My question: will FR3 allow me to produce this? I yes, then some hints please.
(Appologies for the layout formating ......)
TIA
Zane
Product Group
Location---Sales
SQty
$STot
($STotal/SQty)
Purchases--PQty
$PTot
($PTotal/PQty)
Sub-Total
(SQty-PQty)---($STol-$PTot)---($STot - $PTot)/(SQty - PQty)
Grand Total
(SQty-PQty)---($STol-$PTot)---($STot - $PTot)/(SQty - PQty)
Only the SQty, $STotal, PQty, $PTotal values are supplied in the dataset. All other cell values are to be calculated In FR3 at runtime.
My question: will FR3 allow me to produce this? I yes, then some hints please.
(Appologies for the layout formating ......)
TIA
Zane
Comments
Is this posible or not?