<AnalysisGrid ID="agOrders" Caption="Northwind Orders" SavedAnalysisGridFolder="E:\Sample Apps\SampleAnalysisGrid\UserData" DraggableColumns="True" DraggablePanels="True" SortArrows="True" AjaxPaging="True" PageRowCount="12" AltRowClass="ThemeAlternatingRow TD" Class="centerSuperEle" ChartHoverHighlighting="True" Width="900" WidthScale="px">
  <DataLayer Type="XMLFile" ID="dlOrdersXML" XMLFile="NW_Orders.xml" />
  <DataForecast />
  <DataTableColumn ID="colOrderID" Header="Order ID" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <Label Caption="" ID="lblOrderID" IdeDisplayStatus="Collapsed">
      <Action Type="ShowElement" ElementID="mirOrderDetail" Display="Toggle" ID="actShowOrderDetails" />
    </Label>
    <DataColumnSort DataColumn="OrderID" />
  </DataTableColumn>
  <AnalysisGridColumn ID="agcCustID" DataColumn="CustomerID" DataType="Text" Header="Customer" NoCrosstabHeader="True" NoCrosstabLabel="True" NoCrosstabAggregate="True" NoAgCrosstabAggregate="True" NoAgAggregates="True" NoAgCrosstabHeader="True" NoAgCrosstabLabel="True" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <Action Type="Report" ID="actCustomerDetails" IdeDisplayStatus="Collapsed">
      <Target Type="Report" Report="DrillDownTarget" FrameID="Self" />
      <LinkParams PassedData="" />
    </Action>
  </AnalysisGridColumn>
  <AnalysisGridColumn ID="agcOrderDate" DataColumn="OrderDate" Header="Ordered On" NoAggregates="True" NoCrosstabAggregate="True" DataType="Date" Format="MM/dd/yyyy" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <Note Note="This element ensures correct formatting when exported to Excel." />
    <ExcelColumnFormat DataType="Date" ExcelFormat="d-mmm-yy" />
  </AnalysisGridColumn>
  <AnalysisGridColumn ID="agcReqDate" DataColumn="RequiredDate" Header="Required By" NoAggregates="True" NoCrosstabAggregate="True" DataType="Date" Format="MM/dd/yyyy" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <ExcelColumnFormat DataType="Date" ExcelFormat="d-mmm-yy" />
  </AnalysisGridColumn>
  <AnalysisGridColumn ID="agcFreight" DataColumn="Freight" DataType="Number" Header="Freight" Format="Currency" Class="ThemeAlignRight" NoGrouping="True" NoCrosstabHeader="True" NoCrosstabLabel="True" NoAgGrouping="True" />
  <AnalysisGridColumn ID="agcShippedDate" DataColumn="ShippedDate" DataType="Date" Header="Shipped On" NoAggregates="True" NoCrosstabHeader="True" NoCrosstabAggregate="True" Format="MM/dd/yyyy" Class="ThemeAlignCenter" IdeDisplayStatus="Collapsed">
    <ExcelColumnFormat DataType="Date" ExcelFormat="d-mmm-yy" />
  </AnalysisGridColumn>
  <AnalysisGridColumn ID="agcCountry" DataColumn="ShipCountry" DataType="Text" Header="Country" NoGrouping="True" NoCrosstabHeader="True" NoCrosstabLabel="True" PopupValuesForFilter="List" Class="ThemeAlignCenter" />
  <AnalysisGridColumn ID="agcPostCode" DataColumn="ShipPostalCode" Header="Post Code" DataType="Text" Class="ThemeAlignCenter" />
  <CrosstabComparison ID="xtabComparison" ComparisonShowValues="Percent" ComparisonStyle="Arrows" ComparisonShowTooltips="None" />
  <MoreInfoRow ShowModes="None" ColumnSpanFirst="1" ColumnSpanLast="8" ID="mirOrderDetail" IdeDisplayStatus="Collapsed">
    <IncludeFrame SubReportMode="Embedded" ID="subOrderDetail" IdeDisplayStatus="Collapsed">
      <Target Type="IncludeFrameReport" Report="OrderDetailSubRpt" ID="trgOrderDetail" />
      <LinkParams OrderID="" />
    </IncludeFrame>
  </MoreInfoRow>
  <WaitPage />
</AnalysisGrid>