<?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>10755</Width>
      <Margin>576</Margin>
      <MarginTop>288</MarginTop>
      <MarginRight>576</MarginRight>
      <MarginBottom>0</MarginBottom>
      <Orientation>Portrait</Orientation>
      <PaperSize>A4</PaperSize>
    </Layout>
    <Font>
      <Name>Segoe UI</Name>
    </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">2016-12-31T00: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>3465</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>2595</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <PrintAtPageBottom>true</PrintAtPageBottom>
      </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>_txtDate1</Name>
        <Section>Header</Section>
        <Left>15</Left>
        <Top>1275</Top>
        <Width>6720</Width>
        <Height>375</Height>
        <Text>"Date: From " &amp;[prmBeginningDate]&amp;" To " &amp;[prmEndingDate]
</Text>
        <Calculated>true</Calculated>
        <Align>LeftMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>9.75</Size>
        </Font>
      </Field>
      <TextField>
        <Name>Field2</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1800</Top>
        <Width>10725</Width>
        <Height>705</Height>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </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 its own set of properties.</Value>
        </Text>
      </TextField>
      <SubreportField>
        <Name>Field6</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>10725</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>0</Left>
        <Top>1860</Top>
        <Width>10725</Width>
        <Height>1605</Height>
        <Subreport sys="string">Top5RevenueCategories</Subreport>
      </SubreportField>
      <Field>
        <Name>Field13</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>Field19</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>5164</Width>
        <Height>1110</Height>
        <MarginLeft>576</MarginLeft>
        <MarginBottom>172.8</MarginBottom>
        <Text>Inventory Report</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>
    </Fields>
    <Culture>en-US</Culture>
  </Report>
  <Report ref="1">
    <Name>SoldItemReport</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <Layout>
      <Width>10755</Width>
      <Margin>0</Margin>
      <MarginTop>0</MarginTop>
      <MarginRight>0</MarginRight>
      <MarginBottom>0</MarginBottom>
      <Orientation>Portrait</Orientation>
      <PaperSize>A4</PaperSize>
    </Layout>
    <Font>
      <Name>Segoe UI</Name>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=SQLNCLI11;Integrated Security=SSPI;Data Source=(localdb)\v11.0;Initial File Name=|DataDirectory|\wwwroot\App_Data\C1NWind.mdf;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">2016-12-31T00:00:00.0000000</Value>
        <AllowedValuesDefinition>
          <Values />
        </AllowedValuesDefinition>
        <ParameterType>DateTime</ParameterType>
      </ReportParameter>
    </ReportParameters>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <Height>585</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>1125</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Background type="Solid">
              <Color>FFF8F8F8</Color>
            </Background>
            <Height>350</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>
      <Field>
        <Name>Qty_SoldCtl</Name>
        <Section>Detail</Section>
        <Left>4455</Left>
        <Top>75</Top>
        <Width>1895</Width>
        <Height>280</Height>
        <Text>Qty_Sold</Text>
        <Calculated>true</Calculated>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>Sales_IDCtl</Name>
        <Section>Detail</Section>
        <Left>6520</Left>
        <Top>75</Top>
        <Width>960</Width>
        <Height>280</Height>
        <Text>Sales_ID</Text>
        <Calculated>true</Calculated>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>NetRevenueCtl</Name>
        <Section>Detail</Section>
        <Left>7480</Left>
        <Top>75</Top>
        <Width>1490</Width>
        <Height>280</Height>
        <Text>NetRevenue</Text>
        <Calculated>true</Calculated>
        <Format>$#,##0.00</Format>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>Sold_DateCtl</Name>
        <Section>Detail</Section>
        <Left>9155</Left>
        <Top>75</Top>
        <Width>1600</Width>
        <Height>280</Height>
        <Text>Sold_Date
