Crystal Reports Cross-Tab Custom Formula

See more:

CrystalReports

Hi,

Hope this is the correct forum to post this. I am writing an application that needs to print the following report.

I am trying to build a Crystal Report in the following format using a Cross-Tab Query. Demonstrating it as Comma Seperated values.

StockCode,QtyOnHand,6,7,8,9,10,Grand Total,TO MAKE
Code1,475,,791,,,,791,316
Code2,7946,,1543,2658,,,4202,0

The report is about Jobs that gets scheduled to produce a particular product. What we trying to do is find the week each job will start at an how much is required. Therefor Code 1 needs 791 at week 7 (of the year). In stock we have 475. Now we need to know what do we need to produce of that stockcode = GrandTotal - QtyOnHand = 316.

Code 2 Requires 1543 in week 7 and 2658 in week 8. Therefore we need 4202 but we have 7946 in stock, therefore we do not require to make anything for this code.

Everything works well in a Cross-Tab in Crystal, but I dont know how to add the To Make field that will utilize the QtyOnHand and GrandTotal Fields of the Cross Tab and add it to the End Of the Report in the above format.

Hope there is a way. Thanks for your help. You guys are gr8!!!