Printable View
Hi,
I have a table of bills.
I need to calucate total amount i got for a month
this runs for many pages...
i need to print total amount in every page
( i mite not know how many pages the report will run and how many records each page will contain)
then the grand total in the last page.
how can i do it
thanks in advance
i couldnt understand what you wanted, did you want the total number of bills printed on every page?
If I think what you want is correct, you need to use a RunningTotal.
From the Insert Menu select the first option - Database Field. This brings up the different items you can add to your report. Choose the Running Totals item to bring up its dialog box. Set the proper values for your situation. Then add the new running total field to your page footer.
Hi
Let me be clear.
I want a report like the below
PAGE 1.
BillNo Amount
1 5
2 5
3 20
4 10
________________
Total Amt in this page=40
Page 2.
BillNo Amount
5 15
6 105
________________
Total Amt in this page=120
Grand Totat =160
Image a page can accomodate only 4 records and i have 6 records.
I need report like the above,Total of Amount in every page and Grand Total in the last page.
If only 3 records are present the both page total and grand total will be same..
If i have 10 records then 3 pages of report with 4 records in 2 pages and 2 records in 3rd page would be the output.
all i need is total of amount at the end of every page
Hope u people got it.
Please help me out
Put a running total in the PAGE footer... set the running total to reset on each new page.
Then add a Running Total in the Report Footer... this will give a grand total....
Oops...
I dont know how to make the Running Total reset for every new page.
I am not able to add the Special field 'Page Number' , in the On Change Of Field combo box.
I get errors.
Please help me.
How to reset Running Total every new page
Thanks in Advance
-KaviMegam
It doesn't look like you can reset a running total after every page, at least I could not find a way. The good news is that you can do what you want using a 3 formulas and 1 running total.
First - Create a running total that Never resets. This will be used for your Grand Total amount at the end of the report.
Second - Search in your Crystal Report Help File for this topic
"Creating running totals using a formula". While it does not describe exactly what you want, I followed its instructions and managed to get a report that prints page totals.
For your type of report, these are the changes I implemented that were different (but necessary) from the help file.
Move the AmountReset formula in the PageHeader (not Group Header as described in the help topic).
Place the AmountDisplay formula in the PageFooter.
hi,
I am not able to get any help in the topic suggested by u.
Can u please guide me to get the soln.
Thanks
kavimegam