<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Charts</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <Layout>
      <Width>10755</Width>
      <Margin>576</Margin>
      <MarginTop>576</MarginTop>
      <MarginRight>576</MarginRight>
      <MarginBottom>576</MarginBottom>
      <Orientation>Portrait</Orientation>
      <PaperSize>A4</PaperSize>
    </Layout>
    <Font>
      <Name>Corbel</Name>
      <Size>10</Size>
    </Font>
    <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 Categories.CategoryName, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID;
</RecordSource>
      </DataSource>
    </DataSources>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>Ascending</Sort>
        <OutlineLabel>
          <Expression>CategoryName</Expression>
        </OutlineLabel>
      </Group>
      <Group>
        <Name>New Group1</Name>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <Height>360</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>' -- style script start
detail.BackColor = iif(_styleCtr mod 2 = 0, rgb(255,255,255),rgb(239,239,239))
_styleCtr = _styleCtr + 1
' -- style script end
</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>5310</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Height>570</Height>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
        <Repeat>true</Repeat>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <PrintAtPageBottom>true</PrintAtPageBottom>
            <Height>555</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>5055</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
        <ForcePageBreak>Before</ForcePageBreak>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupFooter1</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>New Group1_Header</Name>
        <SubSections>
          <SubSection>
            <Height>654</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader2</Type>
        <Repeat>true</Repeat>
      </Section>
      <Section>
        <Name>New Group1_Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>GroupFooter2</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>3580</Width>
        <Height>336</Height>
        <MarginLeft>700</MarginLeft>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>ProductName</Text>
        <Calculated>true</Calculated>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>Detail</Section>
        <Left>3750</Left>
        <Top>0</Top>
        <Width>2430</Width>
        <Height>336</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>QuantityPerUnit</Text>
        <Calculated>true</Calculated>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>Detail</Section>
        <Left>6390</Left>
        <Top>0</Top>
        <Width>2355</Width>
        <Height>336</Height>
        <Text>UnitPrice</Text>
        <Calculated>true</Calculated>
        <Format>Currency</Format>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>Detail</Section>
        <Left>9060</Left>
        <Top>0</Top>
        <Width>1500</Width>
        <Height>336</Height>
        <Text>UnitsInStock</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <ShapeField>
        <Name>Field4</Name>
        <Background type="Solid">
          <Color>FFE4E4E4</Color>
        </Background>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>350</Top>
        <Width>10755</Width>
        <Height>0</Height>
        <ZOrder>2</ZOrder>
        <Shape type="LineShape" />
        <Line>
          <Color>FFE4E4E4</Color>
        </Line>
      </ShapeField>
      <Field>
        <Name>Field40</Name>
        <Background type="Solid">
          <Color>FFF1F1F1</Color>
        </Background>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>10755</Width>
        <Height>1110</Height>
        <ZOrder>-9</ZOrder>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
        </Font>
      </Field>
      <Field>
        <Name>Field44</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>6525</Width>
        <Height>1110</Height>
        <MarginLeft>576</MarginLeft>
        <MarginBottom>172.8</MarginBottom>
        <Text>Charts</Text>
        <Align>LeftBottom</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>23</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field47</Name>
        <Section>Header</Section>
        <Left>6525</Left>
        <Top>0</Top>
        <Width>4230</Width>
        <Height>1110</Height>
        <MarginRight>244.8</MarginRight>
        <PictureAlign>RightMiddle</PictureAlign>
        <Font>
          <Name>Segoe UI Light</Name>
        </Font>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>ftrLeft2</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1380</Top>
        <Width>5164</Width>
        <Height>435</Height>
        <MarginLeft>576</MarginLeft>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Format>Long Date</Format>
        <Align>LeftMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field7</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>2235</Top>
        <Width>10755</Width>
        <Height>2310</Height>
        <MarginLeft>576</MarginLeft>
        <AutoHeight>GrowAndShrink</AutoHeight>
        <Text>How to add charts to your report:
 o   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.
 o   You can show several series by setting the DataY property to a list of fields delimited by semicolons (e.g. "UnitsInStock; ReorderLevel").
 o   The chart’s data is automatically scoped to the current report group, so when rendering the "Beverages" section, only data for that category will be charted.
 o   You can customize the chart using the ChartType, GridLines and Palette properties.
