<Report ContainerWidth="32000" LayoutWidth="11385" FixedPageFooter="-1" TableGridLine="0" TableHeaderHeight="175" 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="1900-01-01" 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-07-14" 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="Provider=SQLOLEDB.1;Data Source=20110824-2205;Initial Catalog=MISCM_SQL;User ID=sa;Password=jxcjjm;Persist Security Info=True;" Server="" Database="" User="" Password="" Sql="select 日期 = coalesce(CONVERT(varchar(4), a.sale_addtime, 120),CONVERT(varchar(4), b.saleout_addtime, 120)),销售金额 = isnull(convert(decimal(18,2),a.sale_money), 0),销售成本 = isnull(convert(decimal(18,2),a.sale_cost), 0),退货金额 = isnull(convert(decimal(18,2),b.saleout_money), 0),退货成本 = isnull(convert(decimal(18,2),b.saleout_cost), 0),实际销售金额 = (isnull(convert(decimal(18,2),a.sale_money), 0) - isnull(convert(decimal(18,2),b.saleout_money), 0)),实际销售成本=isnull(convert(decimal(18,2),a.sale_cost), 0)-isnull(convert(decimal(18,2),b.saleout_cost), 0),利润=isnull(convert(decimal(18,2),a.sale_money), 0) - isnull(convert(decimal(18,2),b.saleout_money), 0)-isnull(convert(decimal(18,2),a.sale_cost), 0)+isnull(convert(decimal(18,2),b.saleout_cost), 0) from (select CONVERT(varchar(4), sale_addtime, 120) as sale_addtime,sale_money =sum(convert(decimal(18,2),c.item_amount)*convert(decimal(18,2),c.item_price)),sale_cost =sum(convert(decimal(18,2),c.item_amount)*convert(decimal(18,2),d.pro_cost)) from x_sale b left join x_saleitem c on c.item_sale=b.sale_code left join x_product d on d.pro_id=c.item_pro where 1=1 and b.sale_man in(14,16,17,19,20) and b.sale_tally='2' and b.Sale_addtime between '{begintime}' and '{endtime}' group by  CONVERT(varchar(4), sale_addtime, 120)) A full join (select  CONVERT(varchar(4), saleout_addtime, 120) as saleout_addtime,saleout_money =sum(convert(decimal(18,2),c.item_amount)*convert(decimal(18,2),c.item_price)),saleout_cost =sum(convert(decimal(18,2),c.item_amount)*convert(decimal(18,2),d.pro_cost)) from x_saleout b left join x_saleoutitem c on c.item_saleout=b.saleout_code left join x_product d on d.pro_id=c.item_pro where 1=1 and b.saleout_man in(14,16,17,19,20) and b.saleout_tally='2' and b.Saleout_addtime between '{begintime}' and '{endtime}' group by   CONVERT(varchar(4), saleout_addtime, 120)) B on A.sale_addtime = B.saleout_addtime" ProjectPath="C:\Program Files\DataNew\HappyReport\reports\标准\vbscript\" ProjectDbList="NWind_chs|中文版数据库实例|0|Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\NWind_chs.mdb;Persist Security Info=False||||}NWind_enu|英文版数据库实例|0|Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\NWind_enu.mdb;Persist Security Info=False||||" 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="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="55" 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="90" 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="175" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
      <Os />
    </Section>
    <Section Name="页尾" Type="4" Height="0" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os />
    </Section>
  </Sections>
</Report>