<?xml version="1.0"?>
<Reports>
  <!--Report *** 01: Alternating Background (Greenbar report) ***-->
  <Report version="2.5.20061.196">
    <Name>01: Alternating Background (Greenbar report)</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.*, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout />
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
        <OnPrint>cnt = cnt + 1
if cnt mod 2 = 0 then
  detail.backcolor = rgb(200,220,200)
else
  detail.backcolor = rgb(255,255,255)
endif</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2075</Height>
        <BackColor>11829830</BackColor>
      </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>555</Height>
      </Section>
      <Section>
        <Name>GroupHeader0</Name>
        <Type>5</Type>
        <Height>2200</Height>
        <Repeat>-1</Repeat>
        <OnPrint>cnt = 0</OnPrint>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Alternating Background
(Greenbar report)</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>1065</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Left>1260</Left>
        <Top>720</Top>
        <Width>8100</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>1755</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>1750</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>1750</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>1755</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>2140</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report uses the OnPrint event of the detail section to alternate the BackColor property of the section.</Text>
        <Top>1440</Top>
        <Width>9270</Width>
        <Height>540</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>5</Section>
        <Top>720</Top>
        <Width>1170</Width>
        <Height>900</Height>
        <Picture>Picture</Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl1</Name>
        <Section>5</Section>
        <Text>Description</Text>
        <Calculated>-1</Calculated>
        <Left>1260</Left>
        <Top>1095</Top>
        <Width>8010</Width>
        <Height>525</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>225</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 02: Custom Paper Size ***-->
  <Report version="2.5.20061.196">
    <Name>02: Custom Paper Size</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
      <CustomWidth>15840</CustomWidth>
      <CustomHeight>36000</CustomHeight>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2000</Height>
        <BackColor>11829830</BackColor>
      </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>555</Height>
      </Section>
      <Section>
        <Name>GroupHeader0</Name>
        <Type>5</Type>
        <Height>1300</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Custom Paper Size</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>705</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>420</Top>
        <Width>9360</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>855</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>850</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>850</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>855</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1240</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report sets the Layout.CustomWidth and Layout.CustomHeight properties to create a custom paper size (8.5 x 25").
When specified this way, the custom paper size is used regardless of what printers are installed and what paper sizes are actually available.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>990</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>225</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 03: Unbound Images ***-->
  <Report version="2.5.20061.196">
    <Name>03: Unbound Images</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Employees</RecordSource>
    </DataSource>
    <Layout>
      <PageHeader>1</PageHeader>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>2595</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>1820</Height>
        <BackColor>11829830</BackColor>
      </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>LastNameCtl</Name>
        <Section>0</Section>
        <Text>FirstName &amp; " " &amp; LastName</Text>
        <Calculated>-1</Calculated>
        <Left>1260</Left>
        <Top>255</Top>
        <Width>6300</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>AddressCtl</Name>
        <Section>0</Section>
        <Text>Address &amp; vbcrlf &amp; City &amp; vbcrlf &amp; Country</Text>
        <Calculated>-1</Calculated>
        <Left>1260</Left>
        <Top>705</Top>
        <Width>6300</Width>
        <Height>360</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Unbound Images</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report has a field bound to a static image file. The image file can be embedded in the report definition at design time, or it can be a reference to an external file. Use the View|Options menu in the designer to select the option you prefer (check Embed Images).</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>810</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Left>180</Left>
        <Top>255</Top>
        <Width>900</Width>
        <Height>810</Height>
        <ZOrder>1</ZOrder>
        <Picture encoding="base64"> </Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>0</Section>
        <Text>Notes</Text>
        <Calculated>-1</Calculated>
        <Left>1260</Left>
        <Top>1245</Top>
        <Width>6300</Width>
        <Height>900</Height>
        <CanGrow>-1</CanGrow>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>0</Section>
        <Left>180</Left>
        <Top>180</Top>
        <Width>8910</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 04: Bound Images ***-->
  <Report version="2.5.20061.196">
    <Name>04: Bound Images</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Employees</RecordSource>
    </DataSource>
    <Layout>
      <PageHeader>1</PageHeader>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>2915</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>1835</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>915</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>500</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Bound Images</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>LastNameCtl</Name>
        <Section>0</Section>
        <Text>FirstName &amp; " " &amp; LastName</Text>
        <Calculated>-1</Calculated>
        <Left>2340</Left>
        <Top>180</Top>
        <Width>6300</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>AddressCtl</Name>
        <Section>0</Section>
        <Text>Address &amp; vbcrlf &amp; City &amp; vbcrlf &amp; Country</Text>
        <Calculated>-1</Calculated>
        <Left>2340</Left>
        <Top>720</Top>
        <Width>6300</Width>
        <Height>1800</Height>
        <Align>0</Align>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>0</Section>
        <Left>180</Left>
        <Top>180</Top>
        <Width>1980</Width>
        <Height>2340</Height>
        <Picture>Photo</Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report has a field bound to images stored in the database. The field's Picture property is set to the string "Photo", which is the name of a binary field that contains employee photos stored as embedded OLE bitmaps. Images stores as raw byte streams would also work.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>810</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>LastNameLbl</Name>
        <Section>3</Section>
        <Text>NorthWind International</Text>
        <Left>975</Left>
        <Top>30</Top>
        <Width>2610</Width>
        <Height>300</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>3</Section>
        <Top>390</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>LastNameLbl1</Name>
        <Section>3</Section>
        <Text>Employee List</Text>
        <Left>975</Left>
        <Top>465</Top>
        <Width>2610</Width>
        <Height>375</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>3</Section>
        <Top>30</Top>
        <Width>900</Width>
        <Height>810</Height>
        <ZOrder>1</ZOrder>
        <Picture encoding="base64"> </Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 05: Watermark ***-->
  <Report version="2.5.20061.196">
    <Name>05: Watermark</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*

FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout>
      <Picture encoding="base64"> </Picture>
      <PictureScale>2</PictureScale>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>1805</Height>
        <BackColor>11829830</BackColor>
      </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>1300</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Watermark</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>615</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>420</Top>
        <Width>9360</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>855</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>850</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>850</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>855</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1240</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report uses the Layout.Picture property to display an image as a watermark. The watermark is displayed behind the report content. You can control the way the watermark is scaled and the pages on which it should appear using the Layout.PictureAlign and Layout.PictureShow properties. </Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>810</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 06: CanGrow CanShrink ***-->
  <Report version="2.5.20061.196">
    <Name>06: CanGrow CanShrink</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Employees</RecordSource>
    </DataSource>
    <Layout />
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>2915</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2270</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>1260</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>500</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>CanGrow/CanShrink</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>LastNameCtl</Name>
        <Section>0</Section>
        <Text>FirstName &amp; " " &amp; LastName</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>90</Top>
        <Width>3780</Width>
        <Height>360</Height>
        <Align>0</Align>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11829830</BorderColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>AddressCtl</Name>
        <Section>0</Section>
        <Text>Address</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>540</Top>
        <Width>3600</Width>
        <Height>270</Height>
        <Align>0</Align>
        <BorderColor>16777215</BorderColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report has several fields in its detail section. All fields have the CanGrow and CanShrink properties set to true.
Notice how the Name and Address fields grow and push down the Notes field. The Notes field in turn grows and pushes down the blue Country fields. It does not push down the red Country field because it is not directly above it.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>1170</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>LastNameLbl</Name>
        <Section>3</Section>
        <Text>NorthWind International</Text>
        <Left>1200</Left>
        <Top>150</Top>
        <Width>2610</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>3</Section>
        <Top>615</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>LastNameLbl1</Name>
        <Section>3</Section>
        <Text>Employee List</Text>
        <Left>1200</Left>
        <Top>690</Top>
        <Width>2610</Width>
        <Height>405</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>3</Section>
        <Top>120</Top>
        <Width>1170</Width>
        <Height>990</Height>
        <ZOrder>1</ZOrder>
        <Picture encoding="base64"> </Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>AddressCtl1</Name>
        <Section>0</Section>
        <Text>Notes</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>1755</Top>
        <Width>4950</Width>
        <Height>360</Height>
        <Align>0</Align>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11829830</BorderColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>0</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>2205</Top>
        <Width>1800</Width>
        <Height>270</Height>
        <ForeColor>11829830</ForeColor>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11829830</BorderColor>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>0</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>2160</Left>
        <Top>2205</Top>
        <Width>1800</Width>
        <Height>270</Height>
        <ForeColor>11829830</ForeColor>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11829830</BorderColor>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>0</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>4140</Left>
        <Top>2205</Top>
        <Width>1800</Width>
        <Height>270</Height>
        <ForeColor>11829830</ForeColor>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11829830</BorderColor>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>0</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>6120</Left>
        <Top>2205</Top>
        <Width>1800</Width>
        <Height>270</Height>
        <ForeColor>255</ForeColor>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11829830</BorderColor>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field6</Name>
        <Section>0</Section>
        <Text>Nobody will push this down:</Text>
        <Left>4860</Left>
        <Top>945</Top>
        <Width>2640</Width>
        <Height>270</Height>
        <ForeColor>11119017</ForeColor>
      </Field>
      <Field>
        <Name>AddressCtl2</Name>
        <Section>0</Section>
        <Text>City</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>810</Top>
        <Width>3600</Width>
        <Height>270</Height>
        <Align>0</Align>
        <BorderColor>16777215</BorderColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>AddressCtl3</Name>
        <Section>0</Section>
        <Text>Trim(Region &amp; " " &amp; PostalCode)</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>1080</Top>
        <Width>3600</Width>
        <Height>270</Height>
        <Align>0</Align>
        <BorderColor>16777215</BorderColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>AddressCtl5</Name>
        <Section>0</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>1350</Top>
        <Width>3600</Width>
        <Height>270</Height>
        <Align>0</Align>
        <BorderColor>16777215</BorderColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field7</Name>
        <Section>0</Section>
        <Left>4890</Left>
        <Top>1260</Top>
        <Width>2580</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field8</Name>
        <Section>0</Section>
        <Left>7440</Left>
        <Top>1260</Top>
        <Height>810</Height>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>3</LineSlant>
      </Field>
      <Field>
        <Name>Field9</Name>
        <Section>0</Section>
        <Left>7260</Left>
        <Top>1800</Top>
        <Width>165</Width>
        <Height>255</Height>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>2</LineSlant>
      </Field>
      <Field>
        <Name>Field10</Name>
        <Section>0</Section>
        <Left>7440</Left>
        <Top>1800</Top>
        <Width>180</Width>
        <Height>255</Height>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>3</LineSlant>
      </Field>
      <Field>
        <Name>Field11</Name>
        <Section>0</Section>
        <Left>8730</Left>
        <Width>180</Width>
        <Height>2520</Height>
        <BackColor>14599344</BackColor>
        <BackStyle>1</BackStyle>
        <BorderStyle>1</BorderStyle>
        <Anchor>2</Anchor>
      </Field>
      <Field>
        <Name>Field12</Name>
        <Section>0</Section>
        <Text>This will grow because it's Anchored:</Text>
        <Left>4815</Left>
        <Top>360</Top>
        <Width>3510</Width>
        <Height>270</Height>
        <ForeColor>11119017</ForeColor>
      </Field>
      <Field>
        <Name>Field13</Name>
        <Section>0</Section>
        <Left>6300</Left>
        <Top>330</Top>
        <Width>2250</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field14</Name>
        <Section>0</Section>
        <Left>8370</Left>
        <Top>330</Top>
        <Width>180</Width>
        <Height>120</Height>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>3</LineSlant>
      </Field>
      <Field>
        <Name>Field15</Name>
        <Section>0</Section>
        <Left>8370</Left>
        <Top>180</Top>
        <Width>180</Width>
        <Height>150</Height>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>13882323</BorderColor>
        <LineSlant>2</LineSlant>
      </Field>
      <Field>
        <Name>Field16</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 07: Force Page Breaks ***-->
  <Report version="2.5.20061.196">
    <Name>07: Force Page Breaks</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout />
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <OnOpen>cnt = 0</OnOpen>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
        <OnPrint>cnt = cnt + 1
detail.forcepagebreak = "none"

if cnt &gt;= 10 then
  cnt = 0
  detail.forcepagebreak = "after"
endif
</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>1800</Height>
        <BackColor>11829830</BackColor>
      </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>1300</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Force Page Breaks</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>525</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>420</Top>
        <Width>9360</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>855</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>850</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>850</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>855</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1240</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report uses the OnPrint event of the detail section to count how many detail lines have been printed on the current page. When that number equals 10, the script uses the section's ForcePageBreak property to cause a page break.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>810</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Text>cnt</Text>
        <Calculated>-1</Calculated>
        <Width>360</Width>
        <Height>180</Height>
        <Visible>0</Visible>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 08: Global Constant ***-->
  <Report version="2.5.20061.196">
    <Name>08: Global Constant</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout />
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <OnOpen>cnt = 0</OnOpen>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
        <OnPrint>cnt = cnt + 1
detail.forcepagebreak = "none"

if cnt &gt;= linesPerPage then
  cnt = 0
  detail.forcepagebreak = "after"
endif
</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2075</Height>
        <BackColor>11829830</BackColor>
      </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>1300</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>420</Top>
        <Width>9360</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>855</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>850</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>850</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>855</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1240</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Text>cnt</Text>
        <Calculated>-1</Calculated>
        <Width>360</Width>
        <Height>180</Height>
        <Visible>0</Visible>
      </Field>
      <Field>
        <Name>linesPerPage</Name>
        <Section>5</Section>
        <Text>14</Text>
        <Left>7740</Left>
        <Top>90</Top>
        <Width>1530</Width>
        <Height>270</Height>
        <ForeColor>255</ForeColor>
        <Visible>0</Visible>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>linesPerPage1</Name>
        <Section>5</Section>
        <Text>Detail Lines Per Page &gt;&gt;&gt;</Text>
        <Left>3600</Left>
        <Top>90</Top>
        <Width>4050</Width>
        <Height>270</Height>
        <ForeColor>255</ForeColor>
        <Visible>0</Visible>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Global Constant</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>525</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report creates page breaks after a given number of detail lines have been rendered. The number of detail lines per page is defined by the value of an invisible field called "linesPerPage".
A caller application can change the value of the field before renderign the report, thereby changing the number of lines per page in the report.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>990</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 09: Dynamic Page Header ***-->
  <Report version="2.5.20061.196">
    <Name>09: Dynamic Page Header</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout>
      <PageHeader>1</PageHeader>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2205</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>750</Height>
        <CanShrink>-1</CanShrink>
        <OnFormat>odd = (page mod 2 &lt;&gt; 0)
h1odd.Visible = odd
h2odd.Visible = odd
h1even.Visible = not odd
h2even.Visible = not odd</OnFormat>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>545</Height>
      </Section>
      <Section>
        <Name>GroupHeader0</Name>
        <Type>5</Type>
        <Height>1375</Height>
        <ForcePageBreak>1</ForcePageBreak>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Dynamic Page Header</Text>
        <Top>195</Top>
        <Width>9000</Width>
        <Height>615</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>h1odd</Name>
        <Section>3</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Width>3870</Width>
        <Height>300</Height>
        <Align>0</Align>
        <ForeColor>32768</ForeColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>h2odd</Name>
        <Section>3</Section>
        <Text>"Page " &amp; [Page] &amp; " (ODD)"</Text>
        <Calculated>-1</Calculated>
        <Left>5220</Left>
        <Width>3915</Width>
        <Height>300</Height>
        <Align>2</Align>
        <ForeColor>32768</ForeColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>495</Top>
        <Width>7920</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>930</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3765</Left>
        <Top>930</Top>
        <Width>1815</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>5611</Left>
        <Top>925</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7005</Left>
        <Top>930</Top>
        <Width>1275</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3765</Left>
        <Width>1815</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>5536</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>6930</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1315</Top>
        <Width>8300</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report changes the page header section based on the current page number.
This is done with some script attached to the page header's OnFormat event. The script changes the visibility of some fields based on whether the page number is odd or even. 
The report also suppresses the page header on the first page by setting the Layout.PageHeader property to NotWithReportHdr.</Text>
        <Top>900</Top>
        <Width>9000</Width>
        <Height>1260</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>h1even</Name>
        <Section>3</Section>
        <Text>"Page " &amp; [Page] &amp; " (EVEN)"</Text>
        <Calculated>-1</Calculated>
        <Top>300</Top>
        <Width>3870</Width>
        <Height>300</Height>
        <Align>0</Align>
        <ForeColor>12582912</ForeColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>h2even</Name>
        <Section>3</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Left>5220</Left>
        <Top>300</Top>
        <Width>3915</Width>
        <Height>300</Height>
        <Align>2</Align>
        <ForeColor>12582912</ForeColor>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>3</Section>
        <Top>705</Top>
        <Width>9180</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>75</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 10: Gutter ***-->
  <Report version="2.5.20061.196">
    <Name>10: Gutter</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout>
      <Width>8300</Width>
      <MarginLeft>2880</MarginLeft>
      <MarginRight>720</MarginRight>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <OnOpen>gutter = report.layout.marginleft</OnOpen>
    <OnClose>report.layout.marginleft = gutter</OnClose>
    <OnPage>report.layout.marginleft = _
  iif(page mod 2 = 1, gutter, gutter - 1440)
</OnPage>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2075</Height>
        <BackColor>11829830</BackColor>
      </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>1375</Height>
        <ForcePageBreak>1</ForcePageBreak>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Gutter</Text>
        <Top>195</Top>
        <Width>7920</Width>
        <Height>615</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>3960</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>3960</Left>
        <Top>180</Top>
        <Width>4275</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>495</Top>
        <Width>7920</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>930</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3765</Left>
        <Top>930</Top>
        <Width>1815</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>5611</Left>
        <Top>925</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7005</Left>
        <Top>930</Top>
        <Width>1275</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3765</Left>
        <Width>1815</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>5536</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>6930</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1315</Top>
        <Width>8300</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report changes the Layout.MarginLeft property based on the current page number. This creates a "gutter", where odd pages have a larger margin in order to facilitate binding.</Text>
        <Top>1170</Top>
        <Width>7920</Width>
        <Height>810</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>90</Top>
        <Width>8280</Width>
        <Height>15</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 11: Charts ***-->
  <Report version="2.5.20061.196">
    <Name>11: Charts</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout />
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2660</Height>
        <BackColor>11829830</BackColor>
      </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>CategoryName Header</Name>
        <Type>5</Type>
        <Height>4600</Height>
        <ForcePageBreak>1</ForcePageBreak>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Charts</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>615</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>420</Top>
        <Width>9360</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>4155</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>4150</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>4150</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>4155</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>4540</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>Adding charts to reports is easy. All you have to do is add a Chart field to a group header section and set the Chart's DataX and DataY properties to the values you want to display on the chart.
You can show several series by setting the DataY property to a list of fields delimited by semicolons (e.g. "UnitsInStock;ReorderLevel").
The Chart data is automatically scoped to the current report group, so when rendering the "Beverages" section, only data for that category will be charted.
You can customize the chart using the ChartType, GridLines, Use3D, and Palette properties.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>1620</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>5</Section>
        <Left>450</Left>
        <Top>900</Top>
        <Width>8550</Width>
        <Height>3150</Height>
        <PictureScale>1</PictureScale>
        <CustomField asm="C1.Win.C1Report.CustomFields.2" class="C1.Win.C1Report.CustomFields.Chart">
          <DataX>ProductName</DataX>
          <DataY>UnitsInStock;ReorderLevel</DataY>
          <DataColor>8388608</DataColor>
          <Palette>Green;Red</Palette>
          <GridLines>-1</GridLines>
        </CustomField>
      </Field>
      <Field>
        <Name>divLine1</Name>
        <Section>5</Section>
        <Top>270</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 12: Custom Fields ***-->
  <Report version="2.5.20061.196">
    <Name>12: Custom Fields</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.*, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout />
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>240</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>4265</Height>
        <BackColor>11829830</BackColor>
      </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>CategoryName Header</Name>
        <Type>5</Type>
        <Height>1825</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Left>435</Left>
        <Width>3345</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3760</Left>
        <Width>2486</Width>
        <Height>240</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>6286</Left>
        <Width>1381</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7680</Left>
        <Width>1320</Width>
        <Height>240</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Custom Fields</Text>
        <Top>195</Top>
        <Width>9360</Width>
        <Height>615</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>You can create your own custom fields and add them to the report designer palette. To do that, you have to:

1) Create a custom field class that derives from C1.Win.C1Report.Field.
2) Register your custom field assembly in the report designer's settings file.

