how to put total for page footer in crystal reports

I have designed a report in crystal report 8.5. report is in 3 pages. there is a amount field. I want to have a total of that at the end of the page. how do I do that
LVL 1
ananmananAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
You can use a summary
Right click the field
Click INSERT --> SUMMARY
Choose SUM as the type
Report footer as the location

You can then drag it to the page footer.

If you want a total for that page or the current total for all pages up to that point you need to use formulas or running totals

mlmcc
0
ananmananAuthor Commented:
cannot drag to the page footer..

So can any one help me using formula to get the total for each and every page
0
mlmccCommented:
You need to total for that page

In the page header add a formula
WhilePrintingRecords;
Global NumberVar  pageTotal;
pageTotal := 0;
''

In the detail section add a formula to do the total
WhilePrintingRecords;
Global NumberVar  pageTotal;
pageTotal := pageTotal + {YOurField};
''

In the page footer
WhilePrintingRecords;
Global NumberVar  pageTotal;
pageTotal

mlmcc
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

ananmananAuthor Commented:
ops on the detail section when I try to put that its giving an error


pageTotal <-- "No is required here"

Please help me on this
0
tickettCommented:
is {yourfield} a number?
0
ananmananAuthor Commented:
pageTotal := pageTotal + {@TOTAL};

This is where the error comes... {@TOTAL} <-- this is curruncy field

error pointing to this -->  pageTotal
0
stcindiaCommented:
Try using Running Total on that field.

Vinod
0
tickettCommented:
Try changing numberVar to currencyVar in mlmcc's solution:
You need to total for that page

In the page header add a formula
WhilePrintingRecords;
Global CurrencyVar pageTotal;
pageTotal := 0;
''

In the detail section add a formula to do the total
WhilePrintingRecords;
Global CurrencyVar pageTotal;
pageTotal := pageTotal + {YOurField};
''

In the page footer
WhilePrintingRecords;
Global CurrencyVar pageTotal;
pageTotal

Open in new window

0
ananmananAuthor Commented:
I have one more thing to clear... I have a issue when displaying the page totals...
On my report there are 55 entries. I have displayed 25 records per page. So on the 3rd page there is only 5 records. So the page total is showing at the end of the page. How can I display that page total at the end of the 5th record
0
mlmccCommented:
If it is in the page footer you can't.
A page footer is just that it appears at the end/bottom of the page.

You could use a group footer and then suppress the totals in the page footer.

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.