<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Categories</Name>
    <DataSourceName>Main</DataSourceName>
    <ReportInfo>
      <Author>Work</Author>
      <Keywords>General</Keywords>
    </ReportInfo>
    <Layout />
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=?(SpecialFolder.MyDocuments)\ComponentOne Samples\Common\C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>Categories</RecordSource>
        <RecordSourceType>TableDirect</RecordSourceType>
      </DataSource>
    </DataSources>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Height>510</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Border>
              <CornerRadius>100,100,100,100,100,100,100,100</CornerRadius>
            </Border>
            <Background type="Linear">
              <GradientStops>
                <GradientStop>
                  <Position>0</Position>
                  <Color>FFCC6600</Color>
                </GradientStop>
                <GradientStop>
                  <Position>1</Position>
                  <Color>FFBF6000</Color>
                </GradientStop>
              </GradientStops>
              <StartPoint>0,0</StartPoint>
              <EndPoint>1,1</EndPoint>
            </Background>
            <Height>765</Height>
          </SubSection>
          <SubSection>
            <Height>252</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Height>1380</Height>
          </SubSection>
          <SubSection>
            <Height>513</Height>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Border>
          <Top>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FFA44000</Color>
          </Top>
        </Border>
        <SubSections>
          <SubSection>
            <Height>495</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>180</Left>
        <Top>90</Top>
        <Width>9000</Width>
        <Height>585</Height>
        <Align>LeftMiddle</Align>
        <ForeColor>FFFDEADA</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Size>18</Size>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Categories List</Value>
        </Text>
      </TextField>
      <ImageField>
        <Name>Field3</Name>
        <Section>PageHeader</Section>
        <Left>180</Left>
        <Top>90</Top>
        <Width>1200</Width>
        <Height>1200</Height>
        <PictureAlign>CenterMiddle</PictureAlign>
        <PictureScale>Scale</PictureScale>
        <Picture>
          <Image> </Image>
        </Picture>
      </ImageField>
      <ShapeField>
        <Name>Field4</Name>
        <Section>PageHeader</Section>
        <Left>1560</Left>
        <Top>675</Top>
        <Width>7620</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
        <Line>
          <Width>60</Width>
          <Color>FFA44000</Color>
        </Line>
      </ShapeField>
      <TextField>
        <Name>Field5</Name>
        <Section>PageHeader</Section>
        <Left>1560</Left>
        <Top>90</Top>
        <Width>7620</Width>
        <Height>495</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FFA44000</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">North Wind International</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field5</Name>
        <Section>PageHeader</Section>
        <Left>1560</Left>
        <Top>765</Top>
        <Width>7620</Width>
        <Height>525</Height>
        <Align>LeftTop</Align>
        <ForeColor>FFA44000</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Categories List</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field8</Name>
        <Section>PageFooter</Section>
        <Left>5865</Left>
        <Top>90</Top>
        <Width>3315</Width>
        <Height>315</Height>
        <Align>RightMiddle</Align>
        <ForeColor>FF595959</ForeColor>
        <Text>
          <Expression>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field2</Name>
        <Section>PageHeader</Section>
        <SubSectionIndex>1</SubSectionIndex>
        <Left>180</Left>
        <Top>90</Top>
        <Width>1935</Width>
        <Height>318</Height>
        <Align>RightMiddle</Align>
        <ForeColor>FFA44000</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Category ID</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field6</Name>
        <Section>PageHeader</Section>
        <SubSectionIndex>1</SubSectionIndex>
        <Left>2295</Left>
        <Top>90</Top>
        <Width>3375</Width>
        <Height>318</Height>
        <Align>LeftMiddle</Align>
        <ForeColor>FFA44000</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Category Name</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field7</Name>
        <Section>Detail</Section>
        <Left>2295</Left>
        <Top>90</Top>
        <Width>3375</Width>
        <Height>318</Height>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Verdana</Name>
        </Font>
        <Text>
          <Expression>Name</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field9</Name>
        <Section>Detail</Section>
        <Left>180</Left>
        <Top>90</Top>
        <Width>1935</Width>
        <Height>318</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Verdana</Name>
        </Font>
        <Text>
          <Expression>ID</Expression>
        </Text>
      </TextField>
    </Fields>
  </Report>
  <Report ref="1">
    <Name>Products</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>cnt = 0
</OnOpen>
    <ReportInfo>
      <Author>Work</Author>
      <Keywords>General</Keywords>
    </ReportInfo>
    <Layout />
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=?(SpecialFolder.MyDocuments)\ComponentOne Samples\Common\C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>SELECT c.CategoryID,
c.CategoryName,
p.ProductID as ID,
p.ProductName as Name,
Now as ReleaseDate,
Now as DiscontinuedDate,
1 as Rating,
UnitPrice as Price
FROM Categories c INNER JOIN Products p ON c.CategoryID = p.CategoryID</RecordSource>
      </DataSource>
    </DataSources>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryID</GroupBy>
        <Sort>Ascending</Sort>
        <KeepTogether>KeepWholeGroup</KeepTogether>
        <OutlineLabel>
          <Expression>CategoryName</Expression>
        </OutlineLabel>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Background type="Linear">
          <GradientStops>
            <GradientStop>
              <Position>0</Position>
              <Color>00FFFFFF</Color>
            </GradientStop>
            <GradientStop>
              <Position>1</Position>
              <Color>FFFFFFFF</Color>
            </GradientStop>
          </GradientStops>
        </Background>
        <SubSections>
          <SubSection>
            <Height>370</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnFormat>cnt = cnt + 1