This is how the Chart and Gradient fields are implemented. The source code for these custom fields is available, you can use it as a starting point to create your own custom fields.

The Chart and Gradient fields are registered in the settings file with this entry:</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>2250</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>5</Section>
        <Top>360</Top>
        <Width>9360</Width>
        <Height>1455</Height>
        <ZOrder>-1</ZOrder>
        <PictureScale>1</PictureScale>
        <CustomField asm="C1.Win.C1Report.CustomFields.2" class="C1.Win.C1Report.CustomFields.Gradient">
          <ColorFrom>11829830</ColorFrom>
        </CustomField>
      </Field>
      <Field>
        <Name>divLine1</Name>
        <Section>5</Section>
        <Top>345</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Left>1260</Left>
        <Top>420</Top>
        <Width>8100</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>16777215</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3760</Left>
        <Top>1375</Top>
        <Width>2486</Width>
        <Height>350</Height>
        <Align>3</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>6286</Left>
        <Top>1375</Top>
        <Width>1381</Width>
        <Height>350</Height>
        <Align>5</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Left>435</Left>
        <Top>1380</Top>
        <Width>3345</Width>
        <Height>345</Height>
        <Align>3</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>In Stock</Text>
        <Left>7680</Left>
        <Top>1380</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <Align>5</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>1765</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>1</Section>
        <Text>&lt;customfields&gt;
  &lt;item value="C1.Win.C1Report.CustomFields;C1.Win.C1Report.CustomFields.Chart" /&gt;
  &lt;item value="C1.Win.C1Report.CustomFields;C1.Win.C1Report.CustomFields.Gradient" /&gt;
