Subreport & Main Report Calculations

[77walker]

I am running Crystal version 9 and I have a linked subreport with totals in the main that come from shared variables. Now that I have that calculation and it looks good I have realized that some of the my detail items need to have a portion of the dollar amount reduced by the dollar amount in my main report. Here is a sample of my data:


California Paint 11089

38082 1.00 46110 200.00 Original Amount of Invoice
38082 2.00 46110 200.00 Original Amount of Invoice
38082 3.00 49314 11.90 Int/Late Chg/Balance
38082 5.00 49314 13.08 Int/Late Chg/Balance
38082 1.00 49314 205.13 Int/Late Chg/Balance
38082 2.00 49314 225.38 Int/Late Chg/Balance
Total Amount 855.49 455.49 -400.00

I need to line 1 and subtract it from line 5 and come up with a new total for line 5. The problem is line 1 comes from the main report and line 5 is from the subreport. Is there a way for me to do that type of calculation within Crystal?

If anyone can help me it would be greatly appreciated.

Thank you.

LW

 

[77walker]

That worked great. Thank you for putting up with me. You are fabulous.