Hi!

I have made a Invoice.rpt in Seagate crystel report 8.5.
My Invoice holds 10 line per page

eg:
---------------------------------
sl.no   description   Rate   qty   amount
---------------------------------
1.      xxxx              xxx    xx    xxx
2.      xxxxxx           xx    xx      xx
3.      xxxxxxx         xx    xx      xx
---
---
---
---
---
---
10.     xxxxxx     xx  xx     xx
            ------
     Carryforward  1005.50 (running total)(on page footer)


Suppose a customer has taken 13 items, the next 3 items goes to 2nd page.

what i want to do is to take the carryforward field shown on the first page to 2nd page as broght forward: 1005.50
---------------------------------
sl.no   description   Rate   qty   amount
---------------------------------
                     broght forward: 1005.50
11.     xxxx            xxx   xx       xxx
12.     xxxxxx          xx   xx        xx
13.     xxxxxxx        xx   xx        xx
                                              ------
                                    total: 22300.40 (broght forwarded amount+running total of 11,12,13th item)                                 TAX:    xx.xx
                             cartage:    xx.xx
                              Grand total: 24425.90

can anybody help me how can i carryforward the field to 2nd page and add that field
with the running total of 2nd page as Grand total.

But if a customer has taken 5 items only than no carryforward only total,Tax,cartage & grand total should be shown on the first page itself.
I dont know the formula that works behind it.
Please help!


[Edited by hitech_huzefa on 29-06-2005 at 03:37 AM GMT]

You can try achieving this by adding another field (column) to data source (ado recordset), which will hold this 'sum value'. And you should display this field only on the page header section. I believe it should work.

____________________________
If you find the answer helpful, please mark this topic as solved.

quote:

---

Goran wrote:
You can try achieving this by adding another field (column) to data source (ado recordset), which will hold this 'sum value'. And you should display this field only on the page header section. I believe it should work.

---

There should be a function in crystal report that will return the number of page you are currently on, so you can check if it is > 1 to show this field.

____________________________
If you find the answer helpful, please mark this topic as solved.

I have a similar case. I am creating a Customer Ledger report using Crystal Reports 8.5 and am trying to use the running total.

My report format looks like this:
(1st page)
----------------------------------------------------------------
Date      Inv   Description   Unpaid    Dr     Cr     Bal
----------------------------------------------------------------
                                                                      xxxx
x/x/xx   111     xxxxx          xxx       xxx           xxxx
x/x/xx   234     xxxxx                              xxx   xxxx
x/x/xx   345     xxxxx          xxx       xxx           xxxx
---
---
---
---
---
---
x/x/xx   123      xxxxx          xxx       xxx           xxxx
                                                                      ---------
(Running Total = 1000.00)                                Continued
                                                                      ---------
Outstanding Balance:
0-30     31-60     61-90     Over 90
  A          B           C             D
    
(2nd page)
----------------------------------------------------------------
Date      Inv   Description   Unpaid    Dr     Cr     Bal
----------------------------------------------------------------
x/x/xx   456     xxxxx          xxx       xxx           xxxx
x/x/xx   369     xxxxx                              xxx   xxxx
x/x/xx   678     xxxxx          xxx       xxx           xxxx
x/x/xx   680     xxxxx          xxx       xxx           xxxx
                                                                      ---------
(Total in this page = 200.00)                             1200.00
                                                                      ---------
Outstanding Balance:
0-30     31-60     61-90     Over 90
  A          B           C             D


On 1st page, I want to display the word "Continued" if there are more pages but Total up the Running Total on 1st page with 2nd page and forth until end of report. I also want to Total up all the Unpaid field (from all pages) as values A, B, C and D which will display in every page.
The running total should reset when reading Next Customer.
Can anyone help me figure out the formula? Thanks.  

From the head, you need to group report by customers, then after adding RunningTotal field you will set both Evaluate&Reset "On change of group" options...

____________________________
If you find the answer helpful, please mark this topic as solved.