if cnt mod 2 = 0 then
  Detail.Background.StartColor = Rgb(238, 214, 200)
  Detail.Background.EndColor = Rgb(238, 200, 177)
else
  Detail.Background.StartColor = vbWhite
  Detail.Background.EndColor = vbWhite
endif</OnFormat>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Border>
              <CornerRadius>100,100,100,100,100,100,100,100</CornerRadius>
            </Border>
            <Background type="Linear">
              <GradientStops>
                <GradientStop>
                  <Position>0</Position>
                  <Color>FFCC6600</Color>
                </GradientStop>
                <GradientStop>
                  <Position>1</Position>
                  <Color>FFBF6000</Color>
                </GradientStop>
              </GradientStops>
              <StartPoint>0,0</StartPoint>
              <EndPoint>1,1</EndPoint>
            </Background>
            <Height>765</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageHeader</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Border>
              <Top>
                <Style>Solid</Style>
                <Width>15</Width>
              </Top>
            </Border>
            <Height>452</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>CategoryName_Header</Name>
        <SubSections>
          <SubSection>
            <Height>225</Height>
          </SubSection>
          <SubSection>
            <Border>
              <Left>
                <Color>FF708090</Color>
              </Left>
              <Top>
                <Color>FF708090</Color>
              </Top>
              <Right>
                <Color>FF708090</Color>
              </Right>
            </Border>
            <Height>780</Height>
          </SubSection>
          <SubSection>
            <Border>
              <Left>
                <Color>FF708090</Color>
              </Left>
              <Top>
                <Color>FF708090</Color>
              </Top>
              <Right>
                <Color>FF708090</Color>
              </Right>
              <Bottom>
                <Style>Solid</Style>
                <Width>30</Width>
                <Color>FF7B2900</Color>
              </Bottom>
            </Border>
            <Background type="Solid">
              <Color>FFEED6C8</Color>
            </Background>
            <Height>405</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
        <OnFormat>cnt = 0</OnFormat>
      </Section>
      <Section>
        <Name>CategoryName_Footer</Name>
        <SubSections>
          <SubSection>
            <Border>
              <Top>
                <Style>Solid</Style>
                <Width>30</Width>
                <Color>FF7B2900</Color>
              </Top>
            </Border>
          </SubSection>
        </SubSections>
        <Type>GroupFooter1</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>180</Left>
        <Top>90</Top>
        <Width>9000</Width>
        <Height>585</Height>
        <Align>LeftMiddle</Align>
        <ForeColor>FFFDEADA</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Size>18</Size>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Products List</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>fldCategoryName</Name>
        <Section>GroupHeader1</Section>
        <SubSectionIndex>1</SubSectionIndex>
        <Left>441</Left>
        <Top>90</Top>
        <Width>4719</Width>
        <Height>600</Height>
        <ForeColor>FFA44000</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Size>15.75</Size>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Expression>CategoryName</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>441</Left>
        <Top>90</Top>
        <Width>3390</Width>
        <Height>280</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Verdana</Name>
        </Font>
        <Text>
          <Expression>Name</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>4011</Left>
        <Top>90</Top>
        <Width>1821</Width>
        <Height>280</Height>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>Verdana</Name>
        </Font>
        <Text>
          <Expression>ReleaseDate</Expression>
        </Text>
        <Format>Short Date</Format>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>6012</Left>
        <Top>90</Top>
        <Width>1494</Width>
        <Height>280</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Verdana</Name>
        </Font>
        <Text>
          <Expression>Rating</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>7686</Left>
        <Top>90</Top>
        <Width>1494</Width>
        <Height>280</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Verdana</Name>
        </Font>
        <Text>
          <Expression>Price</Expression>
        </Text>
        <Format>Currency</Format>
      </TextField>
      <TextField>
        <Name>Field4</Name>
        <Section>PageFooter</Section>
        <Left>441</Left>
        <Top>90</Top>
        <Width>4299</Width>
        <Height>272</Height>
        <Align>LeftMiddle</Align>
        <Text>
          <Expression>Format(Now, "Medium Date")</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field5</Name>
        <Section>PageFooter</Section>
        <Left>4920</Left>
        <Top>90</Top>
        <Width>4260</Width>
        <Height>272</Height>
        <Align>RightMiddle</Align>
        <Text>
          <Expression>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <SubSectionIndex>2</SubSectionIndex>
        <Left>7686</Left>
        <Top>0</Top>
        <Width>1494</Width>
        <Height>405</Height>
        <Align>RightMiddle</Align>
        <ForeColor>FF7B2900</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Price</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <SubSectionIndex>2</SubSectionIndex>
        <Left>441</Left>
        <Top>0</Top>
        <Width>3390</Width>
        <Height>405</Height>
        <Align>LeftMiddle</Align>
        <ForeColor>FF7B2900</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Product Name</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <SubSectionIndex>2</SubSectionIndex>
        <Left>4011</Left>
        <Top>0</Top>
        <Width>1821</Width>
        <Height>405</Height>
        <Align>CenterMiddle</Align>
        <ForeColor>FF7B2900</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Release Date</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <SubSectionIndex>2</SubSectionIndex>
        <Left>6012</Left>
        <Top>0</Top>
        <Width>1494</Width>
        <Height>405</Height>
        <Align>RightMiddle</Align>
        <ForeColor>FF7B2900</ForeColor>
        <Font>
          <Name>Verdana</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Rating</Value>
        </Text>
      </TextField>
    </Fields>
  </Report>
</Reports>