&lt;/customfields&gt;
</Text>
        <Left>90</Left>
        <Top>3330</Top>
        <Width>9180</Width>
        <Height>810</Height>
        <ForeColor>9234160</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
        <Font>
          <Name>Courier New</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>5</Section>
        <Top>360</Top>
        <Width>1170</Width>
        <Height>990</Height>
        <Picture>Picture</Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 13: Subtotals and other Aggregates ***-->
  <Report version="2.5.20061.196">
    <Name>13: Subtotals and other Aggregates</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Orders.ShipName, Orders.OrderDate, Sum([Order Details].UnitPrice*[Order Details].Quantity) AS OrderValue
FROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID) INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID
GROUP BY Orders.ShipName, Orders.OrderDate
ORDER BY Orders.ShipName, Orders.OrderDate;
</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>GrandTotal</Name>
      </Group>
      <Group>
        <Name>ShipName</Name>
        <GroupBy>ShipName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>3105</Height>
        <BackColor>11829830</BackColor>
      </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>780</Height>
      </Section>
      <Section>
        <Name>GrandTotal Header</Name>
        <Type>5</Type>
        <Height>2115</Height>
      </Section>
      <Section>
        <Name>GrandTotal Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>GroupHeader0</Name>
        <Type>7</Type>
        <Height>1260</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <Type>8</Type>
        <Height>1500</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Subtotals</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>150</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>150</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ShipNameLbl</Name>
        <Section>7</Section>
        <Text>ShipName</Text>
        <Calculated>-1</Calculated>
        <Top>570</Top>
        <Width>9270</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceLbl</Name>
        <Section>7</Section>
        <Text>Order Amount</Text>
        <Left>3945</Left>
        <Top>990</Top>
        <Width>2625</Width>
        <Height>255</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl</Name>
        <Section>0</Section>
        <Text>OrderDate</Text>
        <Calculated>-1</Calculated>
        <Format>MMM yyyy</Format>
        <Left>1440</Left>
        <Width>2400</Width>
        <Height>255</Height>
        <Align>0</Align>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl</Name>
        <Section>0</Section>
        <Text>OrderValue</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Width>2625</Width>
        <Height>255</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>7</Section>
        <Top>450</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report uses the Sum and Avg aggregate functions to calculate total and average order amounts. The aggregate functions are used in expressions assigned to the Text property of the report fields.
The scope of the aggregate functions is determined by their position in the report. Aggregates in group headers or footers have the scope of the group. Aggregates in the report header or footer have the scope of the entire report.
You can reduce the scope of any aggregate using a second argument called 'domain'. For example, Count(*, OrderValue &gt; 1000) returns the number of orders over $1000.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>2070</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>divLine1</Name>
        <Section>5</Section>
        <Top>60</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>ShipNameLbl1</Name>
        <Section>5</Section>
        <Text>"Order Summary (all customers, " &amp; Format(Now, "MMMM yyyy") &amp; ")"</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>9270</Width>
        <Height>345</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl3</Name>
        <Section>5</Section>
        <Text>Sum(OrderValue)</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Top>675</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl3</Name>
        <Section>5</Section>
        <Text>Total Sales:</Text>
        <Left>1440</Left>
        <Top>675</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl4</Name>
        <Section>5</Section>
        <Text>Avg(OrderValue)</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Top>930</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl4</Name>
        <Section>5</Section>
        <Text>Average Order:</Text>
        <Left>1440</Left>
        <Top>930</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl8</Name>
        <Section>5</Section>
        <Text>Avg(OrderValue, OrderValue &gt; 1000)</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Top>1185</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl8</Name>
        <Section>5</Section>
        <Text>Average Large Order*:</Text>
        <Left>1440</Left>
        <Top>1185</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl1</Name>
        <Section>8</Section>
        <Text>Sum(OrderValue)</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Top>90</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl1</Name>
        <Section>8</Section>
        <Text>Total Sales:</Text>
        <Left>1440</Left>
        <Top>90</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl2</Name>
        <Section>8</Section>
        <Text>Average Order:</Text>
        <Left>1440</Left>
        <Top>345</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl2</Name>
        <Section>8</Section>
        <Text>Avg(OrderValue, OrderValue &gt; 1000)</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Top>600</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl9</Name>
        <Section>8</Section>
        <Text>Average Large Order*:</Text>
        <Left>1440</Left>
        <Top>600</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl9</Name>
        <Section>8</Section>
        <Text>Avg(OrderValue)</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3945</Left>
        <Top>345</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceLbl1</Name>
        <Section>7</Section>
        <Text>Order Date</Text>
        <Left>1440</Left>
        <Top>975</Top>
        <Width>2400</Width>
        <Height>255</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Text>*NOTE: Large Orders are over $1,000.00.</Text>
        <Top>420</Top>
        <Width>9090</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl5</Name>
        <Section>5</Section>
        <Text>Count(*, OrderValue &gt; 1000)</Text>
        <Calculated>-1</Calculated>
        <Left>3945</Left>
        <Top>1440</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl5</Name>
        <Section>5</Section>
        <Text>Large Orders:</Text>
        <Left>1440</Left>
        <Top>1440</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExtendedPriceCtl6</Name>
        <Section>8</Section>
        <Text>Count(*, OrderValue &gt; 1000)</Text>
        <Calculated>-1</Calculated>
        <Left>3945</Left>
        <Top>855</Top>
        <Width>2625</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameCtl6</Name>
        <Section>8</Section>
        <Text>Large Orders:</Text>
        <Left>1440</Left>
        <Top>855</Top>
        <Width>2400</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>8</Section>
        <Left>1080</Left>
        <Top>30</Top>
        <Width>5490</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>4</Section>
        <Top>75</Top>
        <Width>9345</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 14: Page Headers in Subreports ***-->
  <Report version="2.5.20061.196">
    <Name>14: Page Headers in Subreports</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Categories</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
      <PageHeader>1</PageHeader>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>1560</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2250</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>360</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>815</Height>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <Type>5</Type>
        <Height>1620</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Page Headers in Subreports</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>375</Top>
        <Width>2400</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>DescriptionLbl</Name>
        <Section>5</Section>
        <Text>Description</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>825</Top>
        <Width>7290</Width>
        <Height>705</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>5</Section>
        <Top>375</Top>
        <Width>1710</Width>
        <Height>1170</Height>
        <Picture>Picture</Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Text>"[CategoryID] = '" &amp; [CategoryID] &amp; "'"</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Width>9000</Width>
        <Height>1215</Height>
        <CanGrow>-1</CanGrow>
        <Subreport>14a: Subreport</Subreport>
      </Field>
      <Field>
        <Name>ftrRight1</Name>
        <Section>3</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>3</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Text>* NOTE: Items listed in red need to be ordered immediately.</Text>
        <Top>435</Top>
        <Width>9180</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>1</Section>
        <Text>Page Header and Page Footer sections in subreports are not rendered. Instead, the Page Header and Page Footer sections of the main report are used.
