Report Totals

roberte114

I have a report that is grouped by two fields. I am trying to get a total for the entire report. It works fine for each grouping but not for a report total. The total I get is the total of the last group total and not a report total. Is there something that I'm missing?

Savatage

What section are you putting your totals in?

You can always look at a report that is working in a similar way that you would like to see how it was done there.

ie. Accounts Receivable Aging

roberte114

I'm trying to put the total in the footer section. For some reason it resets the variables for each grouping iteration.

Savatage

CREATETOTALS
Use this function to maintain totals for a variable in the same way as totals are maintained for fields by using the TotalFields property.

CREATETOTALS(Var1 [, Var2] ,...)
Var1, Var2, ...

Data type: decimal

Comments
Just like the TotalFields property, CREATETOTALS causes group and grand totals to be maintained. The totals can be printed by placing controls that have the variable or variables that are the arguments of CREATETOTALS as their source expressions in the appropriate sections: the group totals are printed in GroupFooter sections, and the grand totals are printed in Footer sections.

Example
To have the system maintain totals for the two variables Amount and Quantity, use CREATETOTALS like this:

CurrReport.CREATEOTALS(Amount, Quantity);

---

TotalFields

Use this property to indicate the fields of a data item for which the system should maintain totals. If this property is used in conjunction with the GroupTotalFields, totals can be maintained for both the groups that are defined and all records that are output; if used by itself, TotalFields will maintain totals for all records.

Applies to Data items

Settings
A comma-separated list of field names. The fields can be selected by using the assist-edit function in the Value field of this property.

Comments
The totals are printed by placing controls that have the fields that are indicated in TotalFields as their source expressions in a Footer, GroupFooter or TransFooter section of the data item.