Home
SQLGridSelectedView
       Simple Grid - NorthWind Products Simple Grid - NorthWind Products
       Simple Grid with DropDown Filter Selection Simple Grid with DropDown Filter Selection
       Simple Grid with Text Search Simple Grid with Text Search
       Milti-Grid Page using Intermodule Communication Milti-Grid Page using Intermodule Communication
       Product - Editable Product - Editable
       Orders Editable with Template Orders Editable with Template
       User Selection by Field User Selection by Field
       In-Line Function MakeLink  In-Line Function MakeLink 
       Browser Breakdown Browser Breakdown
       Selection Links Selection Links
       Golf Scores from Excel Spreadsheet Golf Scores from Excel Spreadsheet
       Wait on Previous Filter Wait on Previous Filter
       Customers using UDF Split Customers using UDF Split
       Rollup Columns  Rollup Columns 
SQLChart
       Line - Orders Per Month Line - Orders Per Month
       Spline - Visitors and Views Spline - Visitors and Views
       Column - Vistors And Views Column - Vistors And Views
       Column 3D - Visitors and Views Column 3D - Visitors and Views
       Bar - Visitors and Views Bar - Visitors and Views
       Area - Vistors and Views Area - Vistors and Views
       Stacked Column - Visitors and Views Stacked Column - Visitors and Views
       Browser Breakdown Browser Breakdown
       Sales per month Sales per month
       Bot Views Bot Views
T-Minus
       Examples Examples
XMLdb
       User List User List
       Revised User List Revised User List
       NorthWind Employees NorthWind Employees
       NorthWind Customers Paging Example NorthWind Customers Paging Example
IFrame64
       Display URL Display URL
       With Parameters With Parameters
       With Parameters - Base64 Encoded With Parameters - Base64 Encoded
       With Parameters - Parameter Encrypted With Parameters - Parameter Encrypted
       With Parameters as Single Parameter With Parameters as Single Parameter
MenuLinks
       Horizontal Siblings Horizontal Siblings
       Vertical Siblings Vertical Siblings
       Parent Horizontal Parent Horizontal
       Parent Vertical Parent Vertical
       Vertical Children  Vertical Children 
       Templated Templated
ThermoChart
       Simple Thermometer
       Simple Thermometer - Square
       Simple Thermometer - No Scale
       Colorful Thermometer
       ColorFul Thermometer #2
       Guage Style
       Guage Style #2
       Fund Raising
       Fat Albert
       SQL Matrix - Percentage
SimpleQuery
       SimpleQuery - DesktopModules SimpleQuery - DesktopModules
       SimpleQuery - Products SimpleQuery - Products
       SimpleQuery - Products with Column Sort SimpleQuery - Products with Column Sort
       SimpleQuery - IMC SimpleQuery - IMC
 		SQLGridSelectedView » Rollup Columns
 
Rollup Columns  
 
 
 
This sample displays the following features:
  • Rollup Columns defines - where data the same only the first row displayed
  • Conditional CSS - "ON Change" of the CustomerID, a different CSS Class is used
  • Column Format used for Freight - right-align pad:2 currency format
Order IDCustomer IDOrder DateFreightShip NameShip AddressShip CityShip RegionShip Postal CodeShip Country
10835ALFKI15-Jan-1998 00:00:00$69.53  Alfred's FutterkisteObere Str. 57Berlin 12209Germany
1095216-Mar-1998 00:00:00$40.42  
10677ANTON22-Sep-1997 00:00:00$4.03  Antonio Moreno TaqueríaMataderos 2312México D.F. 05023Mexico
10453AROUT21-Feb-1997 00:00:00$25.36  Around the HornBrook Farm Stratford St. MaryColchesterEssexCO7 6JXUK
1055804-Jun-1997 00:00:00$72.97  
1074317-Nov-1997 00:00:00$23.72  
10524BERGS01-May-1997 00:00:00$244.79  Berglunds snabbköpBerguvsvägen 8Luleå S-958 22Sweden
1062611-Aug-1997 00:00:00$138.69  
1068901-Oct-1997 00:00:00$13.42  
1073307-Nov-1997 00:00:00$110.11  
10340BONAP29-Oct-1996 00:00:00$166.31  Bon app'12, rue des BouchersMarseille 13008France
1052502-May-1997 00:00:00$11.06  
1082712-Jan-1998 00:00:00$63.54  
10975BOTTM25-Mar-1998 00:00:00$32.27  Bottom-Dollar Markets23 Tsawassen Blvd.TsawassenBCT2F 8M4Canada
1102716-Apr-1998 00:00:00$52.52  
11023BSBEV14-Apr-1998 00:00:00$123.83  B's BeveragesFauntleroy CircusLondon EC2 5NTUK
10746CHOPS19-Nov-1997 00:00:00$31.43  Chop-suey ChineseHauptstr. 31Bern 3012Switzerland
10969COMMI23-Mar-1998 00:00:00$0.21  Comércio MineiroAv. dos Lusíadas, 23Sao PauloSP05432-043Brazil
10825DRACD09-Jan-1998 00:00:00$79.25  Drachenblut DelikatessenWalserweg 21Aachen 52066Germany
1106704-May-1998 00:00:00$7.98  
 
 
 
 
 
 
 
 
  Copyright 2009 by TressleWorks