</Text>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <ShapeField>
        <Name>Field3</Name>
        <Background type="Solid">
          <Color>FFF1F1F1</Color>
        </Background>
        <Section>PageHeader</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>10755</Width>
        <Height>570</Height>
        <ZOrder>-15</ZOrder>
      </ShapeField>
      <Field>
        <Name>FirstLetterofName</Name>
        <Section>PageHeader</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>6525</Width>
        <Height>570</Height>
        <MarginLeft>576</MarginLeft>
        <Text>CategoryName</Text>
        <Calculated>true</Calculated>
        <Align>LeftMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>14.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>Field60</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFD9D9D9</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFD9D9D9</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFD9D9D9</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFD9D9D9</Color>
          </Bottom>
        </Border>
        <Section>PageFooter</Section>
        <Left>0</Left>
        <Top>225</Top>
        <Width>10755</Width>
        <Height>60</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>PageFooter</Section>
        <Left>6180</Left>
        <Top>255</Top>
        <Width>4575</Width>
        <Height>300</Height>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>true</Calculated>
        <Align>RightMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Segoe UI</Name>
          <Size>8</Size>
        </Font>
      </Field>
      <ChartField>
        <Name>Field2</Name>
        <Section>GroupHeader1</Section>
        <Left>576</Left>
        <Top>0</Top>
        <Width>10179</Width>
        <Height>5055</Height>
        <ColorGeneration>CustomByDataColor</ColorGeneration>
        <DataColor>FFC29EC4</DataColor>
        <DefaultStyle>
          <Font>
            <Name>Segoe UI Light</Name>
          </Font>
        </DefaultStyle>
        <Header>
          <Visible>false</Visible>
        </Header>
        <Legend>
          <Visible>true</Visible>
          <Style>
            <Font>
              <Name>Segoe UI Light</Name>
              <Size>10.5</Size>
            </Font>
          </Style>
        </Legend>
        <ChartGroups2D>
          <Group0>
            <ChartType>Area</ChartType>
            <Use3D>true</Use3D>
            <OutlineColor>FF808080</OutlineColor>
            <ChartData>
              <IsForEachRecord>true</IsForEachRecord>
              <CategoryGroups>
                <ChartDataGroup>
                  <Name>Field2_CategoryGroup0</Name>
                  <GroupExpression>ProductID</GroupExpression>
                </ChartDataGroup>
              </CategoryGroups>
              <SeriesValues>
                <ChartDataSeries>
                  <Label>Units In Stock</Label>
                  <DataValues>
                    <ChartDataValue>
                      <ValueExpression>UnitsInStock</ValueExpression>
                    </ChartDataValue>
                  </DataValues>
                  <DataLabel>
                    <Offset>300</Offset>
                    <Text>{#YVAL}</Text>
                  </DataLabel>
                </ChartDataSeries>
                <ChartDataSeries>
                  <Label>ReorderLevel</Label>
                  <DataValues>
                    <ChartDataValue>
                      <ValueExpression>ReorderLevel</ValueExpression>
                    </ChartDataValue>
                  </DataValues>
                  <DataLabel>
                    <Offset>300</Offset>
                    <Text>{#YVAL}</Text>
                  </DataLabel>
                </ChartDataSeries>
              </SeriesValues>
            </ChartData>
            <Pie>
              <LegendLayout>Percentage</LegendLayout>
            </Pie>
          </Group0>
        </ChartGroups2D>
        <ChartArea2D>
          <AxisX>
            <Rotation>Rotate0</Rotation>
          </AxisX>
          <AxisY>
            <NoAnnoOverlap>true</NoAnnoOverlap>
            <Rotation>Rotate270</Rotation>
          </AxisY>
          <AxisY2>
            <Rotation>Rotate90</Rotation>
          </AxisY2>
        </ChartArea2D>
      </ChartField>
      <ShapeField>
        <Name>Field5</Name>
        <Background type="Solid">
          <Color>FFF8F8F8</Color>
        </Background>
        <Section>GroupHeader2</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>10755</Width>
        <Height>654</Height>
        <ZOrder>-15</ZOrder>
      </ShapeField>
      <Field>
        <Name>ProductNameLabel1</Name>
        <Section>GroupHeader2</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>3580</Width>
        <Height>654</Height>
        <MarginLeft>700</MarginLeft>
        <Text>Product Name</Text>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLabel1</Name>
        <Section>GroupHeader2</Section>
        <Left>3750</Left>
        <Top>0</Top>
        <Width>2430</Width>
        <Height>654</Height>
        <Text>Quantity Per Unit</Text>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLabel1</Name>
        <Section>GroupHeader2</Section>
        <Left>6390</Left>
        <Top>0</Top>
        <Width>2355</Width>
        <Height>654</Height>
        <Text>Unit Price</Text>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLabel1</Name>
        <Section>GroupHeader2</Section>
        <Left>9060</Left>
        <Top>0</Top>
        <Width>1500</Width>
        <Height>654</Height>
        <Text>In Stock</Text>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
    </Fields>
    <Culture>en-US</Culture>
  </Report>
</Reports>