Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

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:

 

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.

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