<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>SalesByYear レポート</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <ReportInfo>
      <Author>GrapeCity</Author>
    </ReportInfo>
    <Layout>
      <Width>9330</Width>
      <Orientation>Portrait</Orientation>
    </Layout>
    <Font>
      <Name>Segoe UI</Name>
      <Size>9</Size>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\＜アカウント名＞\Documents\ComponentOne Samples\Common\SalesReport.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>SalesByYear</RecordSource>
        <RecordSourceType>TableDirect</RecordSourceType>
        <CalculatedFields>
          <CalculatedField>
            <Name>CalculatedField0</Name>
            <Expression>= 昨年度 / 本年度</Expression>
          </CalculatedField>
        </CalculatedFields>
      </DataSource>
    </DataSources>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>355</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>' -- style script start
detail.BackColor = iif(_styleCtr mod 2 = 0, rgb(255,255,255),rgb(240,240,240))
_styleCtr = _styleCtr + 1
' -- style script end
</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>1470</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Height>7250</Height>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Background type="Solid">
          <Color>FFC2DCFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>400</Height>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>50</Left>
        <Top>200</Top>
        <Width>9026</Width>
        <Height>610</Height>
        <Align>CenterMiddle</Align>
        <ForeColor>FF0000CD</ForeColor>
        <Font>
          <Name>メイリオ</Name>
          <Size>24</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">売り上げ高集計</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>2021年度Lbl</Name>
        <Section>PageHeader</Section>
        <Left>1250</Left>
        <Top>0</Top>
        <Width>2525</Width>
        <Height>400</Height>
        <Align>CenterMiddle</Align>
        <ForeColor>FF204D89</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>メイリオ</Name>
          <Size>12</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">昨年度(万円)</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>2022年度Lbl</Name>
        <Section>PageHeader</Section>
        <Left>3775</Left>
        <Top>0</Top>
        <Width>2525</Width>
        <Height>400</Height>
        <Align>CenterMiddle</Align>
        <ForeColor>FF204D89</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>メイリオ</Name>
          <Size>12</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">本年度(万円)</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>月数Lbl</Name>
        <Section>PageHeader</Section>
        <Left>390</Left>
        <Top>0</Top>
        <Width>570</Width>
        <Height>400</Height>
        <Align>CenterMiddle</Align>
        <ForeColor>FF204D89</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>メイリオ</Name>
          <Size>12</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">月</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>昨年度比Lbl</Name>
        <Section>PageHeader</Section>
        <Left>6480</Left>
        <Top>0</Top>
        <Width>2496</Width>
        <Height>400</Height>
        <Align>CenterMiddle</Align>
        <ForeColor>FF204D89</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>メイリオ</Name>
          <Size>12</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">昨年度比</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>月数Ctl</Name>
        <Section>Detail</Section>
        <Left>210</Left>
        <Top>0</Top>
        <Width>570</Width>
        <Height>355</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>メイリオ</Name>
          <Size>9.75</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Expression>月数</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field1</Name>
        <Section>Detail</Section>
        <Left>1220</Left>
        <Top>0</Top>
        <Width>1825</Width>
        <Height>355</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>メイリオ</Name>
          <Size>9.75</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Expression>昨年度</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field2</Name>
        <Section>Detail</Section>
        <Left>3775</Left>
        <Top>0</Top>
        <Width>1775</Width>
        <Height>355</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>メイリオ</Name>
          <Size>9.75</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Expression>本年度</Expression>
        </Text>
      </TextField>
      <FlexChartField>
        <Name>Field6</Name>
        <Section>Footer</Section>
        <Left>1055</Left>
        <Top>950</Top>
        <Width>7455</Width>
        <Height>2595</Height>
        <Legend>
          <Title>売上げ</Title>
        </Legend>
        <Series>
          <FlexChartSeries>
            <YExpressions>
              <Item sys="string">昨年度</Item>
            </YExpressions>
            <DataSourceName>Main</DataSourceName>
            <XExpression>月数</XExpression>
            <Label>
              <Value>昨年度</Value>
            </Label>
          </FlexChartSeries>
          <FlexChartSeries>
            <YExpressions>
              <Item sys="string">本年度</Item>
            </YExpressions>
            <XExpression>月数</XExpression>
            <Label>
              <Value>本年度</Value>
            </Label>
          </FlexChartSeries>
        </Series>
      </FlexChartField>
      <FlexChartField>
        <Name>Field5</Name>
        <Section>Footer</Section>
        <Left>1235</Left>
        <Top>4655</Top>
        <Width>7410</Width>
        <Height>2595</Height>
        <Series>
          <FlexChartSeries>
            <YExpressions>
              <Item sys="string">本年度 / 昨年度</Item>
            </YExpressions>
            <XExpression>月数</XExpression>
            <Label>
              <Value>昨年度比</Value>
            </Label>
            <ChartType>Line</ChartType>
          </FlexChartSeries>
        </Series>
        <AxisY>
          <Min>0</Min>
          <Max>2</Max>
        </AxisY>
      </FlexChartField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>6480</Left>
        <Top>0</Top>
        <Width>1530</Width>
        <Height>355</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>メイリオ</Name>
          <Size>9.75</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Expression>FormatNumber((本年度 / 昨年度), 2)</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>titleLbl1</Name>
        <Section>Footer</Section>
        <Left>3045</Left>
        <Top>260</Top>
        <Width>2940</Width>
        <Height>600</Height>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>メイリオ</Name>
          <Size>15.75</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">売上げグラフ</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>titleLbl2</Name>
        <Section>Footer</Section>
        <Left>3045</Left>
        <Top>3965</Top>
        <Width>2940</Width>
        <Height>600</Height>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>メイリオ</Name>
          <Size>15.75</Size>
          <GdiCharSet>128</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">昨年度比</Value>
        </Text>
      </TextField>
    </Fields>
  </Report>
</Reports>