Tuesday, August 19, 2008  



 FarPoint Technologies
 (800) 645-5913

 fpsales@fpoint.com



     
 »Spread for Web Forms » Product Tour » Grouping

Previous Grouping Next

You can set up the display to allow Outlook-style grouping of rows. For large amounts of data, this is helpful to display the data in the order the user needs. The user selects columns by which to sort and the component then organizes and displays the data in a hierarchy with rows organized accordingly. 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 that column into the grouping bar at the top of the page.

You can provide grouping to allow users to sort the data with multiple levels of groups by dragging additional column headers into the grouping area. You can set up the display so that the items are shown initially all expanded or all collapsed when grouping is performed. You can 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
 1DavolioNancySales RepresentativeMs.12/8/19485/1/1992507 - 20th Ave. E. Apt. 2ASeattleWA98122USA(206) 555-98575467  2 
 2FullerAndrewVice President, SalesDr.2/19/19528/14/1992908 W. Capital WayTacomaWA98401USA(206) 555-94823457    
 3LeverlingJanetSales RepresentativeMs.8/30/19634/1/1992722 Moss Bay Blvd.KirklandWA98033USA(206) 555-34123355  2 
 4PeacockMargaretSales RepresentativeMrs.9/19/19375/3/19934110 Old Redmond Rd.RedmondWA98052USA(206) 555-81225176  2 
 5BuchananStevenSales ManagerMr.3/4/195510/17/199314 Garrett HillLondon SW1 8JRUK(71) 555-48483453  2 
 6SuyamaMichaelSales RepresentativeMr.7/2/196310/17/1993Coventry House Miner Rd.London EC2 7JRUK(71) 555-7773428  5 
 7KingRobertSales RepresentativeMr.5/29/19601/2/1994Edgeham Hollow Winchester WayLondon RG1 9SPUK(71) 555-5598465  5 
 8CallahanLauraInside Sales CoordinatorMs.1/9/19583/5/19944726 - 11th Ave. N.E.SeattleWA98105USA(206) 555-11892344  2 
 9DodsworthAnneSales RepresentativeMs.1/27/196611/15/19947 Houndstooth Rd.London WG2 7LTUK(71) 555-4444452  5 
 18FullerAndrewVice President, SalesDr.2/19/19528/14/1992908 W. Capital WayTacomaWA98401USA(206) 555-9482     
  


    
 Have a question?
Have a Question? Ask Us!
Subscribe to the RSS feed!RSS Subscribe
 

 
Learn about the new Roadshow now!

Tour Home
AJAX Support
Cell Merging
Conditional Formatting
Customer Usability
Customization
Data Binding
Editing
Excel Compatibility
Filtering
Formulas
Frozen Rows & Columns
Grouping
Hierarchy
Import / Export
Interaction
Load on Demand
Move Columns
Object Model
Operation Modes
Optimizing
Order Entry Sample
Protect that Data
Searching
Sheets
Skins
Sorting
Spread Designer
Unbound Mode
Worksheet
Please rate tour

Copyright © 1991-2007 FarPoint Technologies, Inc. All rights reserved. All names are property of their respective owners.