If you want your subreports to have sections that repeat across page breaks, add a group to the subreport and place the fields to be repeated in the group's header section. Remember to set the Repeat property of the header section to true so it will repeat on every page break.</Text>
        <Top>990</Top>
        <Width>9270</Width>
        <Height>1170</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 14a: Subreport ***-->
  <Report version="2.5.20061.196">
    <Name>14a: Subreport</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Products</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Tag>20.6825</Tag>
    <Groups>
      <Group>
        <Name>New Group</Name>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <OnFormat>UnitsInStockCtl.ForeColor = _
  iif( UnitsInStock + UnitsOnOrder &gt; ReorderLevel, _
    rgb(0,0,0), _
    rgb(255,0,0))
</OnFormat>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2025</Height>
        <Visible>0</Visible>
        <BackColor>11829830</BackColor>
      </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>705</Height>
      </Section>
      <Section>
        <Name>New Group Header</Name>
        <Type>5</Type>
        <Height>495</Height>
        <Repeat>-1</Repeat>
        <OnPrint>' calculate a value and store it in the report's Tag property
Report.Tag = Avg(UnitPrice)

' store some other values in invisible fields
fMinPrice = Min(UnitPrice)
fMaxPrice = Max(UnitPrice)
fAvgPrice = Avg(UnitPrice)
</OnPrint>
      </Section>
      <Section>
        <Name>New Group Footer</Name>
        <Type>6</Type>
        <Height>600</Height>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>14a: Subreport</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Width>2730</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3420</Left>
        <Width>1980</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>5505</Left>
        <Width>1515</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>*Stock</Text>
        <Left>7050</Left>
        <Width>915</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>DiscontinuedLbl</Name>
        <Section>5</Section>
        <Text>Discont'd</Text>
        <Left>8010</Left>
        <Width>1350</Width>
        <Height>405</Height>
        <Align>4</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>left(ProductName, 30)</Text>
        <Calculated>-1</Calculated>
        <Width>3420</Width>
        <Height>255</Height>
        <Align>0</Align>
        <WordWrap>0</WordWrap>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3420</Left>
        <Width>2055</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>5505</Left>
        <Width>1518</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7043</Left>
        <Width>911</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>DiscontinuedCtl</Name>
        <Section>0</Section>
        <Text>Discontinued</Text>
        <Calculated>-1</Calculated>
        <CheckBox>1</CheckBox>
        <Left>8454</Left>
        <Width>455</Width>
        <Height>250</Height>
        <Align>1</Align>
        <Font>
          <Name>Wingdings</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>435</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Text>* NOTE: This section will not be rendered if this is used as a subreport.</Text>
        <Top>435</Top>
        <Width>9180</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>The headers on this report are placed in a group header section, and its Repeat property is set to true. This causes the headers to repeat at the top of evey page, just as if they were page headers.
This technique is useful in subreports, since the page header and page footer sections of subreports are never rendered (the ones in the main report are rendered instead).</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>990</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>6</Section>
        <Text>invisible fields
(used to transfer data)</Text>
        <Left>180</Left>
        <Top>15</Top>
        <Width>2610</Width>
        <Height>525</Height>
      </Field>
      <Field>
        <Name>fMinPrice</Name>
        <Section>6</Section>
        <Text>6</Text>
        <Left>3240</Left>
        <Top>90</Top>
        <Width>1530</Width>
        <Height>360</Height>
      </Field>
      <Field>
        <Name>fMaxPrice</Name>
        <Section>6</Section>
        <Text>62.5</Text>
        <Left>4860</Left>
        <Top>90</Top>
        <Width>1530</Width>
        <Height>360</Height>
      </Field>
      <Field>
        <Name>fAvgPrice</Name>
        <Section>6</Section>
        <Text>20.6825</Text>
        <Left>6480</Left>
        <Top>90</Top>
        <Width>1530</Width>
        <Height>360</Height>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 15: Retrieve Values from Subreports ***-->
  <Report version="2.5.20061.196">
    <Name>15: Retrieve Values from Subreports</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Categories</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
      <PageHeader>1</PageHeader>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>1245</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2820</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>360</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>815</Height>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <Type>5</Type>
        <Height>1620</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <Type>6</Type>
        <Height>1380</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Retrieve Values from Subreports</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>375</Top>
        <Width>2400</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>DescriptionLbl</Name>
        <Section>5</Section>
        <Text>Description</Text>
        <Calculated>-1</Calculated>
        <Left>1800</Left>
        <Top>825</Top>
        <Width>7290</Width>
        <Height>705</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>5</Section>
        <Top>375</Top>
        <Width>1710</Width>
        <Height>1170</Height>
        <Picture>Picture</Picture>
        <PictureScale>2</PictureScale>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Text>"[CategoryID] = '" &amp; [CategoryID] &amp; "'"</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Width>9000</Width>
        <Height>1215</Height>
        <CanGrow>-1</CanGrow>
        <Subreport>14a: Subreport</Subreport>
      </Field>
      <Field>
        <Name>ftrRight1</Name>
        <Section>3</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>3</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>4</Section>
        <Text>* NOTE: Items listed in red need to be ordered immediately.</Text>
        <Top>360</Top>
        <Width>9180</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>1</Section>
        <Text>In some cases you may want to pass data from the subreport back to the main report. Script variables can't be used for this because each report has its own script scope (this avoids the possibility of conflicting variable names).
To pass data from a subreport back to the main report, you have to store values in the subreport fields or in the Tag property, then have the main report read those values.
In this sample, the subreport calculates the average unit price per product category and stores that value in its Tag property and also in some invisible fields. The main report retrieves and displays those values.</Text>
        <Top>840</Top>
        <Width>9270</Width>
        <Height>1830</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>6</Section>
        <Text>"Average Unit Price for " &amp; CategoryName &amp; ": " &amp; Format(Field2.Subreport.Tag, "c")</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Top>90</Top>
        <Width>5580</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>4</Section>
        <Top>75</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field6</Name>
        <Section>6</Section>
        <Text>Field2.Subreport.Fields("fMinPrice").Value</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>1920</Left>
        <Top>450</Top>
        <Width>6210</Width>
        <Height>270</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field7</Name>
        <Section>6</Section>
        <Text>Field2.Subreport.Fields("fMaxPrice").Value</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>1920</Left>
        <Top>720</Top>
        <Width>6210</Width>
        <Height>270</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field8</Name>
        <Section>6</Section>
        <Text>Field2.Subreport.Fields("fAvgPrice").Value</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>1920</Left>
        <Top>990</Top>
        <Width>6210</Width>
        <Height>270</Height>
        <Align>0</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field9</Name>
        <Section>6</Section>
        <Text>Min Price:</Text>
        <Left>450</Left>
        <Top>450</Top>
        <Width>1350</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field10</Name>
        <Section>6</Section>
        <Text>Max Price:</Text>
        <Left>450</Left>
        <Top>720</Top>
        <Width>1350</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field11</Name>
        <Section>6</Section>
        <Text>Avg Price:</Text>
        <Left>450</Left>
        <Top>990</Top>
        <Width>1350</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 16: Conditional Formatting ***-->
  <Report version="2.5.20061.196">
    <Name>16: Conditional Formatting</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Products</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Tag>32.37</Tag>
    <Groups>
      <Group>
        <Name>New Group</Name>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <OnFormat>If UnitsInStock + UnitsOnOrder &lt; ReorderLevel And Discontinued = False Then
  Detail.BackColor = rgb(255,190,190)
Else
  Detail.BackColor = vbWhite
