Calculated Columns

Example

Data Table with Calculated Stock Value Column

Product ID

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

This Data Table element includes:

Minimal attribute settings
Alternating row background color
Draggable and sortable columns
Calculated Stock Value column

<DataTable ID="dtCalcCol1" DraggableColumns="True" AjaxPaging="True" AltRowClass="ThemeAlternatingRow" RememberSort="True" SortArrows="True" Class="ThemeAlignLeft" Width="900" WidthScale="px" Caption="Data Table with Calculated Stock Value Column" ResizableColumns="True">
  <DataLayer Type="XMLFile" XMLFile="NW_Products.xml" ID="dlProductsXML" MaxRows="15" IdeDisplayStatus="Collapsed">
    <ConditionFilter Condition=" &lt; 21" />
    <CalculatedColumn Formula=" * " ID="calcStockValue" />
  </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" />
  </DataTableColumn>
  <DataTableColumn ID="colStockValue" Header="Stock Value" Class="ThemeAlignRight" IdeDisplayStatus="Collapsed">
    <Label ID="lblStockValue" Caption="" Format="Currency" />
    <DataColumnSort DataColumn="calcStockValue" DataType="Number" />
  </DataTableColumn>
</DataTable>

Custom Column Examples
Raw Data	Seq #	Formatted	Calculated	Rank	Difference	Moving Avg	Running Total	Aggreg Sum	Percentage
32.38	1	$32.38	1.46	5	0.00	32.38	32.38	726.67	4.46%
11.61	2	$11.61	0.52	2	-20.77	22.00	43.99	726.67	1.60%
65.83	3	$65.83	2.96	10	54.22	36.61	109.82	726.67	9.06%
41.34	4	$41.34	1.86	6	-24.49	37.79	151.16	726.67	5.69%
51.3	5	$51.30	2.31	7	9.96	40.49	202.46	726.67	7.06%
58.17	6	$58.17	2.62	9	6.87	43.44	260.63	726.67	8.01%
22.98	7	$22.98	1.03	4	-35.19	40.52	283.61	726.67	3.16%
148.33	8	$148.33	6.67	13	125.35	53.99	431.94	726.67	20.41%
13.97	9	$13.97	0.63	3	-134.36	49.55	445.91	726.67	1.92%
81.91	10	$81.91	3.69	11	67.94	52.78	527.82	726.67	11.27%
140.51	11	$140.51	6.32	12	58.60	60.76	668.33	726.67	19.34%
3.25	12	$3.25	0.15	1	-137.26	55.97	671.58	726.67	0.45%
55.09	13	$55.09	2.48	8	51.84	55.90	726.67	726.67	7.58%

<DataTable AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="Custom Column Examples" CaptionClass="font11pt" ID="dtCustomCols" Width="1050" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer ID="dlOrdersXML" Type="XMLFile" XMLFile="NW_Orders.xml" IdeDisplayStatus="Collapsed">
    <DataLayerLink ID="lnkOrderData" />
    <ConditionFilter Condition=" &lt; 10261" />
    <Note Note="Each of the following elements creates a new column within the datalayer" />
    <AggregateColumn AggregateColumn="Freight" AggregateFunction="Sum" DataType="Number" ID="Aggregate" />
    <CalculatedColumn Formula=" * .045" ID="Calculated" />
    <DifferenceColumn DataColumn="Freight" ID="Difference" ReCalculateAfterSort="True" />
    <FormattedColumn DataColumn="Freight" Format="Currency" ID="Formatted" />
    <MovingAverageColumn DataColumn="Freight" ID="MovingAverage" MovingAveragePeriod="100" ReCalculateAfterSort="True" />
    <PercentOfTotalColumn DataColumn="Freight" ID="PercentTotal" />
    <RankColumn DataColumn="Freight" ID="Rank" RankType="Rank" />
    <RunningTotalColumn DataColumn="Freight" ID="RunningTotal" ReCalculateAfterSort="True" />
    <SequenceColumn ID="Sequence" />
  </DataLayer>
  <DataTableColumn Class="ThemeAlignRight" Header="Raw Data" ID="colRawData" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblFreight" />
    <DataColumnSort DataColumn="Freight" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Seq #" ID="colSequence" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblSequence" />
    <DataColumnSort DataColumn="Sequence" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Formatted" ID="colFormatted" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblFormatted" />
    <DataColumnSort DataColumn="Freight" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Calculated" ID="colCalculated" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblCalculated" />
    <DataColumnSort DataColumn="Calculated" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Rank" ID="colRank" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblRank" />
    <DataColumnSort DataColumn="Rank" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Difference" ID="colDifference" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblDifference" />
    <DataColumnSort DataColumn="Difference" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Moving Avg" ID="colMovingAverage" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblMovingAverage" />
    <DataColumnSort DataColumn="MovingAverage" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Running Total" ID="colRunningTotal" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="###,###,##0.00" ID="lblRunningTotal" />
    <DataColumnSort DataColumn="RunningTotal" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignRight" Header="Aggreg Sum" ID="colAggregate" IdeDisplayStatus="Collapsed">
    <Label Caption="726.67" Format="###,###,##0.00" ID="lblAggregate" />
    <DataColumnSort DataColumn="Aggregate" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Percentage" ID="colPercent" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="Percent" ID="lblPercentageTotal" />
    <DataColumnSort DataColumn="PercentTotal" DataType="Number" />
  </DataTableColumn>
