<Report ContainerWidth="32000" LayoutWidth="11775" PageMaxRecords="15" PageMinRecords="15" SQLOption="8" FixedPageFooter="-1" TableGridLine="0" TableHeaderHeight="195">
  <!--Created by DataNewReport Designer-->
  <Papers CatalogWidth="50">
    <Style>
      <Pictures />
    </Style>
    <Paper PaperID="1" Title="demo">
      <DNPaper PaperSize="256" PaperWidth="18" PaperHeight="24" Arbitrary="-1" DriverName="CaptureStudioPrint" />
      <Report>
        <Tag>
        </Tag>
      </Report>
      <Os>
        <O Left="0" Top="0" Width="9300" Height="13155" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Align="33" BorderDirection="15" BorderColor="0">
          <Picture>salebg.jpg</Picture>
        </O>
      </Os>
    </Paper>
  </Papers>
  <HETLs Server="" Port="" Application="" User="" Password="" />
  <Variants DateFormat="">
    <Variant Name="code" Title="" Type="0" Value="SA201203180015" 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="PageMoney" Title="" Type="-1" Value="0" Mode="0" Field="" ParentLabel="" UseBDO="0" BDOID="" BDOName="" BDOAlias="" UseAdvance="0" UseIndex="0" UseSET="0" SETName="" SETAlias="">
      <Linkers />
    </Variant>
    <Variant Name="dPageMoneyd" 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 PaperSize="256" PaperWidth="18" PaperHeight="24" Arbitrary="-1" DriverName="CaptureStudioPrint" />
  <DNDb Type="0" ConnectionString="" Server="" Database="" User="" Password="" Sql="select a.sale_code as 销售单号,a.sale_time  as 销售日期,d.pro_code as 商品编号,d.pro_kcode as 款号,d.pro_name as 商品名称,(select color_name from x_color where color_code=d.pro_color) as 颜色,(select vip_cardcode from x_vip where CVar(vip_id)=a.sale_vip) as 会员卡号,(select vip_name from x_vip where CVar(vip_id)=a.sale_vip) as 会员姓名,(select vip_mobile from x_vip where CVar(vip_id)=a.sale_vip) as 会员联系电话,(select size_name from x_size where size_code=d.pro_size) as 尺码,b.saleitem_amount as 商品数量,d.pro_mprice as 吊牌价,b.saleitem_rebate as 折扣,b.saleitem_price as 折后售价,b.saleitem_amount*b.saleitem_price as 小计 from (x_sale a left join x_saleitem b on b.sale_code=a.sale_code) left join x_product d on CVar(d.pro_id)=b.saleitem_pro where a.sale_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>
    <Group GroupBy="" OrderBy="" Sort="1">
      <SectionHeader Name="分组头" Type="9" Height="205" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
        <Os />
      </SectionHeader>
      <SectionFooter Name="分组尾" Type="9" Height="0" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
        <Os />
      </SectionFooter>
    </Group>
  </Groups>
  <Sections>
    <Section Name="明细" Type="0" Height="490" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="'每页的合计数需要累加&#xA;PageMoney = PageMoney + [小计]">
      <Os>
        <O Name="Field1" Text="[商品名称]" Left="1260" Top="0" Width="1620" Height="535" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field3" Text="[颜色]" Left="3240" Top="0" Width="740" Height="535" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field5" Text="[尺码]" Left="3870" Top="0" Width="810" Height="535" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field2" Text="[商品数量]" Left="4500" Top="0" Width="1260" Height="535" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" Align="34" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field4" Text="[折后售价]" Left="5760" Top="0" Width="1260" Height="535" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" NumberFormat="￥#,##0.00" FormatType="2" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field6" Text="[小计]" Left="7110" Top="0" Width="1260" Height="535" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="10" NumberFormat="￥#,##0.00" FormatType="2" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="表头" Type="1" Height="0" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os />
    </Section>
    <Section Name="表尾" Type="2" Height="450" BackStyle="1" BackColor="16777215" OnFormat="">
      <Os />
    </Section>
    <Section Name="页头" Type="3" Height="4055" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat="">
      <Os>
        <O Name="Rectangle1" Text="[销售单号]" Left="6300" Top="1710" Width="2700" Height="360" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="16" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" ForeColor="255" BorderDirection="15" BorderColor="0" />
        <O Name="Rectangle3" Text="[会员卡号]" Left="1620" Top="2430" Width="2970" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="12" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Rectangle4" Text="[会员姓名]" Left="1620" Top="2970" Width="3060" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="12" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field8" Text="[销售日期]" Left="5760" Top="2250" Width="3060" Height="725" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="12" FontBold="1" NumberFormat="yyyy年M月d日" FormatType="3" Align="33" SpacingCol="10" MarginLeft="100" MarginRight="150" BorderDirection="15" BorderColor="0" />
        <O Name="Rectangle2" Text="[会员联系电话]" Left="5760" Top="2970" Width="3060" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" DesignAlign="128" FontSize="12" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
    <Section Name="页尾" Type="4" Height="4695" BackStyle="1" BackColor="16777215" OnFormat="'每页的合计数被重置&#xA;PageMoney = 0">
      <Os>
        <O Name="Rectangle5" Text="PageMoney" Left="7380" Top="90" Width="1260" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontSize="10" FontBold="1" NumberFormat="#,##0.00" FormatType="2" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Field7" Text="GBMoney(PageMoney)" Left="1800" Top="90" Width="5040" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" Calculated="-1" FontSize="14" FontBold="1" NumberFormat="0.00" FormatType="2" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label1" Text="0816-2239160" Left="6210" Top="1080" Width="2070" Height="270" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontSize="12" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
        <O Name="Label2" Text="绵阳市安昌路18号爱喜嘉年华8F" Left="1080" Top="1140" Width="3960" Height="180" CellRow="1" CellCol="1" CellSpanRows="1" CellSpanCols="1" FontSize="12" FontBold="1" Align="33" MarginLeft="100" MarginRight="100" BorderDirection="15" BorderColor="0" />
      </Os>
    </Section>
  </Sections>
</Report>