<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>InventoryManagementReport</Name>
    <DataSourceName />
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <Layout>
      <Width>15570</Width>
      <Margin>0</Margin>
      <MarginTop>0</MarginTop>
      <MarginRight>0</MarginRight>
      <MarginBottom>0</MarginBottom>
      <Orientation>Landscape</Orientation>
      <PaperSize>Letter</PaperSize>
    </Layout>
    <Font>
      <Name>Segoe UI</Name>
      <Size>9</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
      <GdiCharSet>1</GdiCharSet>
    </Font>
    <ReportParameters>
      <ReportParameter>
        <Name>prmBeginningDate</Name>
        <Value sys="datetime">2013-01-01T00:00:00.0000000</Value>
        <AllowedValuesDefinition>
          <Values />
        </AllowedValuesDefinition>
        <Prompt>Beginning Date</Prompt>
        <ParameterType>DateTime</ParameterType>
      </ReportParameter>
      <ReportParameter>
        <Name>prmEndingDate</Name>
        <Value sys="datetime">2015-01-01T00:00:00.0000000</Value>
        <AllowedValuesDefinition>
          <Values />
        </AllowedValuesDefinition>
        <Prompt>Ending Date</Prompt>
        <ParameterType>DateTime</ParameterType>
      </ReportParameter>
      <ReportParameter>
        <Name>prmSelectCustomers</Name>
        <Value sys="string">All Customer</Value>
        <AllowedValuesDefinition>
          <Values>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">All Customer</Value>
              </Value>
              <Label>
                <Value>All Customer</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">James Kit</Value>
              </Value>
              <Label>
                <Value>James Kit</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">John A.</Value>
              </Value>
              <Label>
                <Value>John A.</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Paul Jaykr</Value>
              </Value>
              <Label>
                <Value>Paul Jaykr</Value>
              </Label>
            </ReportLabeledValue>
          </Values>
        </AllowedValuesDefinition>
        <Prompt>Select Customers</Prompt>
      </ReportParameter>
      <ReportParameter>
        <Name>prmSelectCategory</Name>
        <Value sys="string">All Category</Value>
        <AllowedValuesDefinition>
          <Values>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">All Category</Value>
              </Value>
              <Label>
                <Value>All Category</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Appliances</Value>
              </Value>
              <Label>
                <Value>Appliances</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Flowers</Value>
              </Value>
              <Label>
                <Value>Flowers</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Furniture</Value>
              </Value>
              <Label>
                <Value>Furniture</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Jackets</Value>
              </Value>
              <Label>
                <Value>Jackets</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Mens Shirts</Value>
              </Value>
              <Label>
                <Value>Mens Shirts</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Parts</Value>
              </Value>
              <Label>
                <Value>Parts</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Road Bicycles</Value>
              </Value>
              <Label>
                <Value>Road Bicycles</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Trucks</Value>
              </Value>
              <Label>
                <Value>Trucks</Value>
              </Label>
            </ReportLabeledValue>
          </Values>
        </AllowedValuesDefinition>
        <Prompt>Select Category</Prompt>
      </ReportParameter>
    </ReportParameters>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>1860</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>' -- style script start
' -- style script end
</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Border>
              <Bottom>
                <Width>4</Width>
                <Color>FF666666</Color>
              </Bottom>
            </Border>
            <Height>1995</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>120</Height>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Background type="Solid">
          <Color>FFC2DCFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>Field5</Name>
        <Section>Header</Section>
        <Left>1350</Left>
        <Top>255</Top>
        <Width>5625</Width>
        <Height>555</Height>
        <Text>C1Works Enterprise</Text>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>24</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field9</Name>
        <Section>Header</Section>
        <Left>360</Left>
        <Top>285</Top>
        <Width>1050</Width>
        <Height>990</Height>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Section>Header</Section>
        <Left>1365</Left>
        <Top>735</Top>
        <Width>5625</Width>
        <Height>555</Height>
        <Text>Inventory Report</Text>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>12</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>_txtDate1</Name>
        <Section>Header</Section>
        <Left>11940</Left>
        <Top>510</Top>
        <Width>3345</Width>
        <Height>240</Height>
        <Text>" DATE: From " &amp;[prmBeginningDate]&amp;" To " &amp;[prmEndingDate]
