VSView Reporting Edition Reference > Field Object > Field Properties > RunningSum Property |
Returns or sets whether to show a running sum for the Field.
field.RunningSum[ = RunningSumSettings ]
You can use the RunningSum property to calculate record-by-record or group-by-group totals in a report. The RunningSum property specifies whether a calculated field on a report displays a running total and lets you set the range over which values are accumulated.
For example, you can group data by month and show the sum of each month's sales in the group footer section. You can show the running sum of accumulated sales over the entire report (sales for January in the January footer, sales for January plus February in the February footer, and so on) by adding a text box to the footer that shows the sum of sales and setting its RunningSum property to vsrSumOverAll.
The settings for the RunningSum property are described below:
Constant |
Value |
Description |
vsrNoRunningSum |
0 |
Do not treat field as a running sum. |
vsrSumOverGroup |
1 |
Calculate running sum over each group. |
vsrSumOverAll |
2 |
Calculate running sum over each the whole report. |
RunningSumSettings (Enumeration)