Basic Tables

Example

Basic Table

Product ID

Chai

10 boxes x 20 bags

$18.00

Chang

24 - 12 oz bottles

$19.00

Aniseed Syrup

12 - 550 ml bottles

$10.00

Chef Antons Cajun Seasoning

48 - 6 oz jars

$22.00

Chef Antons Gumbo Mix

36 boxes

$21.35

Grandmas Boysenberry Spread

12 - 8 oz jars

$25.00

120

Uncle Bobs Organic Dried Pears

12 - 1 lb pkgs.

$30.00

Northwoods Cranberry Sauce

12 - 12 oz jars

$40.00

Mishi Kobe Niku

18 - 500 g pkgs.

$97.00

Ikura

12 - 200 ml jars

$31.00

Queso Cabrales

1 kg pkg.

$21.00

Queso Manchego La Pastora

10 - 500 g pkgs.

$38.00

Konbu

2 kg box

$6.00

Tofu

40 - 100 g pkgs.

$23.25

Genen Shouyu

24 - 250 ml bottles

$15.50

This Data Table element includes:

Minimal attribute settings
Custom theme
Alternating row background color
Draggable, resizable, and sortable columns

<DataTable ID="dtBasicTable1" DraggableColumns="True" AjaxPaging="True" RememberSort="True" SortArrows="True" AltRowClass="ThemeAlternatingRow" Width="900" WidthScale="px" Caption="Basic Data Table" Class="ThemeAlignLeft" ResizableColumns="True" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" XMLFile="NW_Products.xml" ID="dlProductsXML" MaxRows="15" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition=" &lt; 21" />
  </DataLayer>
  <DataTableColumn ID="colProductID" Header="Product ID" IdeDisplayStatus="Collapsed">
    <Label ID="lblProductID" Caption="" />
    <DataColumnSort DataColumn="ProductID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colProductName" Header="Product Name" IdeDisplayStatus="Collapsed">
    <Label ID="lblProductName" Caption="" />
    <DataColumnSort DataColumn="ProductName" />
  </DataTableColumn>
  <DataTableColumn ID="colQuantityPerUnit" Header="Quantity/Unit" IdeDisplayStatus="Collapsed">
    <Label ID="lblQuantityPerUnit" Caption="" />
    <DataColumnSort DataColumn="QuantityPerUnit" />
  </DataTableColumn>
  <DataTableColumn ID="colUnitPrice" Header="Unit Price" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitPrice" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="UnitPrice" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colUnitsInStock" Header="Units In Stock" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitsInStock" Caption="" />
    <DataColumnSort DataColumn="UnitsInStock" DataType="Number" />
  </DataTableColumn>
</DataTable>

Product	Category	Quan Unit	Unit Price	Units Stock

Chai	1	10 boxes x 20 bags	$18.00	39
Chang	1	24 - 12 oz bottles	$19.00	17
Aniseed Syrup	2	12 - 550 ml bottles	$10.00	13
Chef Antons Cajun Seasoning	2	48 - 6 oz jars	$22.00	53
Chef Antons Gumbo Mix	2	36 boxes	$21.35	0
Grandmas Boysenberry Spread	2	12 - 8 oz jars	$25.00	120
Uncle Bobs Organic Dried Pears	7	12 - 1 lb pkgs.	$30.00	15
Northwoods Cranberry Sauce	2	12 - 12 oz jars	$40.00	6
Mishi Kobe Niku	6	18 - 500 g pkgs.	$97.00	29
Ikura	8	12 - 200 ml jars	$31.00	31
Queso Cabrales	4	1 kg pkg.	$21.00	22
Queso Manchego La Pastora	4	10 - 500 g pkgs.	$38.00	86
Konbu	8	2 kg box	$6.00	24
Tofu	7	40 - 100 g pkgs.	$23.25	35
Genen Shouyu	2	24 - 250 ml bottles	$15.50	39
Pavlova	3	32 - 500 g boxes	$17.45	29
Alice Mutton	6	20 - 1 kg tins	$39.00	0
Carnarvon Tigers	8	16 kg pkg.	$62.50	42
Teatime Chocolate Biscuits	3	10 boxes x 12 pieces	$9.20	25
Sir Rodneys Marmalade	3	30 gift boxes	$81.00	40
Sir Rodneys Scones	3	24 pkgs. x 4 pieces	$10.00	3
Gustafs Knäckebröd	5	24 - 500 g pkgs.	$21.00	104
Tunnbröd	5	12 - 250 g pkgs.	$9.00	61
Guaraná Fantástica	1	12 - 355 ml cans	$4.50	20
NuNuCa Nuß-Nougat-Creme	3	20 - 450 g glasses	$14.00	76
Gumbär Gummibärchen	3	100 - 250 g bags	$31.23	15
Schoggi Schokolade	3	100 - 100 g pieces	$43.90	49
Rössle Sauerkraut	7	25 - 825 g cans	$45.60	26
Thüringer Rostbratwurst	6	50 bags x 30 sausgs.	$123.79	0
Nord-Ost Matjeshering	8	10 - 200 g glasses	$25.89	10

This Data Table element includes:

Method for "freezing" column headers while scrolling data table rows
Draggable, resizable, and sortable columns are not available using this technique

<DataTable Class="specialTable" ColumnHeaderClass="" ID="dtHeader" IdeDisplayStatus="Collapsed">
  <Note Note="Set datalayer Max Rows = 0 to ensure no rows are retrieved" />
  <DataLayer ID="dlProductsXMLHdr" MaxRows="0" Type="XMLFile" XMLFile="NW_Products.xml" />
  <DataTableColumn Header="Product" ID="colProductName" Width="36" WidthScale="%" />
  <DataTableColumn Header="Category" ID="colCategoryID" Width="10" WidthScale="%" />
  <DataTableColumn Header="Quan Unit" ID="colQuantityPerUnit" Width="25" WidthScale="%" />
  <DataTableColumn Header="Unit Price" ID="colUnitPrice" />
  <DataTableColumn Header="Units Stock" ID="colUnitsInStock" Width="14" WidthScale="%" />
