Back

Grouping and totaling of rows
groupLens
Group rows by this data column This Lens will order your data by a the specified column, and show a divider in the grid marking the beginning of all records in that group. You can also subTotal groups using the sumLens property. For example you have a MEMBERS table which is a list of people who are members of a club. In the table there is a field called STATE indicating what US State the user resides in. Setting `$lens->groupLens='STATE';` will produce the following if the grouping field is visible:
Alaska | Abraham | Nielson
Joseph Ahmed | Boesky
Bill | Baggins
Arkansas | Mee | Siam
Maido | Bola
Billy | Clinton
and if the grouping field is hidden:
Alaska
Abraham | Nielson
Joseph Ahmed | Boesky
Bill | Baggins
Arkansas
Mee | Siam
Maido | Bola
Billy | Clinton
To disable the error message which appears if the groupLens column is missing, set the language file class variable $txtErrGroupLens to an empty string (""). Syntax `$lens->groupLens = 'ColumnName';` Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.0]