Summary fields in Crystal Report VS2008

Question

I need to have a summary field in each page of the report and en page 2 and forward de same summary has to appear at the top of the page. Anyone know how to do this?

Ex:
> 
> Page 1
> 
> Name Value 
>  a     1 
>  b     3 
>  Total 4
> 
> Page 2 
> Name         Value 
> Total Before  4 
>  c             5 
>  d            1 
>  Total         10

Answer 1

I do not understand your question all the way.

If you need an overall summary that is repeated, you would need a sub-report that have shown in the report multiple times.

Answer 2

Create a new Running Total Field called, for example "RTotal". In "Field to summarize" select "Value", in "Type of summary" select "sum", under "Evaluate" select "For each record". You can then drag this field into your report to use as the "Total" at the bottom of each page.

You cannot use this running total field in the page header too, however, because Crystal will add the value in the first row on the page to it first (so in your example it would show 9 rather than 4 at the top of page 2). To work around this, create a formula field which subtracts the current value of the Value field from the running total (e.g. {#RTotal}-{TableName.Value}), and put this formula field in your page header.