Data Groupings

Example

Ungrouped Data
Order ID	Cust ID	Ship To	Country	City	Freight
10248	VINET	Vins et alcools Chevalier	France	Reims	$32.38
10249	TOMSP	Toms Spezialitäten	Germany	Münster	$11.61
10250	HANAR	Hanari Carnes	Brazil	Rio de Janeiro	$65.83
10251	VICTE	Victuailles en stock	France	Lyon	$41.34
10252	SUPRD	Suprêmes délices	Belgium	Charleroi	$51.30
10253	HANAR	Hanari Carnes	Brazil	Rio de Janeiro	$58.17
10254	CHOPS	Chop-suey Chinese	Switzerland	Bern	$22.98
10255	RICSU	Richter Supermarkt	Switzerland	Genève	$148.33
10256	WELLI	Wellington Importadora	Brazil	Resende	$13.97
10257	HILAA	HILARION-Abastos	Venezuela	San Cristóbal	$81.91
10258	ERNSH	Ernst Handel	Austria	Graz	$140.51
10259	CENTC	Centro comercial Moctezuma	Mexico	México D.F.	$3.25
10260	OTTIK	Ottilies Käseladen	Germany	Köln	$55.09
10261	QUEDE	Que Delícia	Brazil	Rio de Janeiro	$3.05

<DataTable ID="dtUnGrouped" AltRowClass="ThemeAlternatingRow TD" Class="ThemeAlignLeft" Width="800" WidthScale="px" Caption="Ungrouped Data" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML1" XMLFile="NW_Orders.xml" MaxRows="14" />
  <DataTableColumn ID="colOrderID" Header="Order ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblOrderID" Caption="" />
    <DataColumnSort DataColumn="OrderID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colFreight" Header="Freight" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblFreight" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="Freight" />
  </DataTableColumn>
</DataTable>

Data grouped by Customer ID and counted
Cust ID	Ship To	Country	City	# Orders
ALFKI	Alfreds Futterkiste	Germany	Berlin	6
ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	4
ANTON	Antonio Moreno Taquería	Mexico	México D.F.	7
AROUT	Around the Horn	UK	Colchester	13
BERGS	Berglunds snabbköp	Sweden	Luleå	18
BLAUS	Blauer See Delikatessen	Germany	Mannheim	7
BLONP	Blondel père et fils	France	Strasbourg	11
BOLID	Bólido Comidas preparadas	Spain	Madrid	3
BONAP	Bon app'	France	Marseille	17
BOTTM	Bottom-Dollar Markets	Canada	Tsawassen	14
BSBEV	B's Beverages	UK	London	10
CACTU	Cactus Comidas para llevar	Argentina	Buenos Aires	6
CENTC	Centro comercial Moctezuma	Mexico	México D.F.	1
CHOPS	Chop-suey Chinese	Switzerland	Bern	8

<DataTable ID="dtGroupCount" Class="ThemeAlignLeft" Width="800" WidthScale="px" Caption="Data grouped by Customer ID and counted" AltRowClass="ThemeAlternatingRow TD" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <GroupFilter GroupColumn="CustomerID" DataType="Text" IdeDisplayStatus="Collapsed">
      <GroupAggregateColumn AggregateColumn="CustomerID" AggregateFunction="Count" DataType="Text" ID="gacCustomerOrders" />
    </GroupFilter>
    <SequenceColumn ID="colSeq" />
    <ConditionFilter Condition=" &lt;= 14" />
  </DataLayer>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerTotal" Header="# Orders" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerOrders" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
</DataTable>

Data grouped by Customer ID and summed
Cust ID	Ship To	Country	City	Total
ALFKI	Alfreds Futterkiste	Germany	Berlin	$4,273.00
ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$1,402.95
ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$7,023.98
AROUT	Around the Horn	UK	Colchester	$13,390.65
BERGS	Berglunds snabbköp	Sweden	Luleå	$24,927.58
BLAUS	Blauer See Delikatessen	Germany	Mannheim	$3,239.80
BLONP	Blondel père et fils	France	Strasbourg	$18,534.08
BOLID	Bólido Comidas preparadas	Spain	Madrid	$4,232.85
BONAP	Bon app'	France	Marseille	$21,963.24
BOTTM	Bottom-Dollar Markets	Canada	Tsawassen	$20,801.61
BSBEV	B's Beverages	UK	London	$6,089.90
CACTU	Cactus Comidas para llevar	Argentina	Buenos Aires	$1,814.80
CENTC	Centro comercial Moctezuma	Mexico	México D.F.	$100.80
CHOPS	Chop-suey Chinese	Switzerland	Bern	$12,348.88