</Text>
        <Calculated>true</Calculated>
        <Align>RightMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri Light</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>true</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <TextField>
        <Name>Field2</Name>
        <Section>Header</Section>
        <Left>345</Left>
        <Top>1290</Top>
        <Width>14220</Width>
        <Height>705</Height>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">FlexReport adds new properties for defining Parameters. Have a look on the Data tab. It defines different Parameter fields, each parameter having it's own set of properties.</Value>
        </Text>
      </TextField>
      <ShapeField>
        <Name>Field7</Name>
        <Section>Header</Section>
        <Left>345</Left>
        <Top>1995</Top>
        <Width>15015</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
        <Line>
          <Width>10</Width>
          <Color>FF666666</Color>
        </Line>
      </ShapeField>
      <SubreportField>
        <Name>Field6</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>90</Top>
        <Width>8965</Width>
        <Height>1770</Height>
        <Subreport sys="string">SoldItemReport</Subreport>
        <ParameterValues>
          <SubreportParameterValue>
            <Name>prmCategory</Name>
            <Value>
              <Expression>prmSelectCategory</Expression>
            </Value>
          </SubreportParameterValue>
          <SubreportParameterValue>
            <Name>prmCustomer</Name>
            <Value>
              <Expression>prmSelectCustomers</Expression>
            </Value>
          </SubreportParameterValue>
          <SubreportParameterValue>
            <Name>prmStartDate</Name>
            <Value>
              <Expression>prmBeginningDate</Expression>
            </Value>
          </SubreportParameterValue>
          <SubreportParameterValue>
            <Name>prmEndDate</Name>
            <Value>
              <Expression>prmEndingDate</Expression>
            </Value>
          </SubreportParameterValue>
        </ParameterValues>
      </SubreportField>
      <SubreportField>
        <Name>Field1</Name>
        <Background type="Solid">
          <Color>FFFAFAFA</Color>
        </Background>
        <Section>Detail</Section>
        <Left>9570</Left>
        <Top>255</Top>
        <Width>5430</Width>
        <Height>1605</Height>
        <Subreport sys="string">Top5RevenueCategories</Subreport>
      </SubreportField>
    </Fields>
  </Report>
  <Report ref="1">
    <Name>SoldItemReport</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <Layout>
      <Width>9975</Width>
      <Margin>0</Margin>
      <MarginTop>0</MarginTop>
      <MarginRight>0</MarginRight>
      <MarginBottom>0</MarginBottom>
      <Orientation>Portrait</Orientation>
      <PaperSize>Letter</PaperSize>
    </Layout>
    <Font>
      <Name>Segoe UI</Name>
      <Size>9</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
      <GdiCharSet>1</GdiCharSet>
    </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 *