</DataTable><Division Class="scrollingTableDiv" HtmlDiv="True" ID="divDataTable" IdeDisplayStatus="Collapsed">
  <Note Note="The table shows only the data and not any column headers" />
  <DataTable AltRowClass="ThemeAlternatingRow TD" Class="specialTable" ColumnHeaderClass="" ID="dtProducts" IdeDisplayStatus="Collapsed">
    <DataLayer ID="dlProductsXML" MaxRows="30" Type="XMLFile" XMLFile="NW_Products.xml" />
    <DataTableColumn Class="ThemeAlignLeft" ID="colProductName" Width="36" WidthScale="%" IdeDisplayStatus="Collapsed">
      <Label Caption="" ID="lblProductName" />
    </DataTableColumn>
    <DataTableColumn Class="ThemeAlignCenter" ID="colCategoryID" Width="10" WidthScale="%" IdeDisplayStatus="Collapsed">
      <Label Caption="" ID="lblCategoryID" />
    </DataTableColumn>
    <DataTableColumn Class="ThemeAlignLeft" ID="colQuantityPerUnit" Width="25" WidthScale="%" IdeDisplayStatus="Collapsed">
      <Label Caption="" ID="lblQuantityPerUnit" />
    </DataTableColumn>
    <DataTableColumn Class="ThemeAlignRight" ID="colUnitPrice" Width="15" WidthScale="%" IdeDisplayStatus="Collapsed">
      <Label Caption="" Format="Currency" ID="lblUnitPrice" />
    </DataTableColumn>
    <DataTableColumn Class="ThemeAlignRight" ID="colUnitsInStock" Width="14" WidthScale="%" IdeDisplayStatus="Collapsed">
      <Label Caption="" ID="lblUnitsInStock" />
    </DataTableColumn>
  </DataTable>
</Division>

Data Table with Summary Row

Chai

10 boxes x 20 bags

$18.00

$702.00

Chang

24 - 12 oz bottles

$19.00

$323.00

Aniseed Syrup

12 - 550 ml bottles

$10.00

$130.00

Chef Antons Cajun Seasoning

48 - 6 oz jars

$22.00

$1,166.00

Chef Antons Gumbo Mix

36 boxes

$21.35

$0.00

Grandmas Boysenberry Spread

12 - 8 oz jars

$25.00

120

$3,000.00

Uncle Bobs Organic Dried Pears

12 - 1 lb pkgs.

$30.00

$450.00

Northwoods Cranberry Sauce

12 - 12 oz jars

$40.00

$240.00

Mishi Kobe Niku

18 - 500 g pkgs.

$97.00

$2,813.00

Ikura

12 - 200 ml jars

$31.00

$961.00

Queso Cabrales

1 kg pkg.

$21.00

$462.00

Queso Manchego La Pastora

10 - 500 g pkgs.

$38.00

$3,268.00

Konbu

2 kg box

$6.00

$144.00

Tofu

40 - 100 g pkgs.

$23.25

$813.75

Genen Shouyu

24 - 250 ml bottles

$15.50

$604.50

Totals:

529

$15,077.25

This Data Table element includes:

Alternating row background color
Draggable and sortable columns
Calculated Stock Value column
Summary Row values for Units In Stock and Stock Value columns

<DataTable ID="dtSummaryRow1" DraggableColumns="True" AjaxPaging="True" AltRowClass="ThemeAlternatingRow" RememberSort="True" SortArrows="True" Class="ThemeAlignLeft" Width="900" WidthScale="px" Caption="Data Table with Summary Row" ResizableColumns="True" IdeDisplayStatus="Collapsed">
  <DataLayer Type="XMLFile" XMLFile="NW_Products.xml" ID="dlProductsXML" MaxRows="15" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition=" &lt; 21" />
    <CalculatedColumn Formula=" * " ID="colStockValue" />
  </DataLayer>
  <DataTableColumn ID="colProductID" Header="Product ID">
    <Label ID="lblProductID" Caption="" />
    <DataColumnSort DataColumn="ProductID" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colProductName" Header="Product Name" IdeDisplayStatus="Collapsed">
    <Label ID="lblProductName" Caption="" />
    <DataColumnSort DataColumn="ProductName" />
  </DataTableColumn>
  <DataTableColumn ID="colQuantityPerUnit" Header="Quantity Per Unit" IdeDisplayStatus="Collapsed">
    <Label ID="lblQuantityPerUnit" Caption="" />
    <DataColumnSort DataColumn="QuantityPerUnit" />
  </DataTableColumn>
  <DataTableColumn ID="colUnitPrice" Header="Unit Price" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitPrice" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="UnitPrice" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colUnitsInStock" Header="Units In Stock" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblUnitsInStock" Caption="" />
    <DataColumnSort DataColumn="UnitsInStock" DataType="Number" />
    <DataColumnSummary DataColumn="UnitsInStock" Function="Sum" ID="StockUnitsSummary" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn ID="colStockValue" Header="Stock Value" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblStockValue" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="colStockValue" DataType="Number" />
    <DataColumnSummary DataColumn="colStockValue" Function="Sum" ID="StockValueSummary" DataType="Number" />
  </DataTableColumn>
  <SummaryRow Caption="Totals:" Class="fontA12" ID="srTotals" />
</DataTable>