Endif
</OnFormat>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2025</Height>
        <BackColor>11829830</BackColor>
      </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>705</Height>
      </Section>
      <Section>
        <Name>New Group Header</Name>
        <Type>5</Type>
        <Height>495</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>New Group Footer</Name>
        <Type>6</Type>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Conditional Formatting</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Width>2730</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3150</Left>
        <Width>1980</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>*Stock</Text>
        <Left>5175</Left>
        <Width>915</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>DiscontinuedLbl</Name>
        <Section>5</Section>
        <Text>Discont'd</Text>
        <Left>8010</Left>
        <Width>1350</Width>
        <Height>405</Height>
        <Align>4</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Width>3150</Width>
        <Height>255</Height>
        <Align>6</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3150</Left>
        <Width>1980</Width>
        <Height>255</Height>
        <Align>6</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>5168</Left>
        <Width>911</Width>
        <Height>250</Height>
        <Align>8</Align>
      </Field>
      <Field>
        <Name>DiscontinuedCtl</Name>
        <Section>0</Section>
        <Text>Discontinued</Text>
        <Calculated>-1</Calculated>
        <CheckBox>1</CheckBox>
        <Left>8454</Left>
        <Width>455</Width>
        <Height>250</Height>
        <Align>7</Align>
        <Font>
          <Name>Wingdings</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>435</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Text>* NOTE: Items listed in red need to be ordered immediately.</Text>
        <Top>435</Top>
        <Width>9180</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report lists all products in stock and highlights those that need to be ordered immediately. This is done with a script attached to the detail section's OnFormat event. The script changes the detail section's BackColor depending on the value of the fields UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued.</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>990</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>UnitsInStockCtl2</Name>
        <Section>0</Section>
        <Text>2 * ReorderLevel - UnitsInStock - UnitsOnOrder</Text>
        <Calculated>-1</Calculated>
        <Format>0; ; </Format>
        <Left>6480</Left>
        <Width>1455</Width>
        <Height>255</Height>
        <Align>8</Align>
      </Field>
      <Field>
        <Name>UnitsInStockLbl2</Name>
        <Section>5</Section>
        <Text>Qty to Order</Text>
        <Left>6480</Left>
        <Width>1455</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 17: Running Sums ***-->
  <Report version="2.5.20061.196">
    <Name>17: Running Sums</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Products</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <OnPage>pageSum = 0</OnPage>
    <Groups>
      <Group>
        <Name>UnitPrice</Name>
        <GroupBy>UnitPrice</GroupBy>
        <Sort>2</Sort>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <OnPrint>pageSum = pageSum + UnitsInStock</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>1910</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>600</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>1080</Height>
      </Section>
      <Section>
        <Name>UnitPrice Header</Name>
        <Type>5</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>UnitPrice Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Running Sums</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>780</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>780</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>3</Section>
        <Text>ProductName</Text>
        <Top>105</Top>
        <Width>2880</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>3</Section>
        <Text>UnitPrice</Text>
        <Left>3725</Left>
        <Top>105</Top>
        <Width>1600</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>3</Section>
        <Text>In Stock</Text>
        <Left>5570</Left>
        <Top>105</Top>
        <Width>960</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Width>3690</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3725</Left>
        <Width>1600</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>5570</Left>
        <Width>960</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>3</Section>
        <Top>540</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>UnitsInStockCtl1</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>8130</Left>
        <Width>1065</Width>
        <Height>255</Height>
        <Align>2</Align>
        <RunningSum>2</RunningSum>
      </Field>
      <Field>
        <Name>UnitsInStockLbl1</Name>
        <Section>3</Section>
        <Text>Page Sum</Text>
        <Left>6780</Left>
        <Top>105</Top>
        <Width>1065</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Text>Format(Page, "Total stock listed on page 0 is: ") &amp; Format(pageSum, "#,##0")</Text>
        <Calculated>-1</Calculated>
        <Top>480</Top>
        <Width>8640</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>pageSum</Name>
        <Section>0</Section>
        <Text>pageSum</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>6735</Left>
        <Width>1065</Width>
        <Height>255</Height>
        <Align>2</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl2</Name>
        <Section>3</Section>
        <Text>Overall Sum</Text>
        <Left>7860</Left>
        <Top>105</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>The Field object has a RunningSum property that makes is easy to maintain running sums over groups or over the entire report.
To keep running sums over pages, you need to use script. This report uses a field called "pageSum" which is updated in the OnPage and OnPrint events.</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>990</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>4</Section>
        <Top>450</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 18: Continued Headers ***-->
  <Report version="2.5.20061.196">
    <Name>18: Continued Headers</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Categories.*, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <OnOpen>' calculate a value and store it in the report's Tag property
Report.Tag = Avg(UnitPrice)</OnOpen>
    <Tag>32.37</Tag>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <OnFormat>UnitsInStockCtl.ForeColor = _
  iif( UnitsInStock + UnitsOnOrder &gt; ReorderLevel, _
    rgb(0,0,0), _
    rgb(255,0,0))
</OnFormat>
        <OnPrint>fContinued.Visible = true</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2280</Height>
        <BackColor>11829830</BackColor>
      </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>855</Height>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <Type>5</Type>
        <Height>2145</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <Type>6</Type>
        <Height>75</Height>
        <OnPrint>fContinued.Visible = false</OnPrint>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Continued Headers</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Top>1650</Top>
        <Width>2730</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3150</Left>
        <Top>1650</Top>
        <Width>2325</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>5505</Left>
        <Top>1650</Top>
        <Width>1515</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>*Stock</Text>
        <Left>7050</Left>
        <Top>1650</Top>
        <Width>915</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>DiscontinuedLbl</Name>
        <Section>5</Section>
        <Text>Discont'd</Text>
        <Left>8010</Left>
        <Top>1650</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <Align>4</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Width>3150</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3150</Left>
        <Width>2325</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>5505</Left>
        <Width>1518</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7043</Left>
        <Width>911</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>DiscontinuedCtl</Name>
        <Section>0</Section>
        <Text>Discontinued</Text>
        <Calculated>-1</Calculated>
        <CheckBox>1</CheckBox>
        <Left>8454</Left>
        <Width>455</Width>
        <Height>250</Height>
        <Align>1</Align>
        <Font>
          <Name>Wingdings</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>2085</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Text>* NOTE: Items listed in red need to be ordered immediately.</Text>
        <Top>510</Top>
        <Width>9180</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>Group header sections are repeated across page breaks if their "Repeat" property is set to true. This report uses some script to add a "Continued" label next to group headers that were added because of such page breaks.
The report uses a field called "fContinued" that is initially invisible. The detail section OnPrint event makes "fContinued" visible, and the group footer makes it invisible again. If a page break occurs in the middle of a group, the field is displayed in the group header section.</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>1350</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>5</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Top>1230</Top>
        <Width>3960</Width>
        <Height>420</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fContinued</Name>
        <Section>5</Section>
        <Text>(continued)</Text>
        <Calculated>-1</Calculated>
        <Left>4050</Left>
        <Top>1230</Top>
        <Width>3960</Width>
        <Height>420</Height>
        <Align>0</Align>
        <ForeColor>11829830</ForeColor>
        <Visible>0</Visible>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 19: Sorting ***-->
  <Report version="2.5.20061.196">
    <Name>19: Sorting</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>PARAMETERS
[Sort Report By] string "Product Name" "Product Name|Unit Price|Units In Stock",
[Sort Direction] string "Ascending" "Ascending|Descending";
select * from products;</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <OnOpen>Report.Groups(0).GroupBy = Replace([Sort Report By], " ", "")
Report.Groups(0).Sort = [Sort Direction]</OnOpen>
    <Groups>
      <Group>
        <Name>SortingGroup</Name>
        <GroupBy>UnitPrice</GroupBy>
        <Sort>2</Sort>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <OnPrint>pageSum = pageSum + UnitsInStock</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2195</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>600</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>450</Height>
      </Section>
      <Section>
        <Name>SortingGroup Header</Name>
        <Type>5</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>SortingGroup Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Sorting</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>3</Section>
        <Text>ProductName</Text>
        <Top>105</Top>
        <Width>2880</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>3</Section>
        <Text>UnitPrice</Text>
        <Left>3725</Left>
        <Top>105</Top>
        <Width>1600</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>3</Section>
        <Text>In Stock</Text>
        <Left>5570</Left>
        <Top>105</Top>
        <Width>960</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Width>3690</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>3725</Left>
        <Width>1600</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>5570</Left>
        <Width>960</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>3</Section>
        <Top>540</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>UnitsInStockCtl1</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>6930</Left>
        <Width>1065</Width>
        <Height>255</Height>
        <Align>2</Align>
        <RunningSum>2</RunningSum>
      </Field>
      <Field>
        <Name>UnitsInStockLbl2</Name>
        <Section>3</Section>
        <Text>Overall Sum</Text>
        <Left>6735</Left>
        <Top>105</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>There are two ways to sort data in reports: you can sort the data source object (e.g. using an ORDER BY clause in your Sql statement), or you can add groups to the report and specify how each group should be sorted using the group's "GroupBy" and "Sort" properties.
This report uses a parameterized query and allows you to select the field you want to sort on and the sort direction.</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>1170</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>4</Section>
        <Top>75</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 20: Cross-tab Reports ***-->
  <Report version="2.5.20061.196">
    <Name>20: Cross-tab Reports</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>SELECT Orders.ShipCountry, Categories.CategoryName, Year([OrderDate]) AS OrderYear, Sum([Order Details].[UnitPrice]*[Order Details].[Quantity]-[Discount]) AS SaleAmount, DatePart("q",[OrderDate]) AS OrderQtr
