Navigation:  3. Working with Swordfish Windows >

Grouping data

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

See also




Swordfish windows has powerful grouping functionality allowing the user to display the window's data in almost any number of ways.


Click to Expand/CollapseGrouping Data



Click and drag the column heading that you wish to group the information by into the area of the window marked 'Drag a column header here to group by that column'. In the image below the 'Instr' (instrument) column header is being dragged to this area:

Drag Column


Drop the column heading in the marked area:


Release Column


The data is now sorted into groups according to instrument code. Furthermore, each group has a minus sign next to it, allowing you to expand or collapse groups. In the image below, the one group is expanded, whilst the others are collapsed:


Expanded Group



Click to Expand/CollapseDe-Grouping Data



To de-group grouped data, simply drag the column header from the grouping area and drop it anywhere inside the window's data area:

Ungroup dragged


Click to Expand/CollapseMulti-level grouping



More than one column header can be dragged into the grouping area to create nested groups. The column headers will display the hierarchy according to how the data is grouped. It is also possible to drag the column headers within the grouping area of the window in order to change the grouping order.


Multi Grouped

The user has the option of not showing the default grouping row. Right-click on the window and click on the checked Grouping Row.

Grouping Row


The image below displays the Grouping row removed:


Grouping Row Off




See also


Sorting data

Animated demonstration of designing Swordfish windows, grouping and sorting


©Estuary Solutions (, All rights reserved.