<?xml version="1.0" encoding="Windows-1252"?>
<Reports>
  <!--Report *** Customers ***-->
  <Report>
    <Name>Customers</Name>
    <DataSource>
      <ConnectionString>C:\temp\test\HierReport\hierData.xml</ConnectionString>
      <RecordSource>Customers</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
      <PaperSize>1</PaperSize>
    </Layout>
    <Font>
      <Name>Microsoft Sans Serif</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>Country</Name>
        <GroupBy>Country</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>2360</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>800</Height>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>500</Height>
      </Section>
      <Section>
        <Name>GroupHeader0</Name>
        <Type>5</Type>
        <Height>490</Height>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Height>195</Height>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Left>48</Left>
        <Top>36</Top>
        <Width>9228</Width>
        <Height>1248</Height>
        <ZOrder>-1</ZOrder>
        <BackStyle>1</BackStyle>
        <BackColor>14481663</BackColor>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>4163021</BorderColor>
      </Field>
      <Field>
        <Name>CustomerIDCtl1</Name>
        <Section>0</Section>
        <Text>CustomerID</Text>
        <Left>90</Left>
        <Top>90</Top>
        <Width>1605</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>CustomerIDCtl</Name>
        <Section>0</Section>
        <Text>CustomerID</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>90</Top>
        <Width>5310</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8</Size>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameCtl1</Name>
        <Section>0</Section>
        <Text>CompanyName</Text>
        <Left>90</Left>
        <Top>390</Top>
        <Width>1605</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameCtl</Name>
        <Section>0</Section>
        <Text>CompanyName</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>390</Top>
        <Width>5310</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8</Size>
        </Font>
      </Field>
      <Field>
        <Name>ContactNameCtl1</Name>
        <Section>0</Section>
        <Text>ContactName</Text>
        <Left>90</Left>
        <Top>690</Top>
        <Width>1605</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>ContactNameCtl</Name>
        <Section>0</Section>
        <Text>ContactName</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>690</Top>
        <Width>5310</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8</Size>
        </Font>
      </Field>
      <Field>
        <Name>ContactNameCtl2</Name>
        <Section>0</Section>
        <Text>Orders</Text>
        <Left>90</Left>
        <Top>990</Top>
        <Width>645</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>fldSROrders</Name>
        <Section>0</Section>
        <Text>"[CustomerID] = '" &amp; [CustomerID] &amp; "'"</Text>
        <Calculated>-1</Calculated>
        <Left>840</Left>
        <Top>1290</Top>
        <Width>8355</Width>
        <Height>810</Height>
        <CanGrow>-1</CanGrow>
        <Subreport>Orders</Subreport>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Customer Orders</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <Font>
          <Name>Arial</Name>
          <Size>24</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>30</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>30</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>5</Section>
        <Left>15</Left>
        <Top>30</Top>
        <Width>9345</Width>
        <Height>15</Height>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>CountryCtl</Name>
        <Section>5</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>30</Left>
        <Top>135</Top>
        <Width>9330</Width>
        <Height>345</Height>
        <Align>3</Align>
        <Font>
          <Name>Arial</Name>
          <Size>12</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
    </Fields>
  </Report>
  <!--Report *** Details ***-->
  <Report>
    <Name>Details</Name>
    <DataSource>
      <ConnectionString>C:\temp\test\HierReport\hierData.xml</ConnectionString>
      <RecordSource>Order Details</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
      <PaperSize>1</PaperSize>
    </Layout>
    <Font>
      <Name>Microsoft Sans Serif</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>216</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>500</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>30</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>30</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>ProductIDLbl</Name>
        <Section>1</Section>
        <Text>ProductID</Text>
        <Left>12</Left>
        <Width>936</Width>
        <Height>240</Height>
        <Align>3</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>QuantityLbl</Name>
        <Section>1</Section>
        <Text>Quantity</Text>
        <Left>972</Left>
        <Width>1605</Width>
        <Height>240</Height>
        <Align>5</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>1</Section>
        <Text>Unit Price</Text>
        <Left>2592</Left>
        <Width>1605</Width>
        <Height>240</Height>
        <Align>5</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>ProductIDCtl</Name>
        <Section>0</Section>
        <Text>ProductID</Text>
        <Calculated>-1</Calculated>
        <Left>12</Left>
        <Width>960</Width>
        <Height>216</Height>
        <Align>0</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityCtl</Name>
        <Section>0</Section>
        <Text>Quantity</Text>
        <Calculated>-1</Calculated>
        <Left>972</Left>
        <Width>1600</Width>
        <Height>210</Height>
        <Align>2</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>2592</Left>
        <Width>1605</Width>
        <Height>210</Height>
        <Align>2</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceCtl1</Name>
        <Section>0</Section>
        <Text>UnitPrice * Quantity</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>4260</Left>
        <Width>1608</Width>
        <Height>216</Height>
        <Align>2</Align>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl1</Name>
        <Section>1</Section>
        <Text>Total Price</Text>
        <Left>4260</Left>
        <Width>1608</Width>
        <Height>240</Height>
        <Align>5</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
    </Fields>
  </Report>
  <!--Report *** Orders ***-->
  <Report>
    <Name>Orders</Name>
    <DataSource>
      <ConnectionString>C:\temp\test\HierReport\hierData.xml</ConnectionString>
      <RecordSource>Orders</RecordSource>
    </DataSource>
    <Layout>
      <Width>9000</Width>
      <Orientation>1</Orientation>
      <PaperSize>1</PaperSize>
    </Layout>
    <Font>
      <Name>Microsoft Sans Serif</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>870</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>20</Height>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>OrderIDLbl</Name>
        <Section>0</Section>
        <Text>"Order ID: " &amp; OrderID</Text>
        <Calculated>-1</Calculated>
        <Left>15</Left>
        <Width>1605</Width>
        <Height>210</Height>
        <Align>3</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Arial</Name>
          <Size>8.25</Size>
          <Bold>-1</Bold>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>0</Section>
        <Text>"[OrderID] = " &amp; [OrderID]</Text>
        <Calculated>-1</Calculated>
        <Left>1725</Left>
        <Width>7275</Width>
        <Height>600</Height>
        <CanGrow>-1</CanGrow>
        <Subreport>Details</Subreport>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Width>6000</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
</Reports>