<DataTable ID="dtOrders" AltRowClass="ThemeAlternatingRow TD" Class="ThemeAlignLeft" Width="800" WidthScale="px" Caption="Data grouped by Customer ID and summed" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <Join ID="joinInner" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
      <DataLayer Type="XMLFile" ID="dlOrderSubTotalsXML" XMLFile="NW_OrderSubtotals.xml" />
    </Join>
    <GroupFilter GroupColumn="CustomerID" DataType="Text" IdeDisplayStatus="Collapsed">
      <GroupAggregateColumn AggregateColumn="Subtotal" AggregateFunction="Sum" DataType="Number" ID="gacCustomerTotal" />
    </GroupFilter>
    <SequenceColumn ID="colSeq" />
    <CompareFilter CompareType="&lt;" DataColumn="colSeq" ID="cmpRowLimit" CompareValue="15" DataType="Number" />
  </DataLayer>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerTotal" Header="Total" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerTotal" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
</DataTable>

Data grouped by Customer ID, with all rows retained
Order ID	Cust ID	Ship To	Country	City	Freight
10643	ALFKI	Alfreds Futterkiste	Germany	Berlin	$29.46
10692	ALFKI	Alfred's Futterkiste	Germany	Berlin	$61.02
10702	ALFKI	Alfred's Futterkiste	Germany	Berlin	$23.94
10835	ALFKI	Alfred's Futterkiste	Germany	Berlin	$69.53
10952	ALFKI	Alfred's Futterkiste	Germany	Berlin	$40.42
11011	ALFKI	Alfred's Futterkiste	Germany	Berlin	$1.21
10308	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$1.61
10625	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$43.90
10759	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$11.99
10926	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$39.92
10365	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$22.00
10507	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$47.45
10535	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$15.64
10573	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$84.84

<DataTable ID="dtGroupAll" AltRowClass="ThemeAlternatingRow TD" Class="ThemeAlignLeft" Width="800" WidthScale="px" Caption="Data grouped by Customer ID, with all rows retained" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <GroupFilter GroupColumn="CustomerID" KeepGroupedRows="True" DataType="Text" SortSequence="Ascending" />
    <SequenceColumn ID="colSeq" />
    <ConditionFilter Condition=" &lt;= 14" />
  </DataLayer>
  <DataTableColumn ID="colOrderID" Header="Order ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblOrderID" Caption="" />
    <DataColumnSort DataColumn="OrderID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colFreight" Header="Freight" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblFreight" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="Freight" />
  </DataTableColumn>
</DataTable>

Data grouped by Customer ID, with only distinct rows retained
Order ID	Cust ID	Ship To	Country	City	Freight
10643	ALFKI	Alfreds Futterkiste	Germany	Berlin	$29.46
10308	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$1.61
10365	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$22.00
10355	AROUT	Around the Horn	UK	Colchester	$41.95
10278	BERGS	Berglunds snabbköp	Sweden	Luleå	$92.69
10501	BLAUS	Blauer See Delikatessen	Germany	Mannheim	$8.85
10265	BLONP	Blondel père et fils	France	Strasbourg	$55.28
10326	BOLID	Bólido Comidas preparadas	Spain	Madrid	$77.92
10331	BONAP	Bon app'	France	Marseille	$10.19
10389	BOTTM	Bottom-Dollar Markets	Canada	Tsawassen	$47.42
10289	BSBEV	B's Beverages	UK	London	$22.77
10521	CACTU	Cactus Comidas para llevar	Argentina	Buenos Aires	$17.22
10259	CENTC	Centro comercial Moctezuma	Mexico	México D.F.	$3.25
10254	CHOPS	Chop-suey Chinese	Switzerland	Bern	$22.98

<DataTable ID="dtGroupDistinct" Class="ThemeAlignLeft" AltRowClass="ThemeAlternatingRow TD" Width="800" WidthScale="px" Caption="Data grouped by Customer ID, with only distinct rows retained" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <GroupFilter GroupColumn="CustomerID" DataType="Text" KeepGroupedRows="False" />
    <SequenceColumn ID="colSeq" />
    <ConditionFilter Condition=" &lt;= 14" />
  </DataLayer>
  <DataTableColumn ID="colOrderID" Header="Order ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblOrderID" Caption="" />
    <DataColumnSort DataColumn="OrderID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colFreight" Header="Freight" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblFreight" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="Freight" />
  </DataTableColumn>
