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!

How I get SubTotals?

Status
Not open for further replies.

joseprez

Vendor
Sep 7, 2002
19
PA
In my report in section Details I use a formula field like this:

NumberVar A := A + ..Any Calculate..

it work great and another formula field in Report Footer with this:

WhilePrintingRecords;
NumberVar A;

and it work's!

How I get SubTotals in my Group Footer #1 from formula field in section Detail
 
Create a different variable that has a reset formula:

//{@reset} to be placed in the group header:
whileprintingrecords;
numbervar B := 0;

Then add the new variable to your detail section formula:
whileprintingrecords;
NumberVar A := A + {@yourcalc};
numbervar B := B + {@yourcalc};

//{@displayB} to be placed in the group footer:
whileprintingrecords;
numbervar B;

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top