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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subtotal grouping problem

Status
Not open for further replies.

minditx

MIS
Jul 31, 2003
9
MY

hi there,

i create crystal report (ver 7) with integrate using asp. i'm using crystal report for producing quotation product based on selection formula. the problem is to get subtotal from each page? . cause i set the details go to second page if it more. so user can see every page with the same page header and page footer. but different details like continues page.and then the last page display subtotal for the page and grandtotal.

tq

 
Subtotal of what? And is this a running total of a group, the entire report, or just totals from a page?

I don't think that ver. 7 had Running Totals, so you'd need to do this yourself using variables in formulas.

Here's an example of keeping track on a page by page basis:

Page header formula:
whileprintingrecords;
numbervar PgSubTot := 0;

Details Formula:
whileprintingrecords;
numbervar PgSubTot := PgSubTot + {table.field};

Page Footer formula:
whileprintingrecords;
numbervar PgSubTot

This should provide the basis for manually aggregating data, your post was too vague to get any more specific.

-k
 

thank you synapvampire,the code it's work. actually what is i want to do as you mention "keeping track on a page by page basis" :)

thanks.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top