</DataTable>

Time Period Column Examples

2010-07-31T00:00:00.000

07/31/2010

Jul 31, 2010

Sat

Saturday

Jul

July

2010

2010-08-01T00:00:00.000

08/01/2010

Aug 01, 2010

Sun

Sunday

Aug

August

2010

2010-09-02T00:00:00.000

09/02/2010

Sep 02, 2010

Thu

Thursday

Sep

September

2010

2010-10-08T00:00:00.000

10/08/2010

Oct 08, 2010

Fri

Friday

Oct

October

2010

2010-11-12T00:00:00.000

11/12/2010

Nov 12, 2010

Fri

Friday

Nov

November

2010

2010-12-23T00:00:00.000

12/23/2010

Dec 23, 2010

Thu

Thursday

Dec

December

2010

<DataTable AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="Time Period Column Examples" CaptionClass="font11pt" Class="font10pt" ID="dtOrderData1" Width="1050" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer ID="dlLinkedOrders" LinkedDataLayerID="lnkOrderData" Type="Linked" IdeDisplayStatus="Collapsed">
    <CompareFilter CompareType="InList" DataColumn="OrderID" ID="cmpOrderID1" CompareValue="10269,10270,10295,10324,10352,10390" DataType="Number" />
    <Note Note="Each of the following elements creates a new column within the datalayer" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodDay" TimePeriod="DayOfMonth" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodMonth" TimePeriod="Month" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodMonthAbbrev" TimePeriod="MonthAbbreviation" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodMonthName" TimePeriod="MonthName" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodYear" TimePeriod="Year" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodQuarter" TimePeriod="Quarter" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodDOW" TimePeriod="DayOfWeek" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodDOWAbbrev" TimePeriod="DayOfWeekAbbreviation" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodDOM" TimePeriod="DayOfMonth" />
    <TimePeriodColumn DataColumn="OrderDate" ID="TimePeriodDayName" TimePeriod="DayOfWeekName" />
    <FormattedColumn DataColumn="OrderDate" Format="MMM dd, yyyy" ID="FormattedCol" />
  </DataLayer>
  <DataTableColumn Class="ThemeAlignCenter" Header="Raw Data" ID="colRaw" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblISOFormat" />
    <DataColumnSort DataColumn="OrderDate" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="CXMLDate()" ID="colCXMLDate" IdeDisplayStatus="Collapsed">
    <Note Note="The intrinsic Logi CXMLDate function converts ISO-formatted dates to a format&#xD;&#xA;usable in date functions such as DateAdd, DateDiff, etc." />
    <Label Caption="=CXMLDate(&quot;&quot;)" ID="lblOrderDate" />
    <DataColumnSort DataColumn="OrderDate" DataType="Date" />
    <TooltipPanel Class="ThemeAlignLeft" Height="80" HeightScale="px" ID="ttpFunctionInfo" Width="330" WidthScale="px" IdeDisplayStatus="Collapsed">
      <Label Caption="This is a Logi intrinsic function for converting dates in ISO 8601 format for use with DateDiff(), DateAdd(), etc. See &quot;Special Functions and Attributes&quot; reference document.&#xD;&#xA;" ID="lblLogiIntrinsic" />
    </TooltipPanel>
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Formatted" ID="colFormattedDate" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblFormatted" />
    <DataColumnSort DataColumn="OrderDate" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Day" ID="colDay" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblDay" />
    <DataColumnSort DataColumn="TimePeriodDay" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Day/Week" ID="colOrderDOW" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblDOW" />
    <DataColumnSort DataColumn="TimePeriodDOW" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Day" ID="colDayAbbrev" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblDayName" />
    <DataColumnSort DataColumn="TimePeriodDayName" DataType="Text" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Day Full" ID="colDayName" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblDayName" />
    <DataColumnSort DataColumn="TimePeriodDayName" DataType="Text" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Day/Mon" ID="colOrderDOM" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblDOM" />
    <DataColumnSort DataColumn="TimePeriodDOM" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Month #" ID="colMonth" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblOrderMonth" />
    <DataColumnSort DataColumn="TimePeriodMonth" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Month" ID="colMonthAbbrev" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblMonthAbbrev" />
    <DataColumnSort DataColumn="TimePeriodMonthAbbrev" DataType="Text" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Month Full" ID="colMonthName" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblMonthName" />
    <DataColumnSort DataColumn="TimePeriodMonthName" DataType="Text" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Quarter" ID="colQuarter" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblOrderQuarter" />
    <DataColumnSort DataColumn="TimePeriodQuarter" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Year" ID="colYear" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblOrderYear" />
    <DataColumnSort DataColumn="TimePeriodYear" DataType="Number" />
  </DataTableColumn>
