<Report ContainerWidth="32000" LayoutWidth="12540" SQLOption="8" FixedPageFooter="-1" TableGridLine="-1" TableHeaderHeight="435" TableFooterHeight="600" TableReportFooterHeight="900">
  <!---->
  <HETLs Server="" Port="" Application="" User="" Password="" />
  <Variants DateFormat="">
    <Variant Name="code" Title="" Type="0" Value="PI201304-0001" 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="schr1" Title="" Type="-1" Value="0" Mode="0" Field="" ParentLabel="" UseBDO="0" BDOID="" BDOName="" BDOAlias="" UseAdvance="0" UseIndex="0" UseSET="8301" SETName="" SETAlias="">
      <Linkers />
    </Variant>
    <Variant Name="schr2" Title="" Type="-1" Value="0" Mode="0" Field="" ParentLabel="" UseBDO="0" BDOID="" BDOName="" BDOAlias="" UseAdvance="0" UseIndex="0" UseSET="28486" SETName="" SETAlias="">
      <Linkers />
    </Variant>
    <Variant Name="schr3" Title="" Type="-1" Value="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=PDX_SQL;User ID=sa;Password=jxcjjm;Persist Security Info=True;" Server="" Database="" User="" Password="" Sql="select a.jh_code as '接货单号',a.jh_time as '时间',a.jh_carcode as '车牌号',(select driver_name from p_driver where driver_id=a.jh_driver)as '驾驶员',a.jh_money as '接货费', a.jh_xfmoney as '现付',a.jh_qfmoney as '欠付',a.jh_remark as '接货备注',a.jh_oper as '操作员',b.chitty_code as '预约单号',(b.chitty_date+' '+b.chitty_time) as '预约时间',(select corp_name from p_corp where corp_id=b.chitty_corp) as '发货人',b.chitty_tel as '发货人电话 ',b.chitty_mobile as '发货人手机 ',b.chitty_company as '发货人所在公司 ',b.chitty_add as '发货人地址 ',(select corp_name from p_corp where corp_id=b.chitty_corp2) as '收货人',b.chitty_tel2 as '收货人电话 ',b.chitty_mobile2 as '收货人手机 ',b.chitty_company2 as '收货人所在公司 ',b.chitty_add2 as '收货人地址 ',(select area_name from p_area where area_id=b.chitty_toarea) as '到站',b.pro_name as '品名',(select pack_name from p_pack where pack_id=b.pro_pack) as '包装类型',b.pro_amount as '件数',b.pro_weight as '重量',b.pro_buck as '体积' from p_jh a left join  p_ychitty b on b.chitty_jhcode=a.jh_code where a.jh_code='{code}'" 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="405" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="schr1=CDbl(schr1)+CDbl([件数])&#xA;schr2=CDbl(schr2)+CDbl([重量])&#xA;schr3=CDbl(schr3)+CDbl([体积])">
      <Os>
        <O Name="Field5" Text="[预约单号]" Left="270" Top="0" Width="1800" Height="405" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field7" Text="[发货人]" Left="2070" Top="0" Width="1800" Height="405" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field9" Text="[品名]" Left="3990" Top="0" Width="2970" Height="405" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field11" Text="[件数]" Left="6930" Top="0" Width="1260" Height="405" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" NumberFormat="0.00" FormatType="2" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field22" Text="[重量]" Left="8190" Top="0" Width="1260" Height="405" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" NumberFormat="0.00" FormatType="2" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field24" Text="[体积]" Left="9450" Top="0" Width="1440" Height="405" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" NumberFormat="0.00" FormatType="2" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="表头" Type="1" Height="1735" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os>
        <O Name="Field4" Text="[驾驶员]" Left="1080" Top="1440" Width="2970" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label1" Text="接货清单" Left="3690" Top="360" Width="2970" Height="360" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="黑体" FontSize="16" FontBold="1" Align="34" MarginLeft="100" MarginRight="100" ForeColor="255" BorderDirection="15" BorderColor="0" />
        <O Name="Label5" Text="驾驶员：" Left="180" Top="1440" Width="1710" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Line3" Left="270" Top="1080" Height="15" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Shape="3" Align="33" BorderStyle="1" BorderDirection="15" BorderColor="0" />
        <O Name="Rectangle1" Text="[接货单号]" Left="1080" Top="1080" Width="2970" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label2" Text="接货单号：" Left="195" Top="1080" Width="1710" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label3" Text="接货车辆：" Left="4425" Top="1080" Width="1710" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Rectangle2" Text="[车牌号]" Left="5325" Top="1080" Width="2070" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label4" Text="接货日期：" Left="8100" Top="1080" Width="1710" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Rectangle3" Text="[时间]" Left="9000" Top="1080" Width="3780" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontName="新宋体" FontSize="10" Align="65" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Line4" Left="4500" Top="765" Width="1365" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Shape="3" Align="33" BorderStyle="1" BorderDirection="15" BorderWidth="5" BorderColor="0" />
        <O Name="Line1" Left="4500" Top="810" Width="1365" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Shape="3" Align="33" BorderStyle="1" BorderDirection="15" BorderWidth="5" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="表尾" Type="2" Height="2070" BackStyle="1" BackColor="16777215" OnFormat="sum1.value=schr1&#xA;sum2.value=schr2&#xA;sum3.value=schr3">
      <Os>
        <O Name="Label11" Text="联系方式：四川绵阳市安昌路18号爱喜嘉年华B座8F" Left="210" Top="165" Width="15" Height="15" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label12" Text="签字人：" Left="8370" Top="630" Width="1260" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontSize="10" FontBold="1" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label13" Text="合计" Left="450" Top="0" Width="1530" Height="450" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="sum1" Text="Sum([件数])" Left="6930" Top="90" Width="1260" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontSize="10" NumberFormat="0.00" FormatType="2" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="sum3" Text="Sum([体积])" Left="9630" Top="90" Width="1260" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontSize="10" NumberFormat="0.00" FormatType="2" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="sum2" Text="Sum([重量])" Left="8190" Top="90" Width="1260" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontSize="10" NumberFormat="0.00" FormatType="2" Align="36" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="页头" Type="3" Height="490" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
      <Os>
        <O Name="Field6" Text="预约单号" Left="540" Top="60" Width="1350" Height="400" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" DesignAlign="128" FontName="新宋体" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field8" Text="发货人" Left="2610" Top="60" Width="1620" Height="400" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" DesignAlign="128" FontName="新宋体" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field10" Text="品名" Left="5040" Top="60" Width="900" Height="400" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" DesignAlign="128" FontName="新宋体" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field12" Text="件数" Left="7020" Top="60" Width="1080" Height="400" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" DesignAlign="128" FontName="新宋体" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field23" Text="重量" Left="8370" Top="60" Width="810" Height="400" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" DesignAlign="128" FontName="新宋体" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field25" Text="体积" Left="9450" Top="60" Width="1440" Height="400" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" DesignAlign="128" FontName="新宋体" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="页尾" Type="4" Height="0" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os />
    </Section>
  </Sections>
</Report>