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 to put a subtotal on each page in CR.NET?

Status
Not open for further replies.

tonylmiller

Programmer
Apr 18, 2002
16
US
I want a subtotal in the page footer on every page. I found the running totals object, but how to reset it after each page?

I am using Crystal Reports that came with VS.NET 2003.

Thanks in advance,

Tony
 
I think you need to use manual running totals to accomplish this. Create three formulas:

//{@reset} for the pageheader:
whileprintingrecords;
numbervar pagetot := 0;

//{@accumpagetot} for the detail section:
whileprintingrecords;
numbervar pagetot := pagetot + {table.amt};

//{@displpagetot} for the page footer:
whileprintingrecords;
numbervar pagetot;

-LB
 
Whoa, that looks like Greek to me. Must be Crystal syntax. Anyway, if I can copy and paste it, that's fine with me!

Thanks for the help!

Tony
 
Just replace {table.amt} with the field you are subtotaling. Otherwise, copying and pasting should work.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top