C# - CrystalReports serious prob

[EFileTahi-A]

Hi to all...

 

How can I sum numeric fields per page? That is, the sum will be reset for every page. Yet, how can I then show the sum of all the sums done in every page on the last page?, And making it show some new visual like with some lines textboxes etc..?

 

page1:
-------------------------
col1    col2    col3
100     50      10
100     50      20
100     50      10
50      100     10

350     250     50   Total
-------------------------

page2:
-------------------------
col1    col2    col3
100     50      10
100     50      20
100     100     20
100     100     10

400     300     60   Total
-------------------------

page3: (Last page, with modified visual)
-------------------------
col1    col2    col3
100     100     10
50      50      20
100     50      10
50      100     0

*******************
1100    850     140    Total of all pages (including page 3)
*******************

 

I know how to perform sums... but only for total pages...

Edited March 2, 2005 by EFileTahi-A

[EFileTahi-A]

As always, if I did not got explicit enough let me know about it...

[pendragon]

EFileTahi-A you are going to love this one.

 

I have been trying to do this for ages and finally found a solution.

 

Don't know if there is another way to do this so if anyone else can suggest something I would also like to know.

 

What you need to do is create 3 formula's, one to be the running total, one to clear it and one to display it. I got this out of a book I have found.

 

Running total Formula (This needs to go in your details section, I Suppressed it)

 

WhilePrintingRecords;
CurrencyVar Amount;
Amount := Amount + {Your Field};

 

Clear total Formula (This needs to go in the page header section, again it is suppressed)

 

WhilePrintingRecords;
CurrencyVar Amount := 0;

 

Display total Formula (This goes in the page footer)

 

WhilePrintingRecords;
CurrencyVar Amount;

 

I have the running totals for the report printed in the report footer, the problem with this is that you get a page total and a running total on the last page.

 

Hopes this helps