<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Shipping Labels (Code 128, Label 5164)</Name>
    <DataSourceName>Main</DataSourceName>
    <MaxPages>10</MaxPages>
    <ReportInfo>
      <Author>bernardo</Author>
    </ReportInfo>
    <Layout>
      <Width>5685</Width>
      <Margin>360</Margin>
      <MarginTop>720</MarginTop>
      <MarginRight>360</MarginRight>
      <MarginBottom>720</MarginBottom>
      <Orientation>Portrait</Orientation>
      <Columns>2</Columns>
      <ColumnLayout>Labels</ColumnLayout>
      <PaperSize>Letter</PaperSize>
      <LabelSpacingX>144</LabelSpacingX>
    </Layout>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=?(SpecialFolder.MyDocuments)\ComponentOne Samples\Common\C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>SELECT DISTINCT Orders.OrderID,
	Orders.OrderDate,
	Orders.ShippedDate,
	Orders.Freight,
	Orders.ShipName,
	Orders.ShipAddress,
	Orders.ShipCity,
	Orders.ShipRegion,
	Orders.ShipPostalCode,
	Orders.ShipCountry,
	Shippers.CompanyName
FROM 
	(Shippers INNER JOIN Orders
	ON Shippers.ShipperID = Orders.ShipVia) ORDER BY Orders.OrderDate DESC;</RecordSource>
        <RecordSourceType>Text</RecordSourceType>
      </DataSource>
    </DataSources>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Border>
              <Left>
                <Style>Solid</Style>
                <Width>30</Width>
              </Left>
              <Top>
                <Style>Solid</Style>
                <Width>30</Width>
              </Top>
              <Right>
                <Style>Solid</Style>
                <Width>30</Width>
              </Right>
              <Bottom>
                <Style>Solid</Style>
                <Width>30</Width>
              </Bottom>
            </Border>
            <Height>5510</Height>
            <AutoHeight>None</AutoHeight>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnFormat>' randomize 20-char code
id = ""
for i = 1 to 3
	id = id &amp; chr(65 + int(rnd * 1000) mod 20)
next
for i = 4 to 20
	id = id &amp; int(rnd * 1000) mod 10
next

' assign code to fields
bcImage.Text = id
''bcText.Text = id</OnFormat>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>Field25</Name>
        <Section>Detail</Section>
        <Left>2025</Left>
        <Top>270</Top>
        <Width>1350</Width>
        <Height>195</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>OrderDate</Text>
        <Calculated>true</Calculated>
        <Format>Date</Format>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field10</Name>
        <Section>Detail</Section>
        <Left>130</Left>
        <Top>2084</Top>
        <Width>1350</Width>
        <Height>210</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>Shuttle</Text>
        <Align>CenterTop</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field12</Name>
        <Section>Detail</Section>
        <Left>1480</Left>
        <Top>2084</Top>
        <Width>1350</Width>
        <Height>210</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>Area</Text>
        <Align>CenterTop</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field18</Name>
        <Section>Detail</Section>
        <Left>2830</Left>
        <Top>2084</Top>
        <Width>1350</Width>
        <Height>210</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>Exception</Text>
        <Align>CenterTop</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field21</Name>
        <Section>Detail</Section>
        <Left>4180</Left>
        <Top>2084</Top>
        <Width>1350</Width>
        <Height>210</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>Tour</Text>
        <Align>CenterTop</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field22</Name>
        <Section>Detail</Section>
        <Left>130</Left>
        <Top>2294</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>OrderID</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>14.25</Size>
          <Bold>true</Bold>
        </Font>
      </Field>
      <Field>
        <Name>Field23</Name>
        <Section>Detail</Section>
        <Left>1480</Left>
        <Top>2294</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>OrderID mod 17</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>14.25</Size>
          <Bold>true</Bold>
        </Font>
      </Field>
      <Field>
        <Name>Field24</Name>
        <Section>Detail</Section>
        <Left>4180</Left>
        <Top>2294</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>OrderID mod 13</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>14.25</Size>
          <Bold>true</Bold>
        </Font>
      </Field>
      <TextField>
        <Name>Field14</Name>
        <Section>Detail</Section>
        <Left>180</Left>
        <Top>105</Top>
        <Width>1665</Width>
        <Height>360</Height>
        <Align>CenterTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8.25</Size>
        </Font>
        <Text>
          <Expression>CompanyName</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field4</Name>
        <Section>Detail</Section>
        <Left>2025</Left>
        <Top>97</Top>
        <Width>1350</Width>
        <Height>180</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8</Size>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">CMR</Value>
        </Text>
      </TextField>
      <ImageField>
        <Name>Field15</Name>
        <Section>Detail</Section>
        <Left>3555</Left>
        <Top>89</Top>
        <Width>1950</Width>
        <Height>376</Height>
        <PictureAlign>RightTop</PictureAlign>
        <PictureScale>Scale</PictureScale>
        <Picture>
          <Image> </Image>
        </Picture>
      </ImageField>
      <TextField>
        <Name>Field27</Name>
        <Section>Detail</Section>
        <Left>192</Left>
        <Top>599</Top>
        <Width>618</Width>
        <Height>376</Height>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8</Size>
        </Font>
        <Text>
          <Value sys="string">From:</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field17</Name>
        <Section>Detail</Section>
        <Left>192</Left>
        <Top>1202</Top>
        <Width>618</Width>
        <Height>419</Height>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8</Size>
        </Font>
        <Text>
          <Value sys="string">To:</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field1</Name>
        <Section>Detail</Section>
        <Left>990</Left>
        <Top>555</Top>
        <Width>4515</Width>
        <Height>557</Height>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8</Size>
        </Font>
        <Text>
          <Value sys="string">ACME
