<?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 />
    <Font>
      <Name>Corbel</Name>
      <Size>10</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <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>
    </DataSources>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>Ascending</Sort>
        <OutlineLabel>
          <Expression>CategoryName</Expression>
        </OutlineLabel>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>240</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>3665</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>
        <Background type="Solid">
          <Color>FF383265</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>500</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>6375</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
        <ForcePageBreak>Before</ForcePageBreak>
        <Repeat>true</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupFooter1</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>Header</Section>
        <Left>105</Left>
        <Top>915</Top>
        <Width>2235</Width>
        <Height>435</Height>
        <Text>Charts</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF7030A0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>20.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>PageFooter</Section>
        <Left>4680</Left>
        <Top>180</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>true</Calculated>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>CategoryNameLbl</Name>
        <Background type="Solid">
          <Color>FF604A7B</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>0</Left>
        <Top>420</Top>
        <Width>9360</Width>
        <Height>345</Height>
        <Text>CategoryName</Text>
        <Calculated>true</Calculated>
        <Align>LeftBottom</Align>
        <ForeColor>FFF2F2F2</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Tahoma</Name>
          <Size>12</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>345</Left>
        <Top>5850</Top>
        <Width>3285</Width>
        <Height>345</Height>
        <MarginLeft>60</MarginLeft>
        <MarginRight>60</MarginRight>
        <Anchor>TopAndBottom</Anchor>
        <Text>Product Name</Text>
        <Align>LeftBottom</Align>
        <ForeColor>FF595959</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitLbl</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>3705</Left>
        <Top>5850</Top>
        <Width>2486</Width>
        <Height>345</Height>
        <MarginLeft>60</MarginLeft>
        <MarginRight>60</MarginRight>
        <Anchor>TopAndBottom</Anchor>
        <Text>Quantity Per Unit</Text>
        <Align>LeftBottom</Align>
        <ForeColor>FF595959</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>6240</Left>
        <Top>5850</Top>
        <Width>1381</Width>
        <Height>345</Height>
        <MarginLeft>60</MarginLeft>
        <MarginRight>60</MarginRight>
        <Anchor>TopAndBottom</Anchor>
        <Text>Unit Price</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF595959</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFFFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>7650</Left>
        <Top>5850</Top>
        <Width>1320</Width>
        <Height>345</Height>
        <MarginLeft>60</MarginLeft>
        <MarginRight>60</MarginRight>
        <Anchor>TopAndBottom</Anchor>
        <Text>In Stock</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF595959</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>Detail</Section>
        <Left>435</Left>
        <Top>0</Top>
        <Width>3345</Width>
        <Height>240</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>ProductName</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>QuantityPerUnitCtl</Name>
        <Section>Detail</Section>
        <Left>3760</Left>
        <Top>0</Top>
        <Width>2486</Width>
        <Height>240</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>QuantityPerUnit</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>Detail</Section>
        <Left>6286</Left>
        <Top>0</Top>
        <Width>1381</Width>
        <Height>240</Height>
        <Text>UnitPrice</Text>
        <Calculated>true</Calculated>
        <Format>Currency</Format>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>Detail</Section>
        <Left>7680</Left>
        <Top>0</Top>
        <Width>1320</Width>
        <Height>240</Height>
        <Text>UnitsInStock</Text>
        <Calculated>true</Calculated>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1665</Top>
        <Width>9270</Width>
        <Height>1740</Height>
        <MarginLeft>200</MarginLeft>
        <AutoHeight>CanGrow</AutoHeight>
        <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>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <ChartField>
        <Name>Field2</Name>
        <Section>GroupHeader1</Section>
        <Left>420</Left>
        <Top>900</Top>
        <Width>8550</Width>
        <Height>4830</Height>
        <ColorGeneration>CustomByDataColor</ColorGeneration>
        <DataColor>FFCDDC39</DataColor>
        <Legend>
          <Visible>true</Visible>
        </Legend>
        <ChartGroups2D>
          <Group0>
            <ChartType>Area</ChartType>
            <Use3D>true</Use3D>
            <OutlineColor>FF808080</OutlineColor>
            <ChartData>
              <IsForEachRecord>true</IsForEachRecord>
              <CategoryGroups>
                <ChartDataGroup>
                  <GroupExpression>ProductID</GroupExpression>
                </ChartDataGroup>
              </CategoryGroups>
              <SeriesValues>
                <ChartDataSeries>
                  <Label>UnitsInStock</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>
            <Rotation>Rotate270</Rotation>
          </AxisY>
          <AxisY2>
            <Rotation>Rotate90</Rotation>
          </AxisY2>
          <PlotArea>
            <View3D>
              <Depth>10</Depth>
              <Rotation>45</Rotation>
              <Elevation>45</Elevation>
            </View3D>
          </PlotArea>
        </ChartArea2D>
      </ChartField>
      <Field>
        <Name>Field</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
          </Bottom>
        </Border>
        <Section>PageFooter</Section>
        <Left>0</Left>
        <Top>150</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <Font>
          <Name>Corbel</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>Header</Section>
        <Left>30</Left>
        <Top>165</Top>
        <Width>4065</Width>
        <Height>600</Height>
        <PictureScale>Scale</PictureScale>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>Header</Section>
        <Left>5610</Left>
        <Top>1110</Top>
        <Width>1545</Width>
        <Height>285</Height>
        <Text>Today's Date</Text>
        <Align>RightTop</Align>
        <ForeColor>FF7030A0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>Header</Section>
        <Left>7245</Left>
        <Top>1110</Top>
        <Width>2010</Width>
        <Height>270</Height>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF7030A0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>45</Left>
        <Top>1575</Top>
        <Width>9135</Width>
        <Height>60</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field6</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF808080</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF808080</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF808080</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF808080</Color>
          </Bottom>
        </Border>
        <Section>GroupHeader1</Section>
        <Left>135</Left>
        <Top>6255</Top>
        <Width>9105</Width>
        <Height>75</Height>
        <Shape type="LineShape" />
      </Field>
    </Fields>
  </Report>
</Reports>