</DataTable>

Time Period Columns - 1st & Last
Raw Data	1stDay Year	LastDay Year	1stDay Qtr	LastDay Qtr	1stDay Month	LastDay Month	1stDay Week	LastDay Week
2010-07-31T00:00:00.000	2010-01-01	2010-12-31	2010-07-01	2010-09-30	2010-07-01	2010-07-01	2010-07-25	2010-07-31
2010-08-01T00:00:00.000	2010-01-01	2010-12-31	2010-07-01	2010-09-30	2010-08-01	2010-08-01	2010-08-01	2010-08-07
2010-09-02T00:00:00.000	2010-01-01	2010-12-31	2010-07-01	2010-09-30	2010-09-01	2010-09-01	2010-08-29	2010-09-04
2010-10-08T00:00:00.000	2010-01-01	2010-12-31	2010-10-01	2010-12-31	2010-10-01	2010-10-01	2010-10-03	2010-10-09
2010-11-12T00:00:00.000	2010-01-01	2010-12-31	2010-10-01	2010-12-31	2010-11-01	2010-11-01	2010-11-07	2010-11-13
2010-12-23T00:00:00.000	2010-01-01	2010-12-31	2010-10-01	2010-12-31	2010-12-01	2010-12-01	2010-12-19	2010-12-25

<DataTable AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="Time Period Columns - 1st &amp; Last" CaptionClass="font11pt" Class="font10pt" ID="dtOrderData2" Width="1050" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer ID="dlLinkedOrders" LinkedDataLayerID="lnkOrderData" Type="Linked">
    <CompareFilter CompareType="InList" DataColumn="OrderID" ID="cmpOrderID2" CompareValue="10269,10270,10295,10324,10352,10390" DataType="Number" />
    <Note Note="Each of the following elements creates a new column within the datalayer" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcFirstDayYr" TimePeriod="FirstDayOfYear" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcLastDayYr" TimePeriod="LastDayOfYear" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcFirstDayQtr" TimePeriod="FirstDayOfQuarter" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcLastDayQtr" TimePeriod="LastDayOfQuarter" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcFirstDayMon" TimePeriod="FirstDayOfMonth" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcLastDayMon" TimePeriod="LastDayOfMonth" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcFirstDayWk" TimePeriod="FirstDayOfWeek" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcLastDayWk" TimePeriod="LastDayOfWeek" />
  </DataLayer>
  <DataTableColumn Class="ThemeAlignCenter" Header="Raw Data" ID="colRaw">
    <Label Caption="" ID="lblISOFormat" />
    <DataColumnSort DataColumn="OrderDate" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1stDay Year" ID="colFirstDayYr">
    <Label Caption="" ID="lblFirstDayYr" />
    <DataColumnSort DataColumn="tpcFirstDayYr" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="LastDay Year" ID="colLastDayYr">
    <Label Caption="" ID="lblLastDayYr" />
    <DataColumnSort DataColumn="tpcLastDayYr" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1stDay Qtr" ID="colFirstDayQtr">
    <Label Caption="" ID="lblFirstDayQtr" />
    <DataColumnSort DataColumn="tpcFirstDayQtr" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="LastDay Qtr" ID="colLastDayQtr">
    <Label Caption="" ID="lblLastDayQtr" />
    <DataColumnSort DataColumn="tpcLastDayQtr" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1stDay Month" ID="colFirstDayMon">
    <Label Caption="" ID="lblFirstDayMon" />
    <DataColumnSort DataColumn="tpcFirstDayMon" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="LastDay Month" ID="colLastDayMon">
    <Label Caption="" ID="lblFirstDayMon" />
    <DataColumnSort DataColumn="tpcLastDayMon" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1stDay Week" ID="colFirstDayWk">
    <Label Caption="" ID="lblFirstDayWk" />
    <DataColumnSort DataColumn="tpcFirstDayWk" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="LastDay Week" ID="colLastDayWk">
    <Label Caption="" ID="lblLastDayWk" />
    <DataColumnSort DataColumn="tpcLastDayWk" DataType="Date" />
  </DataTableColumn>