FROM InventoryManagement where Sold_Date&gt;=prmStartDate and Sold_Date&lt;=prmEndDate</RecordSource>
        <Filter>Iif(prmCustomer="All Customer",1=1,Customer_Name=prmCustomer) and Iif(prmCategory="All Category",1=1,Item_Category=prmCategory)</Filter>
        <FilterSyntax>VBScript</FilterSyntax>
      </DataSource>
    </DataSources>
    <ReportParameters>
      <ReportParameter>
        <Name>prmCustomer</Name>
        <Value sys="string">All Customer</Value>
        <AllowedValuesDefinition>
          <Values>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">All Customer</Value>
              </Value>
              <Label>
                <Value>All Customer</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">James Kit</Value>
              </Value>
              <Label>
                <Value>James Kit</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">John A.</Value>
              </Value>
              <Label>
                <Value>John A.</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Paul Jaykr</Value>
              </Value>
              <Label>
                <Value>Paul Jaykr</Value>
              </Label>
            </ReportLabeledValue>
          </Values>
        </AllowedValuesDefinition>
        <Prompt>Select Customer</Prompt>
      </ReportParameter>
      <ReportParameter>
        <Name>prmCategory</Name>
        <Value sys="string">All Category</Value>
        <AllowedValuesDefinition>
          <Values>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">All Category</Value>
              </Value>
              <Label>
                <Value>All Category</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Appliances</Value>
              </Value>
              <Label>
                <Value>Appliances</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Flowers</Value>
              </Value>
              <Label>
                <Value>Flowers</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Furniture</Value>
              </Value>
              <Label>
                <Value>Furniture</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Jackets</Value>
              </Value>
              <Label>
                <Value>Jackets</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Mens Shirts</Value>
              </Value>
              <Label>
                <Value>Mens Shirts</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Parts</Value>
              </Value>
              <Label>
                <Value>Parts</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Road Bicycles</Value>
              </Value>
              <Label>
                <Value>Road Bicycles</Value>
              </Label>
            </ReportLabeledValue>
            <ReportLabeledValue>
              <Value>
                <Value sys="string">Trucks</Value>
              </Value>
              <Label>
                <Value>Trucks</Value>
              </Label>
            </ReportLabeledValue>
          </Values>
        </AllowedValuesDefinition>
        <Prompt>Select Category</Prompt>
      </ReportParameter>
      <ReportParameter>
        <Name>prmStartDate</Name>
        <Value sys="datetime">2013-01-01T00:00:00.0000000</Value>
        <AllowedValuesDefinition>
          <Values />
        </AllowedValuesDefinition>
        <ParameterType>DateTime</ParameterType>
      </ReportParameter>
      <ReportParameter>
        <Name>prmEndDate</Name>
        <Value sys="datetime">2015-01-01T00:00:00.0000000</Value>
        <AllowedValuesDefinition>
          <Values />
        </AllowedValuesDefinition>
        <ParameterType>DateTime</ParameterType>
      </ReportParameter>
    </ReportParameters>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>540</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>1050</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>420</Height>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Background type="Solid">
          <Color>FFC0C0C0</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>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>Field3</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>10</Width>
            <Color>00FFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>10</Width>
            <Color>00FFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>10</Width>
            <Color>00FFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>10</Width>
            <Color>00FFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Linear">
          <GradientStops>
            <GradientStop>
              <Position>0</Position>
              <Color>FF32CD32</Color>
            </GradientStop>
            <GradientStop>
              <Position>1</Position>
              <Color>FF32CD32</Color>
            </GradientStop>
          </GradientStops>
          <StartPoint>0,0</StartPoint>
          <EndPoint>1,0</EndPoint>
        </Background>
        <Section>Detail</Section>
        <Left>4035</Left>
        <Top>360</Top>
        <Width>990</Width>
        <Height>60</Height>
        <ZOrder>-1</ZOrder>
      </TextField>
      <Field>
        <Name>Item_NameCtl</Name>
        <Section>Detail</Section>
        <Left>420</Left>
        <Top>0</Top>
        <Width>3075</Width>
        <Height>375</Height>
        <Text>Item_Name</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Qty_SoldCtl</Name>
        <Section>Detail</Section>
        <Left>4040</Left>
        <Top>75</Top>
        <Width>960</Width>
        <Height>280</Height>
        <Text>Qty_Sold &amp;" " &amp; "Unit(s)"</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Sales_IDCtl</Name>
        <Section>Detail</Section>
        <Left>5170</Left>
        <Top>75</Top>
        <Width>960</Width>
        <Height>280</Height>
        <Text>Sales_ID</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>NetRevenueCtl</Name>
        <Section>Detail</Section>
        <Left>6375</Left>
        <Top>75</Top>
        <Width>1245</Width>
        <Height>280</Height>
        <Text>NetRevenue</Text>
        <Calculated>true</Calculated>
        <Format>$#,##0.00</Format>
        <Align>CenterMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Sold_DateCtl</Name>
        <Section>Detail</Section>
        <Left>7805</Left>
        <Top>75</Top>
        <Width>1600</Width>
        <Height>280</Height>
        <Text>MonthName(Month(Sold_Date),true) &amp; " " &amp; Day(Sold_Date)&amp; ", " &amp; Year(Sold_Date)
