using formula field in Cross-Tab report

[jen1701]

I tried to set up a cross-tab report. The report likes like this:

Component Id Job ID Bal Due On-hand Qty Shortage

876 P21 40 30 -10

The shortage was calculated by fomula. But when I try to use this formula field as column, I can't pick it from the list.
I have tried to set up the report in manual cross-tab. It is fine, but we want format like this:

Component Id, On-hand, Job1, Jobb2..., Bal Due, Shortage

I am new to Crystal reports. So if anybody can help me on this, I am very grateful.

Thanks,

Jen