FROM Categories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID) ON Categories.CategoryID = Products.CategoryID
GROUP BY Orders.ShipCountry, Categories.CategoryName, Year([OrderDate]), DatePart("q",[OrderDate])
ORDER BY Orders.ShipCountry, Categories.CategoryName, Year([OrderDate]);
</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>ShipCountry</Name>
        <GroupBy>ShipCountry</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
      <Group>
        <Name>OrderYear</Name>
        <GroupBy>OrderYear</GroupBy>
        <Sort>2</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <Visible>0</Visible>
        <BackColor>14474460</BackColor>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>4440</Height>
        <BackColor>11829830</BackColor>
      </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>555</Height>
      </Section>
      <Section>
        <Name>ShipCountry Header</Name>
        <Type>5</Type>
        <Height>990</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>ShipCountry Footer</Name>
        <Type>6</Type>
        <Height>405</Height>
        <OnPrint>fContinued.Visible = false</OnPrint>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <Type>7</Type>
        <Visible>0</Visible>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <Type>8</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>GroupHeader2</Name>
        <Type>9</Type>
        <Height>255</Height>
        <Repeat>-1</Repeat>
        <OnPrint>fContinued.Visible = true</OnPrint>
      </Section>
      <Section>
        <Name>GroupFooter2</Name>
        <Type>10</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Cross-tab Reports</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameLbl</Name>
        <Section>9</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Width>3240</Width>
        <Height>255</Height>
        <Align>0</Align>
        <HideDuplicates>-1</HideDuplicates>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderYearLbl</Name>
        <Section>9</Section>
        <Text>OrderYear</Text>
        <Calculated>-1</Calculated>
        <Left>3510</Left>
        <Width>990</Width>
        <Height>255</Height>
        <Align>0</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fSales</Name>
        <Section>9</Section>
        <Text>sum(SaleAmount)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>4515</Left>
        <Width>1350</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameLbl1</Name>
        <Section>5</Section>
        <Text>Product Category</Text>
        <Left>180</Left>
        <Top>720</Top>
        <Width>2460</Width>
        <Height>255</Height>
        <Align>3</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderYearLbl1</Name>
        <Section>5</Section>
        <Text>Year</Text>
        <Left>3420</Left>
        <Top>720</Top>
        <Width>1080</Width>
        <Height>255</Height>
        <Align>3</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>SaleAmountLbl1</Name>
        <Section>5</Section>
        <Text>Sales</Text>
        <Left>4515</Left>
        <Top>720</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Align>5</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl1</Name>
        <Section>5</Section>
        <Text>Q1</Text>
        <Left>6015</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>5</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl1</Name>
        <Section>5</Section>
        <Text>ShipCountry</Text>
        <Calculated>-1</Calculated>
        <Top>270</Top>
        <Width>5940</Width>
        <Height>360</Height>
        <Align>0</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>14.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl2</Name>
        <Section>5</Section>
        <Text>Q2</Text>
        <Left>6810</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>5</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl3</Name>
        <Section>5</Section>
        <Text>Q3</Text>
        <Left>7605</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>5</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl4</Name>
        <Section>5</Section>
        <Text>Q4</Text>
        <Left>8400</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>5</Align>
        <ForeColor>11119017</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ2</Name>
        <Section>9</Section>
        <Text>sum(SaleAmount, OrderQtr = 2)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0;#;#</Format>
        <Left>6795</Left>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ3</Name>
        <Section>9</Section>
        <Text>sum(SaleAmount, OrderQtr = 3)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0;#;#</Format>
        <Left>7590</Left>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ4</Name>
        <Section>9</Section>
        <Text>sum(SaleAmount, OrderQtr = 4)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0;#;#</Format>
        <Left>8385</Left>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ1</Name>
        <Section>9</Section>
        <Text>sum(SaleAmount, OrderQtr = 1)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0;#;#</Format>
        <Left>6000</Left>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>6</Section>
        <Width>9345</Width>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11119017</BorderColor>
        <LineSlant>2</LineSlant>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>5</Section>
        <Top>990</Top>
        <Width>9345</Width>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11119017</BorderColor>
        <LineSlant>2</LineSlant>
      </Field>
      <Field>
        <Name>fQ</Name>
        <Section>6</Section>
        <Text>sum(SaleAmount, OrderQtr = 2)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>6780</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ5</Name>
        <Section>6</Section>
        <Text>sum(SaleAmount, OrderQtr = 3)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>7575</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ6</Name>
        <Section>6</Section>
        <Text>sum(SaleAmount, OrderQtr = 4)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>8370</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ7</Name>
        <Section>6</Section>
        <Text>sum(SaleAmount, OrderQtr = 1)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>5985</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fSales1</Name>
        <Section>6</Section>
        <Text>sum(SaleAmount)</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>4500</Left>
        <Top>90</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fContinued</Name>
        <Section>5</Section>
        <Text>(continued)</Text>
        <Left>6015</Left>
        <Top>270</Top>
        <Width>2610</Width>
        <Height>345</Height>
        <Align>0</Align>
        <ForeColor>11119017</ForeColor>
        <Visible>0</Visible>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>11.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>9</Section>
        <Left>5940</Left>
        <Height>255</Height>
        <BorderStyle>1</BorderStyle>
        <BorderColor>11119017</BorderColor>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>4</Section>
        <Top>255</Top>
        <Width>9315</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>1</Section>
        <Text>Cross-tab reports group data in two dimensions (down and across). They are useful for summarizing large amounts of data in a format that cross-references information.

To create cross-tab reports, you will typically start with a GROUP BY query to summarize the data into rows, then use a transformation service to create the grouped columns. The transformation service can be provided by the database server itself, it can be a custom program, or you can use C1Report's built-in domain aggregates.

This report uses the latter approach. The data source has an "OrderQtr" field that contains the quarter when the orders were placed. The report's group header has expressions of the form "sum(SaleAmount, OrderQtr = 1)". These expressions add up all the sales for the corresponding quarter. The report produces the cross-tab view placing four of these expressions side-by-side.

Note that the detail section in this report is hidden. If you make it visible you will see what the underlying data looks like.</Text>
        <Top>975</Top>
        <Width>9270</Width>
        <Height>3435</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>OrderYearLbl2</Name>
        <Section>0</Section>
        <Text>OrderYear</Text>
        <Calculated>-1</Calculated>
        <Left>3510</Left>
        <Width>990</Width>
        <Height>255</Height>
        <Align>0</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fSales2</Name>
        <Section>0</Section>
        <Text>SaleAmount</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0</Format>
        <Left>4515</Left>
        <Width>1350</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>fQ11</Name>
        <Section>0</Section>
        <Text>OrderQtr</Text>
        <Calculated>-1</Calculated>
        <Format>#,##0;#;#</Format>
        <Left>6000</Left>
        <Width>720</Width>
        <Height>255</Height>
        <Align>2</Align>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameLbl2</Name>
        <Section>0</Section>
        <Text>CategoryName</Text>
        <Calculated>-1</Calculated>
        <Left>180</Left>
        <Width>3240</Width>
        <Height>255</Height>
        <Align>0</Align>
        <HideDuplicates>-1</HideDuplicates>
        <WordWrap>0</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 21: Suppress or Force Zeros ***-->
  <Report version="2.5.20061.196">
    <Name>21: Suppress or Force Zeros</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Products</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>300</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2465</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>600</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>500</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Suppress/Force Zeros</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>105</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>3</Section>
        <Text>Product Name</Text>
        <Top>100</Top>
        <Width>2880</Width>
        <Height>400</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>3</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3570</Left>
        <Top>105</Top>
        <Width>2145</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>3</Section>
        <Text>Unit Price</Text>
        <Left>5800</Left>
        <Top>100</Top>
        <Width>1600</Width>
        <Height>400</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>3</Section>
        <Text>Stock</Text>
        <Left>7420</Left>
        <Top>100</Top>
        <Width>960</Width>
        <Height>400</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsOnOrderLbl</Name>
        <Section>3</Section>
        <Text>Order</Text>
        <Left>8400</Left>
        <Top>100</Top>
        <Width>960</Width>
        <Height>400</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Width>3510</Width>
        <Height>300</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3570</Left>
        <Width>2145</Width>
        <Height>300</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>5805</Left>
        <Width>1605</Width>
        <Height>300</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Format>0000</Format>
        <Left>7425</Left>
        <Width>960</Width>
        <Height>300</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsOnOrderCtl</Name>
        <Section>0</Section>
        <Text>UnitsOnOrder</Text>
        <Calculated>-1</Calculated>
        <Format>#</Format>
        <Left>8400</Left>
        <Width>960</Width>
        <Height>300</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>3</Section>
        <Top>540</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>To suppress the display of fields with value zero, set their Format property to "#".
The pound sign is a formatting symbol that displays only significant digits (no leading or trailing zeros).
To force the display of a certain number of digits, use a format like "0000". The zero forces the display of a digit, including leading and trailing zeros.</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>1170</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Top>30</Top>
        <Width>9315</Width>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 22: Print Button ***-->
  <Report version="2.5.20061.196">
    <Name>22: Print Button</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Products</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Tag>20.6825</Tag>
    <Groups>
      <Group>
        <Name>New Group</Name>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
        <OnFormat>UnitsInStockCtl.ForeColor = _
  iif( UnitsInStock + UnitsOnOrder &gt; ReorderLevel, _
    rgb(0,0,0), _
    rgb(255,0,0))