</DataTable>

Data in hierarchical groupings, on Customer ID and Order ID
Cust ID	Customer Name	Customer Total	Order ID	Order Date	Order Total	Product ID	Unit Price	Quantity	Unit Total
ALFKI	Alfreds Futterkiste	$4,596.20
			10643	8/25/2011	$1,086.00
						28	$45.60	15	$684.00
						39	$18.00	21	$378.00
						46	$12.00	2	$24.00
			10692	10/3/2011	$878.00
						63	$43.90	20	$878.00
			10702	10/13/2011	$330.00
						3	$10.00	6	$60.00
						76	$18.00	15	$270.00
			10835	1/15/2012	$851.00
						59	$55.00	15	$825.00
						77	$13.00	2	$26.00
			10952	3/16/2012	$491.20
						28	$45.60	2	$91.20
						6	$25.00	16	$400.00
			11011	4/9/2012	$960.00
						58	$13.25	40	$530.00
						71	$21.50	20	$430.00
ANATR	Ana Trujillo Emparedados y helados	$1,402.95
			10308	9/18/2010	$88.80
						69	$28.80	1	$28.80
						70	$12.00	5	$60.00
			10625	8/8/2011	$479.75
						14	$23.25	3	$69.75
						42	$14.00	5	$70.00
						60	$34.00	10	$340.00
			10759	11/28/2011	$320.00
						32	$32.00	10	$320.00
			10926	3/4/2012	$514.40
						11	$21.00	2	$42.00
						13	$6.00	10	$60.00
						19	$9.20	7	$64.40
						72	$34.80	10	$348.00
ANTON	Antonio Moreno Taquería	$7,515.35
			10365	11/27/2010	$403.20
						11	$16.80	24	$403.20
			10507	4/15/2011	$881.25
						43	$46.00	15	$690.00
						48	$12.75	15	$191.25
			10535	5/13/2011	$2,156.50
						11	$21.00	50	$1,050.00
						40	$18.40	10	$184.00
						57	$19.50	5	$97.50
						59	$55.00	15	$825.00
			10573	6/19/2011	$2,082.00
						17	$39.00	18	$702.00
						34	$14.00	40	$560.00
						53	$32.80	25	$820.00
			10677	9/22/2011	$956.90
						26	$31.23	30	$936.90
						33	$2.50	8	$20.00
			10682	9/25/2011	$375.50
						33	$2.50	30	$75.00
						66	$17.00	4	$68.00
						75	$7.75	30	$232.50
			10856	1/28/2012	$660.00
						2	$19.00	20	$380.00
						42	$14.00	20	$280.00

