Generating and Printing a page total in Crystal Reports 8.5

I am designing a report that requires that, for each page, the sum of a specified column is to be displayed at the end of the column before going on to the next page. For each page the total displayed should be sum of the column values on that page.

There is also a requirement that the same total at the end of the page be displayed at the top of the next page.

How do I achieve this?

example:

------Page 1------------
previous page total: 0
chq_amt
100.25
50.25
58.50
20.75
20.25
current page total: 250

----Page2--------
previous page total: 250
chq_amt
10.50
18.25
100.75
20.50
50.00
current page total: 200
etc.




donalricAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Create several formulas.  I don't have CR here so the syntax may be slightly wrong.

In the report header
Name - VarDecls
whileprintingrecords;
global numbervar CurrentPageTotal := 0;
global numbervar PrevPageTotal := 0;

In the page header
Name - ResetCurrentPageTotal
whileprintingrecords;
global CurrentPageTotal := 0;
PrevPageTotal;

In the detail section (supress it)
Name - Total
whileprintingrecords;
global CurrentPageTotal := CurrentPageTotal + {Table.DatabaseField};

In the page footer
Name - SetPrevPageTotal
whileprintingrecords;
global PrevPageTotal := CurrentPageTotal;
CurrentPageTotal


Placement
Page Header
TextBox                           Formula
previous page total:  {@ResetCurrentPageTotal}

Page Footer
current page total:    {@PrevPageTotal}


mlmcc
0
 
donalricAuthor Commented:
I created the formula and placed the stuff on the page but The figures are out.

This is what I have:
//{@VarDecls} in report header
whileprintingrecords;
global numbervar CurrentPageTotal := 0;
global numbervar PrevPageTotal := 0;
// This formula is placed in the report header


//{@resetCurrentPageTotal} This is placed in the page header
whileprintingrecords;
global numbervar CurrentPageTotal := 0;
global numbervar PrevPageTotal;


//{@Total} This  is placed in the detail section
whileprintingrecords;
global numbervar CurrentPageTotal := CurrentPageTotal + {pap_impt.lodge_amt};


//{@SetPrevPageTotal} This is placed in the page footer
whileprintingrecords;
global  numbervar PrevPageTotal := global numbervar CurrentPageTotal;
global numbervar CurrentPageTotal



You said that I should put {@PrevPageTotal} in the page footer but I put {@SetPrevPageTotal} instead as I didn't create a {@PrevPageTotal} function.  could this be the problem
0
 
mlmccCommented:
No that was a typo on my part.  Good catch.

What totals are you getting?

mlmcc
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
donalricAuthor Commented:
How could I email you the report.  probable that would be the best thing.
0
 
donalricAuthor Commented:
Sorry, it was my bad.  I placed {@Total} in the wrong section.  I placed it in a group rather than in the detail section.
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Can you have Null values in your {pap_impt.lodge_amt}?

Cheers,
- Ido
0
 
mlmccCommented:
Glad I could help

mlmcc
0
All Courses

From novice to tech pro — start learning today.