1 Main Street
Metropolis, USA 34567</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field2</Name>
        <Section>Detail</Section>
        <Left>990</Left>
        <Top>1202</Top>
        <Width>4515</Width>
        <Height>792</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>8</Size>
        </Font>
        <Text>
          <Expression>ShipName &amp; vbcrlf &amp; ShipAddress &amp; vbcrlf &amp; ShipCity &amp; vbcrlf &amp; ShipCountry</Expression>
        </Text>
      </TextField>
      <ShapeField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>555</Top>
        <Width>5685</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <ShapeField>
        <Name>Field5</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>1152</Top>
        <Width>5685</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <ShapeField>
        <Name>Field6</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>2036</Top>
        <Width>5685</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <ShapeField>
        <Name>Field7</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>2759</Top>
        <Width>5685</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <ShapeField>
        <Name>Field8</Name>
        <Section>Detail</Section>
        <Left>1480</Left>
        <Top>2041</Top>
        <Width>0</Width>
        <Height>718</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <ShapeField>
        <Name>Field9</Name>
        <Section>Detail</Section>
        <Left>2830</Left>
        <Top>2041</Top>
        <Width>0</Width>
        <Height>718</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <ShapeField>
        <Name>Field11</Name>
        <Section>Detail</Section>
        <Left>4180</Left>
        <Top>2036</Top>
        <Width>0</Width>
        <Height>718</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <BarCodeField>
        <Name>Field13</Name>
        <Section>Detail</Section>
        <Left>180</Left>
        <Top>2953</Top>
        <Width>5325</Width>
        <Height>989</Height>
        <Text>
          <Expression>ShipCountry</Expression>
        </Text>
        <BarCodeType>Code_128auto</BarCodeType>
        <BarcodeOptions>
          <CaptionPosition>Below</CaptionPosition>
        </BarcodeOptions>
        <Align>CenterTop</Align>
      </BarCodeField>
      <BarCodeField>
        <Name>bcImage</Name>
        <Section>Detail</Section>
        <Left>189</Left>
        <Top>4176</Top>
        <Width>5316</Width>
        <Height>1023</Height>
        <Text>
          <Value>ShipAddress</Value>
        </Text>
        <BarCodeType>Code_128auto</BarCodeType>
        <BarcodeOptions>
          <CaptionPosition>Below</CaptionPosition>
        </BarcodeOptions>
        <Align>CenterTop</Align>
      </BarCodeField>
    </Fields>
    <Culture>en-US</Culture>
  </Report>
</Reports>