cancel
Showing results for 
Search instead for 
Did you mean: 

Running totals at the footer of the report

Former Member
0 Kudos

I want to create running totals but print them not in e.g. in a group footer. All totals should be printed at the end of the report. The number of needed running totals is not defined before, it depends on the number of different grouping criterias:

Example

Criteria Amount

1995 10

1995 10

1996 20

1997 30

1997 10

...

At the end of the report shoul appear the following:

1995 20

1996 20

1997 40

There could be more criteria in the report (e.g. 1998 or 1999), but it is not defined before I start the report.

Thank you for your support

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I think it is better to insert a subreport in the report footer and insert a group on year field and place the summary in group footer. Now suppress all other sections and move the group name to the group footer so that the subreport gives the desired output like this

1995 20

1996 20

1997 40

Regards,

Raghavendra

Former Member
0 Kudos

Hi Raghavendra,

thank you very much for your solution. I think it will work as it should.

Best regards

Torsten

Former Member
0 Kudos

Hi Torsten,

If you want to create year wise running totals without considering groups, you can create like :

go in Field ExplorerRunning TotalsRight click and select New

Give the name as 1995 and select Field to summarize and select Sum as type of summary

In Evaluate select Formula and give a formula like : Year = 1995

In Reset do not reset. You get the value of 1995 year this can be placed at the end of your report.

You may have to create different funning total for different year.

Thanks,

Sastry

Former Member
0 Kudos

Hi Sastry,

thank you very much for your quick answer. The problem is, that I don't know how many years will be in my report before running the report (it depends on the selection parameters for the report). In one report I need running totals for 1994, 1995 and 2000 and in the next reports I need 1992, 1993, ...2008.

Is there a way to define these running totals in a variable way ?

Thank you for your support

Best regards

Torsten