<DataTable ID="dtGroupHierarchy" Width="800" WidthScale="px" Class="ThemeAlignLeft, ThemeTextNormal" Caption="Data in hierarchical groupings, on Customer ID and Order ID" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition="&quot;&quot; &lt; &quot;AROUT&quot;" />
    <Join ID="joinInner1" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="OrderID" RightDataColumn="OrderID" />
      <DataLayer Type="XMLFile" ID="dlOrderDetailsXML" XMLFile="NW_OrderDetails.xml" IdeDisplayStatus="Collapsed">
        <Join ID="joinInner2" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
          <MatchCondition LeftDataColumn="ProductID" RightDataColumn="ProductID" />
          <DataLayer Type="XMLFile" ID="dlProductsXML" XMLFile="NW_Products.xml" />
        </Join>
      </DataLayer>
    </Join>
    <Join ID="joinInner3" JoinType="InnerJoin" IdeDisplayStatus="Collapsed">
      <MatchCondition LeftDataColumn="CustomerID" RightDataColumn="CustomerID" />
      <DataLayer Type="XMLFile" ID="dlCustomersXML" XMLFile="NW_Customers.xml" />
    </Join>
    <CalculatedColumn Formula=" * " ID="calcUnitTotal" />
    <GroupFilter GroupColumn="CustomerID" KeepGroupedRows="True" ID="grpCustomer" IdeDisplayStatus="Collapsed">
      <GroupAggregateColumn AggregateColumn="calcUnitTotal" AggregateFunction="Sum" ID="gacCustomerTotal" DataType="Number" />
      <GroupFilter GroupColumn="OrderID" KeepGroupedRows="True" ID="grpOrder" IdeDisplayStatus="Collapsed">
        <GroupAggregateColumn AggregateColumn="calcUnitTotal" AggregateFunction="Sum" ID="gacOrderTotal" DataType="Number" />
      </GroupFilter>
    </GroupFilter>
  </DataLayer>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" Width="54" WidthScale="px" IdeDisplayStatus="Collapsed">
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerName" Header="Customer Name" IdeDisplayStatus="Collapsed">
    <DataColumnSort DataColumn="CompanyName" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerTotal" Header="Customer Total" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <DataColumnSort DataColumn="CustomerTotal" DataType="Number" />
  </DataTableColumn>
  <GroupHeaderRow GroupFilterID="grpCustomer" IdeDisplayStatus="Collapsed">
    <Column ID="colCustomerIDDetails" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
      <Label ID="lblCustomerID" Caption="" />
    </Column>
    <Column ID="colCustomerNameDetails" Class="ThemeAlignLeft" IdeDisplayStatus="Collapsed">
      <Label ID="lblCompanyName" Caption="" />
    </Column>
    <Column Class="ThemeAlignRight" ID="colCustomerTotal" IdeDisplayStatus="Collapsed">
      <Label ID="lblCustomerTotal" Caption="" Format="Currency" />
    </Column>
  </GroupHeaderRow>
  <DataTableColumn ID="colOrderID" Header="Order ID" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <DataColumnSort DataColumn="CustomerID,OrderID" DataType="Text,Number" />
  </DataTableColumn>
  <DataTableColumn ID="colOrderDate" Header="Order Date" IdeDisplayStatus="Collapsed">
    <DataColumnSort DataColumn="CustomerID,OrderDate" DataType="Text,Date" />
  </DataTableColumn>
  <DataTableColumn ID="colOrderTotal" Header="Order Total" IdeDisplayStatus="Collapsed" Class="ThemeAlignRight">
    <DataColumnSort DataColumn="CustomerID,OrderTotal" DataType="Text,Number" />
  </DataTableColumn>
  <GroupHeaderRow GroupFilterID="grpOrder" IdeDisplayStatus="Collapsed">
    <Column ID="colDummy1" />
    <Column ID="colDummy2" />
    <Column ID="colDummy3" />
    <Column ID="colOrderID" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
      <Label ID="lblOrderID" Caption="" />
    </Column>
    <Column ID="colOrderDate" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
      <Label ID="lblOrderDate" Caption="" Format="Short Date" />
    </Column>
    <Column ID="colOrderTotal" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
      <Label ID="lblOrderTotal" Caption="" Format="Currency" />
    </Column>
  </GroupHeaderRow>
  <DataTableColumn ID="colProductID" Header="Product ID" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblProductID" Format="General Number" Tooltip="" />
    <DataColumnSort DataColumn="CustomerID,OrderID,ProductID" DataType="Text,Text,Number" />
  </DataTableColumn>
  <DataTableColumn ID="colUnitPrice" Header="Unit Price" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitPrice" Caption="" Format="Currency" Class="ThemeTextNormal" />
    <DataColumnSort DataColumn="CustomerID,OrderID,UnitPrice" DataType="Text,Text,Number" />
  </DataTableColumn>
  <DataTableColumn ID="colQuantity" Header="Quantity" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblQuantity" Caption="" Format="General Number" Class="ThemeTextNormal" />
    <DataColumnSort DataColumn="CustomerID,OrderID,Quantity" DataType="Text,Text,Number" />
  </DataTableColumn>
  <DataTableColumn ID="colUnitTotal" Header="Unit Total" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitTotal" Caption="" Format="Currency" Class="ThemeTextNormal" />
    <DataColumnSort DataColumn="CustomerID,OrderID,UnitTotal" DataType="Text,Text,Number" />
  </DataTableColumn>
</DataTable>

Data grouped first by Country and then by City
Order ID	Cust ID	Ship To	Country	City	Freight
10258	ERNSH	Ernst Handel	Austria	Graz	$140.51
10252	SUPRD	Suprêmes délices	Belgium	Charleroi	$51.30
10253	HANAR	Hanari Carnes	Brazil	Rio de Janeiro	$58.17
10256	WELLI	Wellington Importadora	Brazil	Resende	$13.97
10250	HANAR	Hanari Carnes	Brazil	Rio de Janeiro	$65.83
10261	QUEDE	Que Delícia	Brazil	Rio de Janeiro	$3.05
10251	VICTE	Victuailles en stock	France	Lyon	$41.34
10248	VINET	Vins et alcools Chevalier	France	Reims	$32.38
10260	OTTIK	Ottilies Käseladen	Germany	Köln	$55.09
10249	TOMSP	Toms Spezialitäten	Germany	Münster	$11.61
10259	CENTC	Centro comercial Moctezuma	Mexico	México D.F.	$3.25
10254	CHOPS	Chop-suey Chinese	Switzerland	Bern	$22.98
10255	RICSU	Richter Supermarkt	Switzerland	Genève	$148.33
10257	HILAA	HILARION-Abastos	Venezuela	San Cristóbal	$81.91

