Totals On Each Page 2

[wameri]

Somebody pls help. am new to crystal 9 and what i want is to print TOTAL in each page footer. The data is from Access 2000 database. eg

1. Mr XYZ 200
2. Mr. WXY 200
. 500
. 300
. 100
PAGE1 FOOTER TOTAL 1300

36. Mr. GTF 200
37. GFFG 100
.
PAge2 FOOTER TOTAL 300

GRAND TOTAL 1600

 

[Katy44]

Choose to insert a summary field, pick the numeric field, and select to SUM this. It will then put the field in the report footer. Copy it also into the page footer.
Hope this works.

 

[Katy44]

Choose Insert - summary, pick the field that you want to sum and check that the summary function is set to SUM. This should put the total in the report footer. Copy the field then into the page footer.

Hoe this helps

 

[Katy44]

Sorry about that! I have no idea what is going on this morning

 

[vidru]

For the grand total, you can do as Katy44 suggested. For the page total, you'll need 3 formulas:

//@Init
// Place this formula in your page header and suppress it
WhilePrintingRecords;
numberVar PFTotal := 0;

//@Accum
// Place this formula in the section containing the field to summarize and suppress it
WhilePrintingRecords;
numberVar PFTotal;
PFTotal := PFTotal + {table.field};

//@Display
// Place this formula in your page footer
WhilePrintingRecords;
numberVar PFTotal;

 

[Katy44]

I never realised that you can't just drag and drop the summary info into the page footer! Why not - surely it's got all the information needed byt the time it comes to the end of printing each page?

 

[wameri]

Thanks Katy44 but it looks like this gives the grand total.

 

[wameri]

Vidru, thanks a million. Thats just what i wanted. It works fine.

 

[vidru]

You're quite welcome.

-dave