Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost
Usage:
FieldBase, GroupBy, GroupTotals, GrandTotals, Separator, TotalPre, TotalPost
[WorkWith], GroupBy, GroupTotals, GrandTotals, Separator, TotalPre, TotalPost
FieldBase, GroupBy, GroupTotals, GrandTotals, ["(hr id=GroupSeparator)"], ["(p id=GroupTotal)"], ["(/p)"]
[WorkWith], GroupBy, GroupTotals, GrandTotals, ["(hr id=GroupSeparator)"], ["(p id=GroupTotal)"], ["(/p)"]
FieldBase, [""], [""], GrandTotals, ["(hr id=GroupSeparator)"], ["(p id=GroupTotal)"], ["(/p)"]
[WorkWith], [""], [""], GrandTotals, ["(hr id=GroupSeparator)"], ["(p id=GroupTotal)"], ["(/p)"]
Note: In the above, parenthesis are used instead of angle brackets in order to display on this page.
Description:
If using the GroupBy parameter, the Work Query should be pre-sorted by the Field specified by GroupBy.
Multiple fields may be listed, space separated, in the GroupTotals and GrandTotals parameters. The GroupTotals and GrandTotals parameters may start with a label to be displayed ahead of the resulting totals, using a | between the label to use and the list of Fields to total.
Each Field listed as a Total may have a trailing operator in [ ] that affects how the Total-Line Field should be calculated.
List of Trailing Total Field Operators:
Example:
Group "Finance.Transaction.", "Date", "Group Totals | SaleCount[&] RecvTotal[$] PayTotal[$]", "Grand Totals | SaleCount[&] RecvTotal[$] PayTotal[$]"
[New] gTotals = "Person.Alias[&] LineItem.Alias[&] LineItem.Quantity[&] LineItem.Amount[$]"
Group "GroupData", gTotals, gTotals