slicknick515
Technical User
I have two subreports within the Details A section of main report.
Subreport 1 has a shared variable named MyTotal
Subreport 2 has two shared variables named MyTotal2 and MyTotal2a
On the main report, I have the formulas below->
@MainFormula
Whileprintingrecords;
Shared NumberVar myTotal;
myTotal
@MainFormula2
Whileprintingrecords;
Shared NumberVar myTotal2;
myTotal2
@MainFormula2a
Whileprintingrecords;
Shared NumberVar myTotal2a;
myTotal2a * -1
@Project1
{Current_Inventory} + {@MainFormula2} + {@MainFormula2a}
@Project2
{@MainFormula} - {@Project1}
(This is in my group footer and is working great)
@Cost
{Cost} * {@Project2}
The issue is that i want a Grand Total Cost...that is where I am lost!
Any suggestions?
Subreport 1 has a shared variable named MyTotal
Subreport 2 has two shared variables named MyTotal2 and MyTotal2a
On the main report, I have the formulas below->
@MainFormula
Whileprintingrecords;
Shared NumberVar myTotal;
myTotal
@MainFormula2
Whileprintingrecords;
Shared NumberVar myTotal2;
myTotal2
@MainFormula2a
Whileprintingrecords;
Shared NumberVar myTotal2a;
myTotal2a * -1
@Project1
{Current_Inventory} + {@MainFormula2} + {@MainFormula2a}
@Project2
{@MainFormula} - {@Project1}
(This is in my group footer and is working great)
@Cost
{Cost} * {@Project2}
The issue is that i want a Grand Total Cost...that is where I am lost!
Any suggestions?