on 12-02-2008 3:10 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.