<Report ContainerWidth="32000" LayoutWidth="11385" FixedPageFooter="-1" TableGridLine="0" TableHeaderHeight="195" OnInit="with ChartReport1.DNChart&#xA;	.Title = &quot;按年份各销售人员销售额对比&quot;&#xA;&#xA;	.XTitle = &quot;年份&quot;&#xA;	.YTitle = &quot;销售额&quot;&#xA;end with&#xA;&#xA;with ChartReport2.DNChart&#xA;	.Title = &quot;按年份订单数量和销售额情况&quot;&#xA;&#xA;	.XTitle = &quot;年份&quot;&#xA;	.YTitle = &quot;数值&quot;&#xA;end with">
  <!--Created by DataNewReport Designer-->
  <HETLs Server="" Port="" Application="" User="" Password="" />
  <Variants DateFormat="">
    <Variant Name="begintime" Title="" Type="0" Value="2012-03-01 10:43:42" AllowDisable="0" Used="0" Editable="0" Mode="0" Field="" ParentLabel="" UseBDO="0" BDOID="" BDOName="" BDOAlias="" UseAdvance="0" UseIndex="0" UseSET="0" SETName="" SETAlias="">
      <Linkers />
    </Variant>
    <Variant Name="endtime" Title="" Type="0" Value="2012-03-31 10:43:42" AllowDisable="0" Used="0" Editable="0" Mode="0" Field="" ParentLabel="" UseBDO="0" BDOID="" BDOName="" BDOAlias="" UseAdvance="0" UseIndex="0" UseSET="0" SETName="" SETAlias="">
      <Linkers />
    </Variant>
  </Variants>
  <Functions />
  <ConvertObjects />
  <DNPaper Arbitrary="-1" />
  <DNDb Type="0" ConnectionString="" Server="" Database="" User="" Password="" Sql="select Format(x_sale.sale_time, 'yyyy-MM')  as 销售日期,SUM(x_saleitem.saleitem_amount) as 销售数量,SUM(x_saleitem.saleitem_amount*x_saleitem.saleitem_price) as 销售金额,SUM(x_saleitem.saleitem_amount*x_product.pro_cost) as 成本,(销售金额-成本) as 利润 from (x_saleitem left join x_product on x_saleitem.saleitem_pro=CVar(x_product.pro_id)) left join x_sale on x_sale.sale_code=x_saleitem.sale_code where x_sale.sale_tmp is null  and x_sale.sale_time between '{begintime}' and '{endtime}' group by Format(x_sale.sale_time,'yyyy-MM')" ProjectPath="" ProjectDbList="" UseBDO="0" BDOID="" BDOName="" BDOAlias="" />
  <DNCrosstab XCondition="0" YCondition="0" YGrandtotal="1" XGrandtotal="1" Section="1">
    <XDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontBold="1" Align="34" BackColor="15921906" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <YDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontBold="1" Align="34" BackColor="16771304" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <ZDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="Arial" Align="36" MarginRight="50" BorderDirection="15" BorderColor="0" />
    <XSubtotalDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="Arial" Align="36" MarginRight="50" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <YSubtotalDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="Arial" Align="36" MarginRight="50" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <XGrandtotalDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="Arial" FontBold="1" Align="36" MarginRight="50" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <YGrandtotalDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="Arial" FontBold="1" Align="36" MarginRight="50" BackColor="8454016" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <XSubtotalTitleDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontBold="1" Align="34" BackColor="15921906" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <YSubtotalTitleDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontBold="1" Align="34" BackColor="16771304" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <XGrandtotalTitleDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontBold="1" Align="34" MarginRight="50" BackColor="15921906" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <YGrandtotalTitleDNObject Left="0" Top="0" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontBold="1" Align="34" MarginRight="50" BackColor="8454016" BackStyle="0" BorderDirection="15" BorderColor="0" />
    <AddCols />
  </DNCrosstab>
  <Groups />
  <Sections>
    <Section Name="明细" Type="0" Height="0" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
      <Os>
        <O Name="day" Text="[销售日期]" Left="450" Top="0" Width="1260" Height="810" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="amount" Text="[销售数量]" Left="1710" Top="0" Width="1260" Height="810" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="money" Text="[销售金额]" Left="2970" Top="0" Width="1260" Height="810" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="cost" Text="[成本]" Left="4500" Top="0" Width="1260" Height="810" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="profit" Text="[利润]" Left="6030" Top="0" Width="1260" Height="810" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="表头" Type="1" Height="130" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os />
    </Section>
    <Section Name="表尾" Type="2" Height="5250" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os>
        <O Name="LegendReport2" Left="90" Top="450" Width="1260" Height="1440" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Shape="15" Align="33" BorderDirection="15" BorderColor="0">
          <DNLegend UnitHeight="160">
            <Legend Title="C1" Color="255" />
            <Legend Title="C2" Color="65280" />
            <Legend Title="C3" Color="16711680" />
          </DNLegend>
        </O>
        <O Name="Chart1" Left="1350" Top="360" Width="9630" Height="4680" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Shape="14" Align="33" MarginLeft="800" MarginRight="800" MarginTop="800" MarginBottom="800" BorderDirection="15" BorderColor="0">
          <DNChart Type="50" Title="月销售图表分析" XTitle="" YTitle="" YScale="5" Label="0" Legend="LegendReport2" Item="day" Value="money|profit" ValueName="销售金额|销售利润" DisplayLegend="0" SubCaption="">
            <NumberAtt DisplayNumber="-1" FormatNumber="0" NumberPrefix="" NumberSuffix="" FormatNumberScale="0" DefaultNumberScale="万" NumberScaleUnit="万,亿" NumberScaleValue="10000,10000" Decimals="0" ForceDecimals="0" YAxisValueDecimals="0" />
            <Colors>
              <Color clr="8421631" Key="明细一" />
              <Color clr="16744448" Key="明细二" />
              <Color clr="16777088" Key="明细三" />
            </Colors>
            <Rows>
              <Row Text="分类一">
                <Column Value="10" Key="明细一" />
                <Column Value="50" Key="明细二" />
                <Column Value="30" Key="明细三" />
              </Row>
              <Row Text="分类二">
                <Column Value="20" Key="明细一" />
                <Column Value="10" Key="明细二" />
                <Column Value="60" Key="明细三" />
              </Row>
              <Row Text="分类三">
                <Column Value="80" Key="明细一" />
                <Column Value="70" Key="明细二" />
                <Column Value="90" Key="明细三" />
              </Row>
            </Rows>
          </DNChart>
        </O>
      </Os>
    </Section>
    <Section Name="页头" Type="3" Height="0" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
      <Os />
    </Section>
    <Section Name="页尾" Type="4" Height="0" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os />
    </Section>
  </Sections>
</Report>