</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Item_CategoryCtl</Name>
        <Section>Detail</Section>
        <Left>420</Left>
        <Top>225</Top>
        <Width>2745</Width>
        <Height>280</Height>
        <Text>"Category: " &amp; Item_Category</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFE6E6E6</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFE6E6E6</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFE6E6E6</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFE6E6E6</Color>
          </Bottom>
        </Border>
        <Section>Detail</Section>
        <Left>390</Left>
        <Top>525</Top>
        <Width>9135</Width>
        <Height>15</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>430</Left>
        <Top>0</Top>
        <Width>5200</Width>
        <Height>510</Height>
        <ZOrder>-6</ZOrder>
        <Text>Sold Items Report</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF295789</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>15.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>585</Top>
        <Width>9840</Width>
        <Height>465</Height>
        <ZOrder>-2</ZOrder>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Item_NameLbl1</Name>
        <Section>Header</Section>
        <Left>420</Left>
        <Top>600</Top>
        <Width>3180</Width>
        <Height>400</Height>
        <Text>Item Name</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF295789</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Qty_SoldLbl1</Name>
        <Section>Header</Section>
        <Left>4040</Left>
        <Top>600</Top>
        <Width>960</Width>
        <Height>400</Height>
        <Text>Qty Sold</Text>
        <Align>CenterMiddle</Align>
        <ForeColor>FF295789</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Sales_IDLbl1</Name>
        <Section>Header</Section>
        <Left>5170</Left>
        <Top>600</Top>
        <Width>960</Width>
        <Height>400</Height>
        <Text>ID</Text>
        <Align>CenterMiddle</Align>
        <ForeColor>FF295789</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>NetRevenueLbl1</Name>
        <Section>Header</Section>
        <Left>6375</Left>
        <Top>600</Top>
        <Width>1260</Width>
        <Height>400</Height>
        <Text>Net Revenue</Text>
        <Align>CenterMiddle</Align>
        <ForeColor>FF295789</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Sold_DateLbl1</Name>
        <Section>Header</Section>
        <Left>7805</Left>
        <Top>600</Top>
        <Width>1600</Width>
        <Height>400</Height>
        <Text>Last Sold</Text>
        <Align>CenterMiddle</Align>
        <ForeColor>FF295789</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>lblGrandTotal</Name>
        <Section>Footer</Section>
        <Left>615</Left>
        <Top>0</Top>
        <Width>2745</Width>
        <Height>280</Height>
        <Text>Grand Total:</Text>
        <Align>LeftTop</Align>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>GradTotalUnit</Name>
        <Section>Footer</Section>
        <Left>3720</Left>
        <Top>0</Top>
        <Width>1530</Width>
        <Height>280</Height>
        <Text>Sum(Qty_Sold)&amp;" " &amp; "Unit(s)"</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <ForeColor>FF008000</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>GranTotalRevenue</Name>
        <Section>Footer</Section>
        <Left>5895</Left>
        <Top>0</Top>
        <Width>1995</Width>
        <Height>280</Height>
        <Text>Sum(NetRevenue)</Text>
        <Calculated>true</Calculated>
        <Format>$#,##0.00</Format>
        <Align>CenterMiddle</Align>
        <ForeColor>FF008000</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFB4B4B4</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFB4B4B4</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFB4B4B4</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFB4B4B4</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>390</Left>
        <Top>975</Top>
        <Width>9135</Width>
        <Height>15</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field4</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF969696</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF969696</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF969696</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF969696</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>390</Left>
        <Top>525</Top>
        <Width>9135</Width>
        <Height>15</Height>
        <Shape type="LineShape" />
      </Field>
    </Fields>
  </Report>
  <Report ref="1">
    <Name>Top5RevenueCategories</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <Layout>
      <Width>6675</Width>
      <Margin>0</Margin>
      <MarginTop>0</MarginTop>
      <MarginRight>0</MarginRight>
      <MarginBottom>0</MarginBottom>
      <Orientation>Portrait</Orientation>
      <PaperSize>Letter</PaperSize>
    </Layout>
    <Font>
      <Name>Segoe UI</Name>
      <Size>9</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
      <GdiCharSet>1</GdiCharSet>
    </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 TOP 5 *