</DataTable>

Time Period Columns - Time
Raw Data	1st Minute/Hour	1st Sec/Min
2010-07-31T00:00:00.000	12:00	00:00
2010-08-01T00:00:00.000	12:00	00:00
2010-09-02T00:00:00.000	12:00	00:00
2010-10-08T00:00:00.000	12:00	00:00
2010-11-12T00:00:00.000	12:00	00:00
2010-12-23T00:00:00.000	12:00	00:00

<DataTable AjaxPaging="True" AltRowClass="ThemeAlternatingRow TD" Caption="Time Period Columns - Time" CaptionClass="font11pt" Class="font10pt" ID="dtOrderData3" Width="1050" WidthScale="px" IdeDisplayStatus="Collapsed">
  <DataLayer ID="dlLinkedOrders" LinkedDataLayerID="lnkOrderData" Type="Linked" IdeDisplayStatus="Collapsed">
    <CompareFilter CompareType="InList" DataColumn="OrderID" ID="cmpOrderID3" CompareValue="10269,10270,10295,10324,10352,10390" DataType="Number" />
    <Note Note="Each of the following elements creates a new column within the datalayer" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcHour" TimePeriod="Hour" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcMinute" TimePeriod="Minute" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpcSecond" TimePeriod="Second" />
    <Note Note="There is no Millisecond time period, but we can calculate it" />
    <CalculatedColumn Formula="Right(&quot;&quot;, 3)" ID="calcMillisecs" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpc1stMilliSec" TimePeriod="FirstMillisecondOfSecond" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpc1stSecMin" TimePeriod="FirstSecondOfMinute" />
    <TimePeriodColumn DataColumn="OrderDate" ID="tpc1stMinHour" TimePeriod="FirstMinuteOfHour" />
  </DataLayer>
  <DataTableColumn Class="ThemeAlignCenter" Header="Raw Data" ID="colRaw" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblISOFormat" />
    <DataColumnSort DataColumn="OrderDate" DataType="Date" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Hour" ID="colHour" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblHour" />
    <DataColumnSort DataColumn="tpcHour" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Minute" ID="colMinute" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblMinute" />
    <DataColumnSort DataColumn="tpcMinute" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="Second" ID="colSecond" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblSecond" />
    <DataColumnSort DataColumn="tpcSecond" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="MilliSecs" ID="colMillisecs" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblMillisecs" />
    <DataColumnSort DataColumn="calcMillisecs" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1st Minute/Hour" ID="col1stMinHr" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="hh:mm" ID="lbl1stMinHour" />
    <DataColumnSort DataColumn="tpc1stMinHour" DataType="Number" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1st Sec/Min" ID="col1stSecMin" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="mm:ss" ID="lbl1stSecMin" />
    <DataColumnSort DataColumn="tpc1stSecMin" DataType="Text" />
  </DataTableColumn>
  <DataTableColumn Class="ThemeAlignCenter" Header="1st Millisec/Sec" ID="col1stMillisec" IdeDisplayStatus="Collapsed">
    <Label Caption="" Format="ss.ff" ID="lbl1stMillisec" />
    <DataColumnSort DataColumn="tpc1stMilliSec" DataType="Text" />
  </DataTableColumn>
</DataTable>