</OnFormat>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>2385</Height>
        <BackColor>11829830</BackColor>
      </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>705</Height>
      </Section>
      <Section>
        <Name>New Group Header</Name>
        <Type>5</Type>
        <Height>495</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>New Group Footer</Name>
        <Type>6</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>22: Print Button</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>0</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>4</Section>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>-1</Calculated>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>250</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Section>5</Section>
        <Text>Product Name</Text>
        <Width>2730</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Section>5</Section>
        <Text>Quantity Per Unit</Text>
        <Left>3150</Left>
        <Width>2325</Width>
        <Height>405</Height>
        <Align>3</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Section>5</Section>
        <Text>Unit Price</Text>
        <Left>5505</Left>
        <Width>1515</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Section>5</Section>
        <Text>*Stock</Text>
        <Left>7050</Left>
        <Width>915</Width>
        <Height>405</Height>
        <Align>5</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>DiscontinuedLbl</Name>
        <Section>5</Section>
        <Text>Discont'd</Text>
        <Left>8010</Left>
        <Width>1350</Width>
        <Height>405</Height>
        <Align>4</Align>
        <ForeColor>11829830</ForeColor>
        <WordWrap>0</WordWrap>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>0</Section>
        <Text>ProductName</Text>
        <Calculated>-1</Calculated>
        <Width>3150</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>0</Section>
        <Text>QuantityPerUnit</Text>
        <Calculated>-1</Calculated>
        <Left>3150</Left>
        <Width>2325</Width>
        <Height>255</Height>
        <Align>0</Align>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>5505</Left>
        <Width>1518</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>0</Section>
        <Text>UnitsInStock</Text>
        <Calculated>-1</Calculated>
        <Left>7043</Left>
        <Width>911</Width>
        <Height>250</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>DiscontinuedCtl</Name>
        <Section>0</Section>
        <Text>Discontinued</Text>
        <Calculated>-1</Calculated>
        <CheckBox>1</CheckBox>
        <Left>8454</Left>
        <Width>455</Width>
        <Height>250</Height>
        <Align>1</Align>
        <Font>
          <Name>Wingdings</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>divLine</Name>
        <Section>5</Section>
        <Top>435</Top>
        <Width>9360</Width>
        <Height>60</Height>
        <BackColor>0</BackColor>
        <BackStyle>1</BackStyle>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>4</Section>
        <Text>* NOTE: This section will not be rendered if this is used as a subreport.</Text>
        <Top>435</Top>
        <Width>9180</Width>
        <Height>270</Height>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>1</Section>
        <Text>This report uses the LinkTarget property to implement a Print button. When the report is exported to Html, and viewed in a browser, clicking the button runs a short script (window.print()) that allows the user to print the report.</Text>
        <Top>900</Top>
        <Width>9270</Width>
        <Height>720</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>4</Section>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <BorderStyle>1</BorderStyle>
        <LineSlant>1</LineSlant>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>1</Section>
        <Text>Print...</Text>
        <Left>180</Left>
        <Top>1710</Top>
        <Width>2520</Width>
        <Height>450</Height>
        <Align>7</Align>
        <BackColor>-2147483633</BackColor>
        <BackStyle>1</BackStyle>
        <BorderStyle>1</BorderStyle>
        <Font>
          <Bold>-1</Bold>
          <Name>Arial</Name>
          <Size>12</Size>
        </Font>
        <LinkTarget>javascript:window.print()</LinkTarget>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 23: Mail Merge ***-->
  <Report version="2.5.20061.196">
    <Name>23: Mail Merge</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>Products</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups />
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>2660</Height>
        <ForcePageBreak>2</ForcePageBreak>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>1695</Height>
        <Visible>0</Visible>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Height>105</Height>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>500</Height>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>23: Mail Merge</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft</Name>
        <Section>4</Section>
        <Text>Now()</Text>
        <Calculated>-1</Calculated>
        <Top>30</Top>
        <Width>9180</Width>
        <Height>300</Height>
        <Align>7</Align>
        <Font>
          <Name>Arial</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>This report has a single calculated field that builds a letter for each 'customer' (actually the products).</Text>
        <Top>975</Top>
        <Width>9270</Width>
        <Height>720</Height>
        <ForeColor>16777215</ForeColor>
        <MarginLeft>200</MarginLeft>
        <CanGrow>-1</CanGrow>
        <CanShrink>-1</CanShrink>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>0</Section>
        <Text>"Hello " + ProductName + "," + vbcrlf + vbcrlf + _
"Your account balance is " + Format(UnitPrice, "Currency") + vbcrlf + vbcrlf + _
"Because you have been such a terrific customer, " + _
"we decided to credit your account with $0.10." + vbcrlf + vbcrlf + _
"Your new account balance will be " + vbcrlf + _
Format(fldBalance + 0.10, "Currency") + vbcrlf + vbcrlf + _
"Congratulations!"</Text>
        <Calculated>-1</Calculated>
        <Top>180</Top>
        <Width>9180</Width>
        <Height>1710</Height>
        <CanGrow>-1</CanGrow>
      </Field>
      <Field>
        <Name>fldBalance</Name>
        <Section>0</Section>
        <Text>UnitPrice</Text>
        <Calculated>-1</Calculated>
        <Left>90</Left>
        <Top>2160</Top>
        <Width>3600</Width>
        <Height>360</Height>
        <Visible>0</Visible>
      </Field>
    </Fields>
  </Report>
  <!--Report *** 24: Group Page Counts ***-->
  <Report version="2.5.20061.196">
    <Name>24: Group Page Counts</Name>
    <ReportInfo />
    <DataSource>
      <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DATADIRECTORY|\c1nwind.mdb;Persist Security Info=False</ConnectionString>
      <RecordSource>PARAMETERS 
         [Beginning Date] DateTime 1/1/1994,
         [Ending Date] DateTime 1/1/1995,
         [Sales Goal] Int 15000;
SELECT DISTINCTROW Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal AS SaleAmount
         FROM Employees INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Employees.EmployeeID = Orders.EmployeeID
         WHERE (((Orders.ShippedDate) Between [Beginning Date] And [Ending Date]));</RecordSource>
    </DataSource>
    <Layout>
      <Orientation>1</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
    </Font>
    <Groups>
      <Group>
        <Name>Country</Name>
        <GroupBy>Country</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
      <Group>
        <Name>LastName</Name>
        <GroupBy>=[LastName] &amp; "," &amp; [FirstName]</GroupBy>
        <Sort>1</Sort>
        <KeepTogether>2</KeepTogether>
      </Group>
      <Group>
        <Name>OrderID</Name>
        <GroupBy>OrderID</GroupBy>
        <Sort>1</Sort>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Type>0</Type>
        <Height>255</Height>
      </Section>
      <Section>
        <Name>Header</Name>
        <Type>1</Type>
        <Height>4355</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Footer</Name>
        <Type>2</Type>
        <Height>1440</Height>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Type>3</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Type>4</Type>
        <Height>845</Height>
        <BackColor>11829830</BackColor>
      </Section>
      <Section>
        <Name>Country_Header</Name>
        <Type>5</Type>
        <Height>465</Height>
        <Repeat>-1</Repeat>
      </Section>
      <Section>
        <Name>Country_Footer</Name>
        <Type>6</Type>
        <Height>780</Height>
        <ForcePageBreak>2</ForcePageBreak>
      </Section>
      <Section>
        <Name>LastName_Header</Name>
        <Type>7</Type>
        <Height>1515</Height>
        <CanShrink>-1</CanShrink>
        <Repeat>-1</Repeat>
        <OnFormat>If SalespersonTotal &gt; [Sales Goal] Then
  ExceededGoalLabel.Visible = True
  SalespersonLine.Visible = True
Else
  ExceededGoalLabel.Visible = False
  SalespersonLine.Visible = False
End If</OnFormat>
      </Section>
      <Section>
        <Name>LastName_Footer</Name>
        <Type>8</Type>
        <Height>645</Height>
      </Section>
      <Section>
        <Name>OrderID_Header</Name>
        <Type>9</Type>
        <Visible>0</Visible>
      </Section>
      <Section>
        <Name>OrderID_Footer</Name>
        <Type>10</Type>
        <Visible>0</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>1</Section>
        <Text>Group Page Counts</Text>
        <Top>200</Top>
        <Width>9360</Width>
        <Height>600</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>18</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>1</Section>
        <Text>"Sales from " &amp; Min(ShippedDate) &amp; " to " &amp; Max(ShippedDate)</Text>
        <Calculated>-1</Calculated>
        <Top>3900</Top>
        <Width>9270</Width>
        <Height>360</Height>
        <Align>6</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>Country</Name>
        <Section>5</Section>
        <Text>Country</Text>
        <Calculated>-1</Calculated>
        <Left>1125</Left>
        <Top>60</Top>
        <Width>2820</Width>
        <Height>330</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>CountryLabel</Name>
        <Section>5</Section>
        <Text>Country:</Text>
        <Top>60</Top>
        <Width>1095</Width>
        <Height>330</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line1</Name>
        <Section>5</Section>
        <Top>465</Top>
        <Width>9346</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>40</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Salesperson</Name>
        <Section>7</Section>
        <Text>=[LastName] &amp; ", " &amp; [FirstName]</Text>
        <Calculated>-1</Calculated>
        <Left>1470</Left>
        <Top>75</Top>
        <Width>3030</Width>
        <Height>285</Height>
        <Font>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>SalespersonLabel</Name>
        <Section>7</Section>
        <Text>Salesperson:</Text>
        <Top>75</Top>
        <Width>1410</Width>
        <Height>285</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderIDLabel</Name>
        <Section>7</Section>
        <Text>Order ID:</Text>
        <Left>1410</Left>
        <Top>1125</Top>
        <Width>945</Width>
        <Height>285</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>SalesAmountLabel</Name>
        <Section>7</Section>
        <Text>Sale Amount:</Text>
        <Left>2688</Left>
        <Top>1125</Top>
        <Width>1365</Width>
        <Height>285</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>ExceededGoalLabel</Name>
        <Section>7</Section>
        <Text>"Exceeded " &amp; Format([Sales Goal], "#,##0") &amp; " Sales Goal!"</Text>
        <Calculated>-1</Calculated>
        <Left>15</Left>
        <Top>495</Top>
        <Width>4905</Width>
        <Height>285</Height>
        <ForeColor>255</ForeColor>
        <CanShrink>-1</CanShrink>
        <Font>
          <Bold>-1</Bold>
          <Italic>-1</Italic>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>SalespersonLine1</Name>
        <Section>7</Section>
        <Top>450</Top>
        <Width>6180</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>255</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>PercentOfSalespersonTotalLabel</Name>
        <Section>7</Section>
        <Text>Percent of