</Text>
        <Calculated>true</Calculated>
        <Format>Date</Format>
        <Align>CenterMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>Item_NameCtl</Name>
        <Section>Detail</Section>
        <Left>195</Left>
        <Top>0</Top>
        <Width>4080</Width>
        <Height>375</Height>
        <Text>Item_Name</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
      <Field>
        <Name>Item_CategoryCtl</Name>
        <Section>Detail</Section>
        <Left>345</Left>
        <Top>225</Top>
        <Width>3930</Width>
        <Height>280</Height>
        <Text>"Category: " &amp; Item_Category</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
        </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>
        <Background type="Solid">
          <Color>FFE4E4E4</Color>
        </Background>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>525</Top>
        <Width>10755</Width>
        <Height>15</Height>
        <Font>
          <Name>Segoe UI Light</Name>
        </Font>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Background type="Solid">
          <Color>FFF1F1F1</Color>
        </Background>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>10755</Width>
        <Height>660</Height>
        <ZOrder>-6</ZOrder>
        <Text> Sold Items</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>14.5</Size>
          <GdiCharSet>0</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Background type="Solid">
          <Color>FFF8F8F8</Color>
        </Background>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>660</Top>
        <Width>10755</Width>
        <Height>465</Height>
        <ZOrder>-8</ZOrder>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
        </Font>
      </Field>
      <Field>
        <Name>Item_NameLbl1</Name>
        <Section>Header</Section>
        <Left>195</Left>
        <Top>675</Top>
        <Width>4080</Width>
        <Height>420</Height>
        <Text>Item Name</Text>
        <Align>LeftMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>Qty_SoldLbl1</Name>
        <Section>Header</Section>
        <Left>4275</Left>
        <Top>675</Top>
        <Width>2075</Width>
        <Height>420</Height>
        <Text>Qty Sold (in Units)</Text>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>Sales_IDLbl1</Name>
        <Section>Header</Section>
        <Left>6520</Left>
        <Top>675</Top>
        <Width>960</Width>
        <Height>420</Height>
        <Text>ID</Text>
        <Align>CenterMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>NetRevenueLbl1</Name>
        <Section>Header</Section>
        <Left>7480</Left>
        <Top>675</Top>
        <Width>1505</Width>
        <Height>420</Height>
        <Text>Net Revenue</Text>
        <Align>RightMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>Sold_DateLbl1</Name>
        <Section>Header</Section>
        <Left>9155</Left>
        <Top>675</Top>
        <Width>1600</Width>
        <Height>420</Height>
        <Text>Last Sold</Text>
        <Align>CenterMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>lblGrandTotal</Name>
        <Section>Footer</Section>
        <Left>195</Left>
        <Top>0</Top>
        <Width>2940</Width>
        <Height>350</Height>
        <Text>Grand Total:</Text>
        <Align>LeftTop</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>GradTotalUnit</Name>
        <Section>Footer</Section>
        <Left>4275</Left>
        <Top>0</Top>
        <Width>2075</Width>
        <Height>350</Height>
        <Text>Sum(Qty_Sold)</Text>
        <Calculated>true</Calculated>
        <Align>RightMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
      <Field>
        <Name>GranTotalRevenue</Name>
        <Section>Footer</Section>
        <Left>7020</Left>
        <Top>0</Top>
        <Width>1950</Width>
        <Height>350</Height>
        <Text>Sum(NetRevenue)</Text>
        <Calculated>true</Calculated>
        <Format>$#,##0.00</Format>
        <Align>RightMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>12</Size>
        </Font>
      </Field>
    </Fields>
    <Culture>en-US</Culture>
  </Report>
  <Report ref="1">
    <Name>Top5RevenueCategories</Name>
    <DataSourceName>Main</DataSourceName>
    <Layout>
      <Width>10800</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>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=SQLNCLI11;Integrated Security=SSPI;Data Source=(localdb)\v11.0;Initial File Name=|DataDirectory|\wwwroot\App_Data\C1NWind.mdf;Persist Security Info=False</ConnectionString>
        <RecordSource>SELECT * FROM (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) AS t1
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>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>3495</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>
      <ChartField>
        <Name>RevenueChart</Name>
        <Section>Header</Section>
        <Left>1370</Left>
        <Top>525</Top>
        <Width>5260</Width>
        <Height>2970</Height>
        <ZOrder>-3</ZOrder>
        <ColorGeneration>CustomByPalette</ColorGeneration>
        <DataColor>FF9400D3</DataColor>
        <Palette>Purple;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>
                  <Name>RevenueChart_CategoryGroup0</Name>
                  <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>titleLbl1</Name>
        <Background type="Solid">
          <Color>FFF1F1F1</Color>
        </Background>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>10755</Width>
        <Height>660</Height>
        <ZOrder>-6</ZOrder>
        <Text> Top 5 Revenue Categories All Times</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF551E5F</ForeColor>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>14.5</Size>
          <GdiCharSet>0</GdiCharSet>
        </Font>
      </Field>
      <SubreportField>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>5760</Left>
        <Top>1035</Top>
        <Width>4815</Width>
        <Height>1755</Height>
        <Subreport sys="string">PieChartLegends</Subreport>
      </SubreportField>
    </Fields>
  </Report>
  <Report ref="1">
    <Name>PieChartLegends</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>_styleCtr = 0</OnOpen>
    <ReportInfo>
      <Author>Saurabh.Sharma</Author>
    </ReportInfo>
    <Layout>
      <Width>4830</Width>
    </Layout>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=SQLNCLI11;Integrated Security=SSPI;Data Source=(localdb)\v11.0;Initial File Name=|DataDirectory|\wwwroot\App_Data\C1NWind.mdf;Persist Security Info=False</ConnectionString>
        <RecordSource>SELECT * FROM (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) AS t1
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>
            <Height>300</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>lblCatagoryLagend.BackColor=Iif(_styleCtr = 0,"Purple",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 />
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
    </Sections>
    <Fields>
      <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>15</Left>
        <Top>50</Top>
        <Width>230.4</Width>
        <Height>230.4</Height>
      </Field>
      <Field>
        <Name>lblCategoryName</Name>
        <Section>Detail</Section>
        <Left>425</Left>
        <Top>0</Top>
        <Width>4405</Width>
        <Height>300</Height>
        <Text>Item_Category &amp; ":  " &amp; Round((totalRevenue*100/total),1) &amp;" %"</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <Font>
          <Name>Segoe UI Light</Name>
          <Size>10.5</Size>
        </Font>
      </Field>
    </Fields>
  </Report>
</Reports>