﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <crossdata Ref="2" type="Stimulsoft.Report.Dictionary.StiExcelDatabase" isKey="true">
        <Alias>crossdata</Alias>
        <Key />
        <Name>crossdata</Name>
        <PathData>C:\Users\jennifer.pouillard\Desktop\crossdata.xlsx</PathData>
      </crossdata>
    </Databases>
    <DataSources isList="true" count="1">
      <Sowing Ref="3" type="DataTableSource" isKey="true">
        <Alias>Sowing</Alias>
        <Columns isList="true" count="16">
          <value>sowing_name,System.String</value>
          <value>code,System.String</value>
          <value>plot,System.Double</value>
          <value>min_plot_no,System.Double</value>
          <value>nom,System.String</value>
          <value>genealogy,System.Double</value>
          <value>trait_code,System.Double</value>
          <value>trait_name,System.String</value>
          <value>trait_value,System.Object</value>
          <value>trait_value_id,System.Double</value>
          <value>date,System.String</value>
          <value>observation_date,System.DateTime</value>
          <value>formatdate,System.DateTime</value>
          <value>trait_order,System.Double</value>
          <value>comment,System.String</value>
          <value>comments,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Sowing</Name>
        <NameInSource>crossdata.Feuil1</NameInSource>
      </Sowing>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="1">
      <value>,comments,comments,,System.String,,False,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <By_plot Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataBand2 Ref="5" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,20.2,0.4</ClientRectangle>
          <Components isList="true" count="1">
            <CrossTab2 Ref="6" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,17.6,4.2</ClientRectangle>
              <Components isList="true" count="17">
                <CrossTab2_RowTotal2 Ref="7" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:235]</Brush>
                  <ClientRectangle>3.8,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>103a8654e8024f65a7b80841d0b2dd1f</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_RowTotal2</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab2_RowTotal2>
                <CrossTab2_RowTotal3 Ref="8" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:235]</Brush>
                  <ClientRectangle>5.4,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>40d6c75853a741d9b12f7c385d589890</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_RowTotal3</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab2_RowTotal3>
                <CrossTab2_ColTotal1 Ref="9" type="CrossColumnTotal" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:235]</Brush>
                  <ClientRectangle>3.85,0.45,0,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>9224a5e5c585490badff27d9ce3a24ee</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_ColTotal1</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab2_ColTotal1>
                <CrossTitle3 Ref="10" type="CrossTitle" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>0,0,4.6,0.4</ClientRectangle>
                  <Enabled>False</Enabled>
                  <Font>Arial,8</Font>
                  <Guid>081e288520584dfea9d044759a5e3d92</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTitle3</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Sowing</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TypeOfComponent>LeftTitle</TypeOfComponent>
                </CrossTitle3>
                <CrossTab2_Row1_Title Ref="11" type="CrossTitle" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>0,0.45,0.6,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>2de39384594b4a1c8ff3f7bc60c3e30b</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row1_Title</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Plot</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TypeOfComponent>Row:CrossTab2_Row1</TypeOfComponent>
                </CrossTab2_Row1_Title>
                <CrossTab2_Row2_Title Ref="12" type="CrossTitle" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>0.6,0.45,1,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>d44ffe023e834fc1abaacda7b645c53f</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row2_Title</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Name</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TypeOfComponent>Row:CrossTab2_Row2</TypeOfComponent>
                </CrossTab2_Row2_Title>
                <CrossTab2_Row3_Title Ref="13" type="CrossTitle" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>1.6,0.45,1.6,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>559403e5fa124c81a540210e403e4b90</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row3_Title</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Genealogy</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TypeOfComponent>Row:CrossTab2_Row3</TypeOfComponent>
                </CrossTab2_Row3_Title>
                <CrossTab2_Row4_Title Ref="14" type="CrossTitle" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>3.2,0.45,1.4,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>f1eddb36e24b47bd8c7735004d467187</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row4_Title</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Comment</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TypeOfComponent>Row:CrossTab2_Row4</TypeOfComponent>
                </CrossTab2_Row4_Title>
                <CrossTab2_RowTotal1 Ref="15" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:235]</Brush>
                  <ClientRectangle>6.8,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>a117d819be0c449e8821a9501ee2a065</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_RowTotal1</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab2_RowTotal1>
                <CrossTab2_RowTotal4 Ref="16" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:235]</Brush>
                  <ClientRectangle>8.2,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>8d23f68cde9e4f79a12d5f82cb4fc295</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_RowTotal4</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab2_RowTotal4>
                <CrossTab2_RightTitle Ref="17" type="CrossTitle" isKey="true">
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>4.65,0,1.6,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>d8598eaa6cae43a6bd6cdd25a9484dbb</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_RightTitle</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>trait_name</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TypeOfComponent>RightTitle</TypeOfComponent>
                </CrossTab2_RightTitle>
                <CrossTab2_Row1 Ref="18" type="CrossRow" isKey="true">
                  <Alias>plot</Alias>
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>0,0.9,0.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.plot}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>b56cf3ef6b2d41a8b63e431a575a096c</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row1</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>plot</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TotalGuid>a117d819be0c449e8821a9501ee2a065</TotalGuid>
                  <Value>{Sowing.plot}</Value>
                </CrossTab2_Row1>
                <CrossTab2_Row2 Ref="19" type="CrossRow" isKey="true">
                  <Alias>nom</Alias>
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>0.6,0.9,1,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.nom}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>4f3ed52890ff4e5dac51c01731e30417</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row2</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>nom</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TotalGuid>103a8654e8024f65a7b80841d0b2dd1f</TotalGuid>
                  <Value>{Sowing.nom}</Value>
                </CrossTab2_Row2>
                <CrossTab2_Row3 Ref="20" type="CrossRow" isKey="true">
                  <Alias>genealogy</Alias>
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>1.6,0.9,1.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.genealogy}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>3ec8a9f5898446cc9b1cfaa0c1f39898</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Row3</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>genealogy</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TotalGuid>40d6c75853a741d9b12f7c385d589890</TotalGuid>
                  <Value>{Sowing.genealogy}</Value>
                </CrossTab2_Row3>
                <CrossTab2_Row4 Ref="21" type="CrossRow" isKey="true">
                  <Alias>comment</Alias>
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>3.2,0.9,1.4,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.comment}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>570419f7d9c0433fa808ebb95ed7c0ee</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <MaxSize>3,0</MaxSize>
                  <Name>CrossTab2_Row4</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>comment</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TotalGuid>8d23f68cde9e4f79a12d5f82cb4fc295</TotalGuid>
                  <Value>{Sowing.comment}</Value>
                </CrossTab2_Row4>
                <CrossTab2_Column1 Ref="22" type="CrossColumn" isKey="true">
                  <Alias>trait_name</Alias>
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>PeachPuff</Brush>
                  <ClientRectangle>4.65,0.45,1.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.trait_name}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>ff2016371c884f14abf7d3835638cfb1</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Column1</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <SortType>ByValue</SortType>
                  <Text>trait_name</Text>
                  <TextBrush>[105:68:35]</TextBrush>
                  <TotalGuid>9224a5e5c585490badff27d9ce3a24ee</TotalGuid>
                  <Value>{Sowing.trait_order}</Value>
                </CrossTab2_Column1>
                <CrossTab2_Sum1 Ref="23" type="CrossSummary" isKey="true">
                  <Alias>trait_value</Alias>
                  <Border>All;[155:118:85];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>4.65,0.9,1.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>74b7d40e6c444f7b9f54d7b80bdc2479</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab2_Sum1</Name>
                  <Page isRef="4" />
                  <Parent isRef="6" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Summary>Average</Summary>
                  <Text>0</Text>
                  <TextBrush>Black</TextBrush>
                  <Value>{IIF(Sowing.trait_value=="",Sowing.trait_value_id,Sowing.trait_value)}</Value>
                </CrossTab2_Sum1>
              </Components>
              <Conditions isList="true" count="0" />
              <CrossTabStyleIndex>2</CrossTabStyleIndex>
              <DataRelationName />
              <DataSourceName>Sowing</DataSourceName>
              <EmptyValue />
              <Filters isList="true" count="0" />
              <Name>CrossTab2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <PrintTitleOnAllPages>False</PrintTitleOnAllPages>
              <Sort isList="true" count="0" />
            </CrossTab2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <Filters isList="true" count="0" />
          <Name>DataBand2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataBand2>
      </Components>
      <Conditions isList="true" count="0" />
      <ExcelSheet>By plot</ExcelSheet>
      <Guid>e5ac61b4b2d4433c81ec9e1e307c5267</Guid>
      <Margins>0.4,0.4,1,1</Margins>
      <Name>By_plot</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <PaperSize>A4</PaperSize>
      <Report isRef="0" />
      <UnlimitedBreakable>False</UnlimitedBreakable>
      <UnlimitedHeight>True</UnlimitedHeight>
      <Watermark Ref="24" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </By_plot>
    <Details Ref="25" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataBand3 Ref="26" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,20.2,0.4</ClientRectangle>
          <Components isList="true" count="1">
            <CrossTab3 Ref="27" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,17.6,4.2</ClientRectangle>
              <Components isList="true" count="20">
                <CrossTab3_RowTotal2 Ref="28" type="CrossRowTotal" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[185:255:255]</Brush>
                  <ClientRectangle>3.8,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>103a8654e8024f65a7b80841d0b2dd1f</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_RowTotal2</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab3_RowTotal2>
                <CrossTab3_RowTotal3 Ref="29" type="CrossRowTotal" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[185:255:255]</Brush>
                  <ClientRectangle>5.4,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>40d6c75853a741d9b12f7c385d589890</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_RowTotal3</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab3_RowTotal3>
                <CrossTab3_ColTotal1 Ref="30" type="CrossColumnTotal" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[185:255:255]</Brush>
                  <ClientRectangle>3.85,0.45,0,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>9224a5e5c585490badff27d9ce3a24ee</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_ColTotal1</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab3_ColTotal1>
                <CrossTitle1 Ref="31" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>0,0,7,0.4</ClientRectangle>
                  <Enabled>False</Enabled>
                  <Font>Arial,8</Font>
                  <Guid>081e288520584dfea9d044759a5e3d92</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTitle1</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Sowing</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>LeftTitle</TypeOfComponent>
                </CrossTitle1>
                <CrossTab3_RowTotal1 Ref="32" type="CrossRowTotal" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[185:255:255]</Brush>
                  <ClientRectangle>6.8,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>a117d819be0c449e8821a9501ee2a065</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_RowTotal1</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab3_RowTotal1>
                <CrossTab3_RowTotal5 Ref="33" type="CrossRowTotal" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[185:255:255]</Brush>
                  <ClientRectangle>9,1.3,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>8d23f68cde9e4f79a12d5f82cb4fc295</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_RowTotal5</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab3_RowTotal5>
                <CrossTab3_Row1_Title Ref="34" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>0,0.45,0.6,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>3649196f728f449fabfdb0a2b67994c3</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row1_Title</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Plot</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>Row:CrossTab3_Row1</TypeOfComponent>
                </CrossTab3_Row1_Title>
                <CrossTab3_Row2_Title Ref="35" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>0.6,0.45,1,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>5cdffd3213a04328880d861ce17ceaba</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row2_Title</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Name</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>Row:CrossTab3_Row2</TypeOfComponent>
                </CrossTab3_Row2_Title>
                <CrossTab3_Row3_Title Ref="36" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>1.6,0.45,1.6,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>ff634846cdc54dd699f8a821a15d180c</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row3_Title</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Genealogy</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>Row:CrossTab3_Row3</TypeOfComponent>
                </CrossTab3_Row3_Title>
                <CrossTab3_Row4_Title Ref="37" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>3.2,0.45,2.4,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>6a051166e47b4778bd6ef0ee19138d96</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row4_Title</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Observ. date</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>Row:CrossTab3_Row4</TypeOfComponent>
                </CrossTab3_Row4_Title>
                <CrossTab3_Row5_Title Ref="38" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>5.6,0.45,1.4,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>1607076fb6ac4025b4a501ceca110159</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row5_Title</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Comment</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>Row:CrossTab3_Row5</TypeOfComponent>
                </CrossTab3_Row5_Title>
                <CrossTab3_RowTotal4 Ref="39" type="CrossRowTotal" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[185:255:255]</Brush>
                  <ClientRectangle>6.6,1.3,4.8,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>37c644b9a4c94b9b9f69a8e3bf92b1ab</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_RowTotal4</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab3_RowTotal4>
                <CrossTab3_RightTitle Ref="40" type="CrossTitle" isKey="true">
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>7.05,0,1.6,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>354b7e18a0a642b281273c46ba217f9c</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_RightTitle</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>trait_name</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TypeOfComponent>RightTitle</TypeOfComponent>
                </CrossTab3_RightTitle>
                <CrossTab3_Row1 Ref="41" type="CrossRow" isKey="true">
                  <Alias>plot</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>0,0.9,0.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.plot}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>b56cf3ef6b2d41a8b63e431a575a096c</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row1</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>plot</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TotalGuid>a117d819be0c449e8821a9501ee2a065</TotalGuid>
                  <Value>{Sowing.plot}</Value>
                </CrossTab3_Row1>
                <CrossTab3_Row2 Ref="42" type="CrossRow" isKey="true">
                  <Alias>nom</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>0.6,0.9,1,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.nom}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>4f3ed52890ff4e5dac51c01731e30417</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row2</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>nom</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TotalGuid>103a8654e8024f65a7b80841d0b2dd1f</TotalGuid>
                  <Value>{Sowing.nom}</Value>
                </CrossTab3_Row2>
                <CrossTab3_Row3 Ref="43" type="CrossRow" isKey="true">
                  <Alias>genealogy</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>1.6,0.9,1.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.genealogy}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>3ec8a9f5898446cc9b1cfaa0c1f39898</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row3</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>genealogy</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TotalGuid>40d6c75853a741d9b12f7c385d589890</TotalGuid>
                  <Value>{Sowing.genealogy}</Value>
                </CrossTab3_Row3>
                <CrossTab3_Row4 Ref="44" type="CrossRow" isKey="true">
                  <Alias>observation_date</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>3.2,0.9,2.4,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.observation_date}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>8d59256196784ebfaab7c1f363ea512a</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Row4</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <SortType>ByValue</SortType>
                  <Text>observation_date</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TotalGuid>37c644b9a4c94b9b9f69a8e3bf92b1ab</TotalGuid>
                  <Value>{Sowing.formatdate}</Value>
                </CrossTab3_Row4>
                <CrossTab3_Row5 Ref="45" type="CrossRow" isKey="true">
                  <Alias>comment</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>5.6,0.9,1.4,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.comment}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>570419f7d9c0433fa808ebb95ed7c0ee</Guid>
                  <HorAlignment>Left</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <MaxSize>3,0</MaxSize>
                  <Name>CrossTab3_Row5</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>comment</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TotalGuid>8d23f68cde9e4f79a12d5f82cb4fc295</TotalGuid>
                  <Value>{Sowing.comment}</Value>
                </CrossTab3_Row5>
                <CrossTab3_Column1 Ref="46" type="CrossColumn" isKey="true">
                  <Alias>trait_name</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>SkyBlue</Brush>
                  <ClientRectangle>7.05,0.45,1.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{Sowing.trait_name}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>ff2016371c884f14abf7d3835638cfb1</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Column1</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <SortType>ByValue</SortType>
                  <Text>trait_name</Text>
                  <TextBrush>[0:56:85]</TextBrush>
                  <TotalGuid>9224a5e5c585490badff27d9ce3a24ee</TotalGuid>
                  <Value>{Sowing.trait_order}</Value>
                </CrossTab3_Column1>
                <CrossTab3_Sum1 Ref="47" type="CrossSummary" isKey="true">
                  <Alias>trait_value</Alias>
                  <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
                  <Brush>[235:255:255]</Brush>
                  <ClientRectangle>7.05,0.9,1.6,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>74b7d40e6c444f7b9f54d7b80bdc2479</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab3_Sum1</Name>
                  <Page isRef="25" />
                  <Parent isRef="27" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Summary>None</Summary>
                  <Text>0</Text>
                  <TextBrush>Black</TextBrush>
                  <Value>{IIF(Sowing.trait_value=="", Sowing.trait_value_id,Sowing.trait_value)}</Value>
                </CrossTab3_Sum1>
              </Components>
              <Conditions isList="true" count="0" />
              <CrossTabStyleIndex>5</CrossTabStyleIndex>
              <DataRelationName />
              <DataSourceName>Sowing</DataSourceName>
              <EmptyValue />
              <Filters isList="true" count="0" />
              <Name>CrossTab3</Name>
              <Page isRef="25" />
              <Parent isRef="26" />
              <PrintTitleOnAllPages>False</PrintTitleOnAllPages>
              <Sort isList="true" count="0" />
            </CrossTab3>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <Filters isList="true" count="0" />
          <Name>DataBand3</Name>
          <Page isRef="25" />
          <Parent isRef="25" />
          <Sort isList="true" count="0" />
        </DataBand3>
      </Components>
      <Conditions isList="true" count="0" />
      <ExcelSheet>By obs. date</ExcelSheet>
      <Guid>74ec26d7194a4520984951d2ff236d16</Guid>
      <Margins>0.4,0.4,1,1</Margins>
      <Name>Details</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <PaperSize>A4</PaperSize>
      <Report isRef="0" />
      <UnlimitedBreakable>False</UnlimitedBreakable>
      <UnlimitedHeight>True</UnlimitedHeight>
      <Watermark Ref="48" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Details>
  </Pages>
  <PrinterSettings Ref="49" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>BreedIT report</ReportAlias>
  <ReportChanged>10/4/2017 3:06:38 PM</ReportChanged>
  <ReportCreated>10/29/2008 12:39:25 PM</ReportCreated>
  <ReportDescription>Liste des n° semis qui ont des tests labos (présence d'un filtre sur DataBand1)</ReportDescription>
  <ReportFile>C:\Users\jennifer.pouillard\Desktop\crossdata report.mrt</ReportFile>
  <ReportGuid>bb529e72c40b4234af900b7bd13d5e13</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2016.1.18</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.ReportControls;
using Stimulsoft.Report.Components;

namespace Reports
{
    
    public class Report : Stimulsoft.Report.StiReport
    {
        
        public Report()
        {
            this.InitializeComponent();
			this.PrinterSettings.PrinterName = "MANCOURGETTES";
        }
        #region StiReport Designer generated code - do not modify
		#endregion StiReport Designer generated code - do not modify
    }
}</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>