Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport & Main Report Calculations

Status
Not open for further replies.

77walker

Technical User
Feb 7, 2008
33
US
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
 
That worked great. Thank you for putting up with me. You are fabulous.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top