Salesperson's Total:</Text>
        <Left>4338</Left>
        <Top>900</Top>
        <Width>2010</Width>
        <Height>525</Height>
        <Align>1</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>PercentOfCountryTotalLabel</Name>
        <Section>7</Section>
        <Text>Percent of
 Country Total:</Text>
        <Left>6618</Left>
        <Top>900</Top>
        <Width>1485</Width>
        <Height>525</Height>
        <Align>1</Align>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line2</Name>
        <Section>7</Section>
        <Left>1410</Left>
        <Top>1470</Top>
        <Width>7425</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line3</Name>
        <Section>7</Section>
        <Left>1410</Left>
        <Top>1515</Top>
        <Width>7425</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line4</Name>
        <Section>7</Section>
        <Left>1410</Left>
        <Top>825</Top>
        <Width>7425</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line5</Name>
        <Section>7</Section>
        <Left>1410</Left>
        <Top>870</Top>
        <Width>7425</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>OrderID</Name>
        <Section>0</Section>
        <Text>OrderID</Text>
        <Calculated>-1</Calculated>
        <Left>1491</Left>
        <Width>570</Width>
        <Height>255</Height>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>SaleAmount</Name>
        <Section>0</Section>
        <Text>SaleAmount</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>2790</Left>
        <Width>1005</Width>
        <Height>255</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>PercentOfSalespersonTotal</Name>
        <Section>0</Section>
        <Text>=[SaleAmount]/[SalespersonTotal]</Text>
        <Calculated>-1</Calculated>
        <Format>Percent</Format>
        <Left>4785</Left>
        <Width>915</Width>
        <Height>255</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>PercentOfCountryTotal</Name>
        <Section>0</Section>
        <Text>=[SaleAmount]/[CountryTotal]</Text>
        <Calculated>-1</Calculated>
        <Format>Percent</Format>
        <Left>6660</Left>
        <Width>900</Width>
        <Height>255</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>SalespersonTotal</Name>
        <Section>8</Section>
        <Text>=Sum([SaleAmount])</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>2760</Left>
        <Top>240</Top>
        <Width>1140</Width>
        <Height>255</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>EmployeeTotalCaption</Name>
        <Section>8</Section>
        <Text>="Total for " &amp; [Salesperson] &amp; ":"</Text>
        <Calculated>-1</Calculated>
        <Top>240</Top>
        <Width>2670</Width>
        <Height>255</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line6</Name>
        <Section>8</Section>
        <Top>645</Top>
        <Width>8895</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line7</Name>
        <Section>8</Section>
        <Left>2865</Left>
        <Top>90</Top>
        <Width>1125</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line8</Name>
        <Section>8</Section>
        <Left>6765</Left>
        <Top>90</Top>
        <Width>990</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>PercentOfCountryTotal</Name>
        <Section>8</Section>
        <Text>=[SalespersonTotal]/[CountryTotal]</Text>
        <Calculated>-1</Calculated>
        <Format>Percent</Format>
        <Left>6765</Left>
        <Top>240</Top>
        <Width>900</Width>
        <Height>255</Height>
        <Align>2</Align>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>CountryTotalCaption</Name>
        <Section>6</Section>
        <Text>="Total for " &amp; [Country] &amp; ":"</Text>
        <Calculated>-1</Calculated>
        <Top>45</Top>
        <Width>2775</Width>
        <Height>255</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>CountryTotal</Name>
        <Section>6</Section>
        <Text>=Sum([SaleAmount])</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>2880</Left>
        <Top>60</Top>
        <Width>1440</Width>
        <Height>255</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>PercentOfGrandTotal</Name>
        <Section>6</Section>
        <Text>=[CountryTotal]/[GrandTotal]</Text>
        <Calculated>-1</Calculated>
        <Format>Percent</Format>
        <Left>2880</Left>
        <Top>495</Top>
        <Width>1440</Width>
        <Height>255</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>PercentOfGrandTotalLabel</Name>
        <Section>6</Section>
        <Text>="Percent " &amp; [Country] &amp; " is of Grand Total:"</Text>
        <Calculated>-1</Calculated>
        <Left>15</Left>
        <Top>480</Top>
        <Width>2805</Width>
        <Height>255</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line9</Name>
        <Section>6</Section>
        <Top>780</Top>
        <Width>9346</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <BorderColor>8421504</BorderColor>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>PageNumber1</Name>
        <Section>4</Section>
        <Text>=[Country] &amp; " -  " &amp; GroupPage(0) &amp; " of " &amp; GroupPages(0)</Text>
        <Calculated>-1</Calculated>
        <Left>3360</Left>
        <Top>75</Top>
        <Width>5835</Width>
        <Height>285</Height>
        <Align>2</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>DatePrinted1</Name>
        <Section>4</Section>
        <Text>=Format(Date(),"Medium Date")</Text>
        <Calculated>-1</Calculated>
        <Left>1035</Left>
        <Top>75</Top>
        <Width>1440</Width>
        <Height>285</Height>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>PrintedLabel1</Name>
        <Section>4</Section>
        <Text>Printed:</Text>
        <Left>45</Left>
        <Top>75</Top>
        <Width>900</Width>
        <Height>285</Height>
        <Align>2</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>GrandTotal</Name>
        <Section>2</Section>
        <Text>=Sum([SaleAmount])</Text>
        <Calculated>-1</Calculated>
        <Format>Currency</Format>
        <Left>2880</Left>
        <Top>150</Top>
        <Width>1440</Width>
        <Height>255</Height>
        <Align>2</Align>
      </Field>
      <Field>
        <Name>GrandTotalLabel</Name>
        <Section>2</Section>
        <Text>Grand Total:</Text>
        <Left>150</Left>
        <Top>135</Top>
        <Width>2505</Width>
        <Height>255</Height>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line10</Name>
        <Section>2</Section>
        <Left>2880</Left>
        <Top>450</Top>
        <Width>1530</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Line11</Name>
        <Section>2</Section>
        <Left>2880</Left>
        <Top>510</Top>
        <Width>1530</Width>
        <BorderStyle>1</BorderStyle>
        <LineWidth>20</LineWidth>
        <LineSlant>1</LineSlant>
        <Font>
          <Name>Microsoft Sans Serif</Name>
          <Size>9</Size>
        </Font>
      </Field>
      <Field>
        <Name>Group1Counter</Name>
        <Section>7</Section>
        <Text>"Page " &amp; GroupPage(1) &amp; " of " &amp; GroupPages(1) &amp; " for " &amp; LastName</Text>
        <Calculated>-1</Calculated>
        <Left>6210</Left>
        <Top>15</Top>
        <Width>2970</Width>
        <Height>285</Height>
        <Align>2</Align>
        <ForeColor>8388608</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>Group1Counter</Name>
        <Section>5</Section>
        <Text>"Page " &amp; GroupPage(0) &amp; " of " &amp; GroupPages(0) &amp; " for " &amp; Country</Text>
        <Calculated>-1</Calculated>
        <Left>4425</Left>
        <Top>90</Top>
        <Width>4755</Width>
        <Height>285</Height>
        <Align>2</Align>
        <ForeColor>8388608</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Section>1</Section>
        <Text>This report shows how to include page numbers and counts for grouped reports.

C1Report always had two report variables for the current and total number of pages in the report (Page and Pages).

In Version 196, we added two script functions that return the current and total number of pages for the current group. The functions are called GroupPage(g) and GroupPages(g). The "g" parameter specifies which group to use, and can be either an index or the group name.

In the report below, the drag blue fields contain expressions like
    "Page " &amp; GroupPage(0) &amp; " of " &amp; GroupPages(0)

These expressions show the current page within the first group (index zero) and the total number of pages for each instance of the first group (in this example, there are two instances of the first group: UK and USA).</Text>
        <Left>60</Left>
        <Top>840</Top>
        <Width>9195</Width>
        <Height>2880</Height>
        <ForeColor>16777215</ForeColor>
        <CanGrow>-1</CanGrow>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
        </Font>
      </Field>
      <Field>
        <Name>Group1Counter1</Name>
        <Section>6</Section>
        <Text>"Page " &amp; GroupPage(0) &amp; " of " &amp; GroupPages(0) &amp; " for " &amp; Country</Text>
        <Calculated>-1</Calculated>
        <Left>4500</Left>
        <Top>60</Top>
        <Width>4755</Width>
        <Height>285</Height>
        <Align>2</Align>
        <ForeColor>8388608</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <Field>
        <Name>PageNumber2</Name>
        <Section>4</Section>
        <Text>"Report - " &amp; Page &amp; " of " &amp; Pages</Text>
        <Calculated>-1</Calculated>
        <Left>3360</Left>
        <Top>465</Top>
        <Width>5835</Width>
        <Height>285</Height>
        <Align>2</Align>
        <ForeColor>16777215</ForeColor>
        <Font>
          <Bold>-1</Bold>
          <Name>Verdana</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
    </Fields>
  </Report>
</Reports>