<DataTable ID="dtGroupMC" AltRowClass="ThemeAlternatingRow TD" Class="ThemeAlignLeft" Width="800" WidthScale="px" Caption="Data grouped first by Country and then by City" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" MaxRows="14">
    <GroupFilter GroupColumn="ShipCountry,ShipCity" KeepGroupedRows="True" />
  </DataLayer>
  <DataTableColumn ID="colOrderID" Header="Order ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblOrderID" Caption="" />
    <DataColumnSort DataColumn="OrderID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colFreight" Header="Freight" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblFreight" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="Freight" />
  </DataTableColumn>
</DataTable>

Data grouped and summarized, with all rows retained and group subtotals
Order ID	Cust ID	Ship To	Country	City	Freight
10643	ALFKI	Alfreds Futterkiste	Germany	Berlin	$29.46
10692	ALFKI	Alfred's Futterkiste	Germany	Berlin	$61.02
10702	ALFKI	Alfred's Futterkiste	Germany	Berlin	$23.94
10835	ALFKI	Alfred's Futterkiste	Germany	Berlin	$69.53
10952	ALFKI	Alfred's Futterkiste	Germany	Berlin	$40.42
11011	ALFKI	Alfred's Futterkiste	Germany	Berlin	$1.21
SubTotal					$225.58

10308	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$1.61
10625	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$43.90
10759	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$11.99
10926	ANATR	Ana Trujillo Emparedados y helados	Mexico	México D.F.	$39.92
SubTotal					$97.42

10365	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$22.00
10507	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$47.45
10535	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$15.64
10573	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$84.84
10677	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$4.03
10682	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$36.13
10856	ANTON	Antonio Moreno Taquería	Mexico	México D.F.	$58.43
SubTotal					$268.52

Total					$591.52

<DataTable ID="dtGroupSubtotal" AltRowClass="ThemeAlternatingRow TD" Class="ThemeAlignLeft" Width="800" WidthScale="px" Caption="Data grouped and summarized, with all rows retained and group subtotals" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition="&quot;&quot; = &quot;ALFKI&quot; Or &quot;&quot; = &quot;ANATR&quot; Or &quot;&quot; = &quot;ANTON&quot;" />
    <GroupFilter GroupColumn="CustomerID" KeepGroupedRows="True" DataType="Text" ID="gfCustUD" />
  </DataLayer>
  <DataTableColumn ID="colOrderID" Header="Order ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblOrderID" Caption="" />
    <DataColumnSort DataColumn="OrderID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colCustomerID" Header="Cust ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblCustomerID" Caption="" />
    <DataColumnSort DataColumn="CustomerID" />
  </DataTableColumn>
  <DataTableColumn ID="colShipName" Header="Ship To" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipName" Caption="" />
    <DataColumnSort DataColumn="ShipName" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCountry" Header="Country" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCountry" Caption="" />
    <DataColumnSort DataColumn="ShipCountry" />
  </DataTableColumn>
  <DataTableColumn ID="colShipCity" Header="City" IdeDisplayStatus="Collapsed">
    <Label ID="lblShipCity" Caption="" />
    <DataColumnSort DataColumn="ShipCity" />
  </DataTableColumn>
  <DataTableColumn ID="colFreight" Header="Freight" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblFreight" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="ShipCountry" />
    <DataColumnSummary DataColumn="Freight" Function="Sum" ID="sumFreight" DataType="Number" />
  </DataTableColumn>
  <Note Note="Note that Format (Currency) of data shown in summarized column (Freight)" />
  <Note Note="is applied automatically to Group Summary and Summary row columns as well." />
  <GroupSummaryRow GroupFilterID="gfCustUD" Caption="SubTotal" Class="ThemeBold" AppendBlankRows="1" ID="gsrSubTotal" />
  <SummaryRow ID="srTotal" Caption="Total" Class="fontA12, ThemeBold" />
</DataTable>