Cross-tab help needed

zsleo

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

zsleo

Help please anyone....

Is this posible or not?

AlexTZ

You can't do this report with standard Cross-tab object, you have to use vertical bands (it's much harder, but you can show any data what you want).

zsleo

Thank you