<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>ProfitAndSale Report</Name>
    <DataSourceName>Main</DataSourceName>
    <ReportInfo>
      <Author>ChrisGu</Author>
    </ReportInfo>
    <Layout>
      <Width>9539</Width>
      <Orientation>Portrait</Orientation>
    </Layout>
    <Font>
      <Name>Constantia</Name>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>XmlFile</DataProvider>
        <ConnectionString>InitialData.xml</ConnectionString>
        <RecordSource>ProfitAndSale</RecordSource>
        <RecordSourceType>TableDirect</RecordSourceType>
      </DataSource>
    </DataSources>
    <Groups>
      <Group>
        <Name>Category</Name>
        <GroupBy>Category</GroupBy>
        <Sort>Ascending</Sort>
        <KeepTogether>KeepFirstDetail</KeepTogether>
        <OutlineLabel>
          <Expression>Category</Expression>
        </OutlineLabel>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>785</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>cnt = cnt + 1
if cnt mod 2 = 0 then
  detail.backcolor = rgb(245,245,245)
else
  detail.backcolor = rgb(255,255,255)
endif</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Background type="Solid">
          <Color>FFD1EAF0</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>945</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>500</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>GroupHeader0</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>4995</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
        <OnPrint>cnt = 0</OnPrint>
      </Section>
      <Section>
        <Name>GroupFooter0</Name>
        <SubSections>
          <SubSection>
            <Height>365</Height>
          </SubSection>
        </SubSections>
        <Type>GroupFooter1</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>50</Left>
        <Top>200</Top>
        <Width>9025.51181102362</Width>
        <Height>600</Height>
        <Align>LeftMiddle</Align>
        <ForeColor>FF04617B</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>20</Size>
        </Font>
        <Text>
          <Value sys="string">Profit And Sale Report</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>ftrLeft</Name>
        <Section>PageFooter</Section>
        <Left>50</Left>
        <Top>30</Top>
        <Width>4512.75590551181</Width>
        <Height>300</Height>
        <Align>LeftTop</Align>
        <ForeColor>FF04617B</ForeColor>
        <Font>
          <Name>Constantia</Name>
          <Size>8</Size>
        </Font>
        <Text>
          <Expression>Now()</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>ftrRight</Name>
        <Section>PageFooter</Section>
        <Left>4512.75590551181</Left>
        <Top>30</Top>
        <Width>4512.75590551181</Width>
        <Height>300</Height>
        <Align>RightTop</Align>
        <ForeColor>FF04617B</ForeColor>
        <Font>
          <Name>Constantia</Name>
          <Size>8</Size>
        </Font>
        <Text>
          <Expression>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>CategoryLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>0</Left>
        <Top>4100</Top>
        <Width>3000</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Category</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>CategoryCtl</Name>
        <Section>GroupHeader1</Section>
        <Left>3000</Left>
        <Top>4100</Top>
        <Width>6025</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Expression>Category</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>CustomerLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>381</Left>
        <Top>4600</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Customer</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>DateLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>1505</Left>
        <Top>4600</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Date</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>CampaignLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>2629</Left>
        <Top>4600</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Campaign</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>ProductLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>3753</Left>
        <Top>4600</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Product</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>ProfitLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>7139</Left>
        <Top>4610</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Profit</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>QuantityLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>6001</Left>
        <Top>4600</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Quantity</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>RegionLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>4891</Left>
        <Top>4610</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Region</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>SalesLbl</Name>
        <Section>GroupHeader1</Section>
        <Left>8429</Left>
        <Top>4645</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF04617B</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Sales</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>CustomerCtl</Name>
        <Section>Detail</Section>
        <Left>381</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>500</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Customer</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>DateCtl</Name>
        <Section>Detail</Section>
        <Left>1505</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>280</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>[Date]</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>CampaignCtl</Name>
        <Section>Detail</Section>
        <Left>2629</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>500</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Campaign</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>ProductCtl</Name>
        <Section>Detail</Section>
        <Left>3753</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>750</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Product</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>ProfitCtl</Name>
        <Section>Detail</Section>
        <Left>7139</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>500</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Profit</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>QuantityCtl</Name>
        <Section>Detail</Section>
        <Left>6001</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>280</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Quantity</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>RegionCtl</Name>
        <Section>Detail</Section>
        <Left>4891</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>280</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Region</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>SalesCtl</Name>
        <Section>Detail</Section>
        <Left>8429</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>280</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Constantia</Name>
        </Font>
        <Text>
          <Expression>Sales</Expression>
        </Text>
      </TextField>
      <ImageField>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>7359</Left>
        <Top>225</Top>
        <Width>2000</Width>
        <Height>600</Height>
        <Picture>
          <Image> </Image>
        </Picture>
      </ImageField>
      <TextField>
        <Name>CategoryLbl1</Name>
        <Section>GroupFooter1</Section>
        <Left>50</Left>
        <Top>0</Top>
        <Width>3000</Width>
        <Height>350</Height>
        <Align>LeftTop</Align>
        <ForeColor>FFFF0000</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Value sys="string">Total</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>ProfitLbl1</Name>
        <Section>GroupFooter1</Section>
        <Left>7111</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftTop</Align>
        <ForeColor>FFFF0000</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Expression>Sum(Profit)</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>SalesLbl1</Name>
        <Section>GroupFooter1</Section>
        <Left>8401</Left>
        <Top>15</Top>
        <Width>1110</Width>
        <Height>350</Height>
        <Align>LeftTop</Align>
        <ForeColor>FFFF0000</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Constantia</Name>
          <Bold>true</Bold>
        </Font>
        <Text>
          <Expression>Sum(Sales)</Expression>
        </Text>
      </TextField>
      <FlexChartField>
        <Name>Field2</Name>
        <Section>GroupHeader1</Section>
        <Left>50</Left>
        <Top>225</Top>
        <Width>9179</Width>
        <Height>3785</Height>
        <Header>
          <Content>Profit and Sales for region</Content>
        </Header>
        <Palette>Custom</Palette>
        <CategoryGroups>
          <FlexChartDataGroup>
            <GroupExpression>Region</GroupExpression>
          </FlexChartDataGroup>
        </CategoryGroups>
        <Series>
          <FlexChartSeries>
            <Name>Profit</Name>
            <YExpressions>
              <Item sys="string">Avg(Profit)</Item>
            </YExpressions>
            <Label>
              <Value>Profit</Value>
            </Label>
          </FlexChartSeries>
          <FlexChartSeries>
            <Name>Sales</Name>
            <YExpressions>
              <Item sys="string">Avg(Sales)</Item>
            </YExpressions>
            <Label>
              <Value>Sales</Value>
            </Label>
          </FlexChartSeries>
        </Series>
      </FlexChartField>
    </Fields>
  </Report>
</Reports>