Navigation:  3. Working with Swordfish Windows >

Grouping data

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

See also

 

Introduction

 

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

Method

 

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

Method

 

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

Method

 

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 (www.estuarysolutions.com), All rights reserved.