FROM (SELECT Item_Category, sum(NetRevenue) as totalRevenue, (select Sum(NetRevenue) from InventoryManagement) as total
FROM InventoryManagement
 group by Item_Category)  AS t
ORDER BY TotalRevenue DESC;
UNION select 'Remaining Categories',(select Sum(NetRevenue) from InventoryManagement where  Item_Category not In (SELECT TOP 5 Item_Category
FROM (SELECT Item_Category, sum(NetRevenue) as totalRevenue, (select Sum(NetRevenue) from InventoryManagement) as total
FROM InventoryManagement group by Item_Category)  AS t
ORDER BY TotalRevenue DESC)) as totalRevenue, (select Sum(NetRevenue) from InventoryManagement) as total
FROM InventoryManagement;</RecordSource>
      </DataSource>
    </DataSources>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>345</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>lblCatagoryLagend.BackColor=Iif(_styleCtr = 0,"Darkred",Iif(_styleCtr = 1,"Darkblue",Iif(_styleCtr = 2,"LightGreen",Iif(_styleCtr = 3,"gray",Iif(_styleCtr = 4,"Yellow","Skyblue")))))
_styleCtr = _styleCtr +1</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>4665</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>FFC2DCFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>lblCategoryName</Name>
        <Section>Detail</Section>
        <Left>1590</Left>
        <Top>75</Top>
        <Width>3180</Width>
        <Height>225</Height>
        <Text>Item_Category &amp; ":  " &amp; Round((totalRevenue*100/total),1) &amp;" %"</Text>
        <Calculated>true</Calculated>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>lblCatagoryLagend</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>
        <Background type="Solid">
          <Color>FF87CEEB</Color>
        </Background>
        <Section>Detail</Section>
        <Left>1140</Left>
        <Top>105</Top>
        <Width>345</Width>
        <Height>165</Height>
      </Field>
      <ChartField>
        <Name>RevenueChart</Name>
        <Background type="Solid">
          <Color>FFFAFAFA</Color>
        </Background>
        <Section>Header</Section>
        <Left>75</Left>
        <Top>0</Top>
        <Width>5190</Width>
        <Height>4665</Height>
        <ZOrder>-3</ZOrder>
        <ColorGeneration>CustomByPalette</ColorGeneration>
        <DataColor>FF000080</DataColor>
        <Palette>DarkRed;DarkBlue;LightGreen;Gray;Yellow;SkyBlue</Palette>
        <ChartLabels>
          <DefaultLabelStyle>
            <BackColor>FFFFFFFF</BackColor>
            <Opaque>true</Opaque>
          </DefaultLabelStyle>
        </ChartLabels>
        <ChartGroups2D>
          <Group0>
            <ChartType>Pie</ChartType>
            <OutlineColor>FF808080</OutlineColor>
            <ChartData>
              <IsForEachRecord>true</IsForEachRecord>
              <CategoryGroups>
                <ChartDataGroup>
                  <GroupExpression>Item_Category</GroupExpression>
                </ChartDataGroup>
              </CategoryGroups>
              <SeriesValues>
                <ChartDataSeries>
                  <Label> </Label>
                  <DataValues>
                    <ChartDataValue>
                      <ValueExpression>totalRevenue</ValueExpression>
                    </ChartDataValue>
                  </DataValues>
                  <DataLabel>
                    <Offset>300</Offset>
                    <Text>{#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>
              <Shading>ColorLight</Shading>
            </View3D>
          </PlotArea>
        </ChartArea2D>
      </ChartField>
      <Field>
        <Name>Field1</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>6675</Width>
        <Height>495</Height>
        <ZOrder>-2</ZOrder>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>450</Left>
        <Top>0</Top>
        <Width>4530</Width>
        <Height>435</Height>
        <Text>Top 5 Revenue Categories All Times</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>14.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
    </Fields>
  </Report>
</Reports>