Saturday, May 17, 2008
HOME

.NET Product Center SPREAD FOR .NET BUNDLE SPREAD FOR WINDOWS FORMS SPREAD FOR WEB FORMS INPUT PRO FOR WIN FORMS SUBSCRIPTIONS    SOA Center SPREAD FOR BIZTALK SERVER SPREAD FOR SHAREPOINT SERVER    COM Product Center DEVELOPER TOOLBOX DATABASE PACK SPREAD TAB PRO INPUT PRO LIST PRO CALENDAR OBJX BUTTON OBJX    Download Center TRIALS UPDATES    Purchase Center ORDER NOW GOVT / GSA LICENSE AGREEMENT WORLDWIDE RESELLERS CORPORATE DISCOUNTS WHY BUY?    Support Center TECHNICAL SUPPORT FORUM SUPPORT OPTIONS VIDEO LIBRARY    Our Company CUSTOMERS SAY... ABOUT US CONTACT US JOB OPENINGS AWARDS CASE STUDIES WHY CHOOSE FARPOINT  FarPoint Technologies  (800) 645-5913  fpsales@fpoint.com  FarPoint Europe (UK)  +44 (0) 1798 812 372  salesEurope@fpoint.com

»Spread for Web Forms » Product Tour » Grouping Grouping 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: Group By EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone Extension Photo Notes ReportsTo PhotoPath   EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone Extension Photo Notes ReportsTo PhotoPath   1 Davolio Nancy Sales Representative Ms. 12/8/1948 5/1/1992 507 - 20th Ave. E. Apt. 2A Seattle WA 98122 USA (206) 555-9857 5467     2     2 Fuller Andrew Vice President, Sales Dr. 2/19/1952 8/14/1992 908 W. Capital Way Tacoma WA 98401 USA (206) 555-9482 3457           3 Leverling Janet Sales Representative Ms. 8/30/1963 4/1/1992 722 Moss Bay Blvd. Kirkland WA 98033 USA (206) 555-3412 3355     2     4 Peacock Margaret Sales Representative Mrs. 9/19/1937 5/3/1993 4110 Old Redmond Rd. Redmond WA 98052 USA (206) 555-8122 5176     2     5 Buchanan Steven Sales Manager Mr. 3/4/1955 10/17/1993 14 Garrett Hill London   SW1 8JR UK (71) 555-4848 3453     2     6 Suyama Michael Sales Representative Mr. 7/2/1963 10/17/1993 Coventry House Miner Rd. London   EC2 7JR UK (71) 555-7773 428     5     7 King Robert Sales Representative Mr. 5/29/1960 1/2/1994 Edgeham Hollow Winchester Way London   RG1 9SP UK (71) 555-5598 465     5     8 Callahan Laura Inside Sales Coordinator Ms. 1/9/1958 3/5/1994 4726 - 11th Ave. N.E. Seattle WA 98105 USA (206) 555-1189 2344     2     9 Dodsworth Anne Sales Representative Ms. 1/27/1966 11/15/1994 7 Houndstooth Rd. London   WG2 7LT UK (71) 555-4444 452     5     18 Fuller Andrew Vice President, Sales Dr. 2/19/1952 8/14/1992 908 W. Capital Way Tacoma WA 98401 USA (206) 555-9482

Have a question? RSS Subscribe     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.