»Spread for ASP.NET  » Product Tour  » Grouping jump to:

Grouping

You can set up the display to allow Outlook-style grouping of rows. For large amounts of data, this can be helpful to display the data in the order the user needs it. To select a column by which to group and display that data, either double-click on the header of that column or click and drag the column into the grouping bar at the top of the page.
You can proviate multiple levels of groups by dragging additional column headers into the grouping area, set up the display so that the items are shown initially as expanded or collapsed or set the colors and other formatting of both the hierarchy names and the data in the rows when grouping is performed.
Drag a column header to the grouping bar or double-click a column header to begin.  Double-click a column header to begin a new group: 

 EmployeeIDLastNameFirstNameTitleTitleOfCourtesyBirthDateHireDateAddressCityRegionPostalCodeCountryHomePhoneExtensionPhotoNotesReportsToPhotoPath
 
1
DavolioNancySales RepresentativeMs.
12/7/1948
4/30/1992
507 - 20th Ave. E. Apt. 2ASeattleWA98122USA(206) 555-98575467  
2
 
 
2
FullerAndrewVice President, SalesDr.
2/18/1952
8/13/1992
908 W. Capital WayTacomaWA98401USA(206) 555-94823457  
 
 
 
3
LeverlingJanetSales RepresentativeMs.
8/29/1963
3/31/1992
722 Moss Bay Blvd.KirklandWA98033USA(206) 555-34123355  
2
 
 
4
PeacockMargaretSales RepresentativeMrs.
9/18/1937
5/2/1993
4110 Old Redmond Rd.RedmondWA98052USA(206) 555-81225176  
2
 
 
5
BuchananStevenSales ManagerMr.
3/3/1955
10/16/1993
14 Garrett HillLondon SW1 8JRUK(71) 555-48483453  
2
 
 
6
SuyamaMichaelSales RepresentativeMr.
7/1/1963
10/16/1993
Coventry House Miner Rd.London EC2 7JRUK(71) 555-7773428  
5
 
 
7
KingRobertSales RepresentativeMr.
5/28/1960
1/1/1994
Edgeham Hollow Winchester WayLondon RG1 9SPUK(71) 555-5598465  
5
 
 
8
CallahanLauraInside Sales CoordinatorMs.
1/8/1958
3/4/1994
4726 - 11th Ave. N.E.SeattleWA98105USA(206) 555-11892344  
2
 
 
9
DodsworthAnneSales RepresentativeMs.
1/26/1966
11/14/1994
7 Houndstooth Rd.London WG2 7LTUK(71) 555-4444452  
5
 
 
18
FullerAndrewVice President, SalesDr.
2/18/1952
8/13/1992
908 W. Capital WayTacomaWA98401USA(206) 555-9482