Total per page on Crystal Reports 2008

[Fabrício]

Dear coleagues,

how can i create a total per page on crystal reports 2008 ?

Example:

Page 1

Materrial Value

AAAA 10

BBBB 15

CCCC 20

Total Page: 45

Page 2

Materrial Value

DDDD 5

EEEEE 6

AAAA 15

Total Page: 26

Thanks !

Fabrício

[Former Member · Accepted solution]

Hi

If you could create 'Carry Forward' and 'Brought Forward ' in your report then you can make the total for the page from them.

For the first page the Page total will be carry forward itself.

From your second page onwards you should subtract the carry forward from brought forward and there by you will get the page total.

Regards

Vivek

Edited by: viveksr on Jun 15, 2011 1:37 PM

[Former Member · Accepted solution]

Hi Try this

Place this in the Page Header section and suppress it

//@Reset

WhilePrintingRecords;

Shared NumberVar RTotal :=0;

Place this in the details section

//@RunningTotal

WhilePrintingRecords;

Shared NumberVar RTotal := RTotal + {Field to total};RTotal

Place this in the page footer section

//@Display

WhilePrintingRecords;

Shared NumberVar RTotal;

RTotal

I think this will give you Page Total

Regards

Vivek

[Former Member]

i gather you will page break the report and each page will store different information?

you can create manual running totals and place them in the page header, page footer.

MANUAL RUNNING TOTALS

RESET

The reset formula is placed in a group header report header to reset the summary to zero for each unique record it groups by.

whileprintingrecords;

Numbervar X := 0;

CALCULATION

The calculation is placed adjacent to the field or formula that is being calculated.

(if there are duplicate values; create a group on the field that is being calculated on. If there are not duplicate records, the detail section is used.

whileprintingrecords;

Numbervar X := x + ; ( or formula)

DISPLAY

The display is the sum of what is being calculated. This is placed in a group, page or report footer. (generally placed in the group footer of the group header where the reset is placed.)

whileprintingrecords;

Numbervar X;

X

[Fabrício]

Hi sharonamt,

i would like to put result on header, on footer it's ok, o try to create summary but it does not work !!!

thanks.

[Former Member]

when you use manual running totals you need to generally put them in a group

why the page header?

[Fabrício]

I would like to put this result on top of page, i have done on footer and now i am trying to put on header.

I am new in Crystal Reports, i try to do it by running total fields but i can't because i don't have a group only for this .

Thanks.