<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="AdventureWorksDW2012">
      <rd:DataSourceID>15464674-1151-4306-bd0d-1da32e87c6ef</rd:DataSourceID>
      <DataSourceReference>AdventureWorksDW2012</DataSourceReference>
    </DataSource>
  </DataSources>
  <rd:ReportID>036bdaf9-92a9-43c7-9572-12562f93e3dc</rd:ReportID>
  <Width>5in</Width>
  <Body>
    <Height>1.17in</Height>
    <ColumnSpacing>0.5in</ColumnSpacing>
    <ReportItems>
      <Textbox Name="textbox1">
        <Style>
          <FontFamily>Times New Roman</FontFamily>
          <FontSize>18pt</FontSize>
          <Color>#365838</Color>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <rd:DefaultName>textbox1</rd:DefaultName>
        <Value>Sales by Product and Territory</Value>
        <CanGrow>true</CanGrow>
        <Height>0.33in</Height>
      </Textbox>
      <Matrix Name="matrix1">
        <Top>0.33in</Top>
        <RowGroupings>
          <RowGrouping>
            <DynamicRows>
              <Grouping Name="matrix1_SalesTerritoryGroup">
                <GroupExpressions>
                  <GroupExpression>=Fields!SalesTerritoryGroup.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Sorting>
                <SortBy>
                  <SortExpression>=Fields!SalesTerritoryGroup.Value</SortExpression>
                </SortBy>
              </Sorting>
              <ReportItems>
                <Textbox Name="SalesTerritoryGroup">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>10pt</FontSize>
                    <Color>White</Color>
                    <BackgroundColor>#4a7349</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <BorderColor>
                      <Default>DarkGray</Default>
                    </BorderColor>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <rd:DefaultName>SalesTerritoryGroup</rd:DefaultName>
                  <Value>=Fields!SalesTerritoryGroup.Value</Value>
                  <CanGrow>true</CanGrow>
                  <Height>0.21in</Height>
                  <Width>1in</Width>
                </Textbox>
              </ReportItems>
            </DynamicRows>
            <Width>1in</Width>
          </RowGrouping>
          <RowGrouping>
            <DynamicRows>
              <Grouping Name="matrix1_SalesTerritoryCountry">
                <GroupExpressions>
                  <GroupExpression>=Fields!SalesTerritoryCountry.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Sorting>
                <SortBy>
                  <SortExpression>=Fields!SalesTerritoryCountry.Value</SortExpression>
                </SortBy>
              </Sorting>
              <Visibility>
                <Hidden>true</Hidden>
                <ToggleItem>SalesTerritoryGroup</ToggleItem>
              </Visibility>
              <ReportItems>
                <Textbox Name="SalesTerritoryCountry">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>10pt</FontSize>
                    <BackgroundColor>#a3cba3</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <BorderColor>
                      <Default>DarkGray</Default>
                    </BorderColor>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <rd:DefaultName>SalesTerritoryCountry</rd:DefaultName>
                  <Value>=Fields!SalesTerritoryCountry.Value</Value>
                  <CanGrow>true</CanGrow>
                  <Height>0.21in</Height>
                  <Width>1in</Width>
                </Textbox>
              </ReportItems>
            </DynamicRows>
            <Width>1in</Width>
          </RowGrouping>
          <RowGrouping>
            <DynamicRows>
              <Grouping Name="matrix1_SalesTerritoryRegion">
                <GroupExpressions>
                  <GroupExpression>=Fields!SalesTerritoryRegion.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Sorting>
                <SortBy>
                  <SortExpression>=Fields!SalesTerritoryRegion.Value</SortExpression>
                </SortBy>
              </Sorting>
              <Visibility>
                <Hidden>true</Hidden>
                <ToggleItem>SalesTerritoryCountry</ToggleItem>
              </Visibility>
              <ReportItems>
                <Textbox Name="SalesTerritoryRegion">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>10pt</FontSize>
                    <BackgroundColor>#dedab5</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <BorderColor>
                      <Default>DarkGray</Default>
                    </BorderColor>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <rd:DefaultName>SalesTerritoryRegion</rd:DefaultName>
                  <Value>=Fields!SalesTerritoryRegion.Value</Value>
                  <CanGrow>true</CanGrow>
                  <Height>0.21in</Height>
                  <Width>1in</Width>
                </Textbox>
              </ReportItems>
            </DynamicRows>
            <Width>1in</Width>
          </RowGrouping>
        </RowGroupings>
        <MatrixRows>
          <MatrixRow>
            <MatrixCells>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="textbox2">
                    <Style>
                      <FontFamily>Times New Roman</FontFamily>
                      <FontSize>9pt</FontSize>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <BorderColor>
                        <Default>DarkGray</Default>
                      </BorderColor>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <rd:DefaultName>textbox2</rd:DefaultName>
                    <Value>=Sum(Fields!SalesAmount.Value)</Value>
                    <CanGrow>true</CanGrow>
                    <Height>0.19in</Height>
                    <Width>1in</Width>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
            </MatrixCells>
            <Height>0.21in</Height>
          </MatrixRow>
        </MatrixRows>
        <Corner>
          <ReportItems>
            <Textbox Name="textbox3">
              <Style>
                <FontFamily>Times New Roman</FontFamily>
                <FontSize>9pt</FontSize>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
                <BorderColor>
                  <Default>DarkGray</Default>
                </BorderColor>
                <PaddingLeft>2pt</PaddingLeft>
                <PaddingRight>2pt</PaddingRight>
                <PaddingTop>2pt</PaddingTop>
                <PaddingBottom>2pt</PaddingBottom>
              </Style>
              <rd:DefaultName>textbox3</rd:DefaultName>
              <Value>
              </Value>
              <CanGrow>true</CanGrow>
              <Height>0.19in</Height>
            </Textbox>
          </ReportItems>
        </Corner>
        <DataSetName>DataSet1</DataSetName>
        <MatrixColumns>
          <MatrixColumn>
            <Width>1in</Width>
          </MatrixColumn>
        </MatrixColumns>
        <ColumnGroupings>
          <ColumnGrouping>
            <DynamicColumns>
              <Grouping Name="matrix1_EnglishProductCategoryName">
                <GroupExpressions>
                  <GroupExpression>=Fields!EnglishProductCategoryName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Sorting>
                <SortBy>
                  <SortExpression>=Fields!EnglishProductCategoryName.Value</SortExpression>
                </SortBy>
              </Sorting>
              <ReportItems>
                <Textbox Name="EnglishProductCategoryName">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>10pt</FontSize>
                    <Color>White</Color>
                    <BackgroundColor>#4a7349</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <BorderColor>
                      <Default>DarkGray</Default>
                    </BorderColor>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <rd:DefaultName>EnglishProductCategoryName</rd:DefaultName>
                  <Value>=Fields!EnglishProductCategoryName.Value</Value>
                  <CanGrow>true</CanGrow>
                  <Height>0.21in</Height>
                  <Width>1in</Width>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
            <Height>0.21in</Height>
          </ColumnGrouping>
          <ColumnGrouping>
            <DynamicColumns>
              <Grouping Name="matrix1_EnglishProductSubcategoryName">
                <GroupExpressions>
                  <GroupExpression>=Fields!EnglishProductSubcategoryName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Sorting>
                <SortBy>
                  <SortExpression>=Fields!EnglishProductSubcategoryName.Value</SortExpression>
                </SortBy>
              </Sorting>
              <Visibility>
                <Hidden>true</Hidden>
                <ToggleItem>EnglishProductCategoryName</ToggleItem>
              </Visibility>
              <ReportItems>
                <Textbox Name="EnglishProductSubcategoryName">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>10pt</FontSize>
                    <BackgroundColor>#a3cba3</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <BorderColor>
                      <Default>DarkGray</Default>
                    </BorderColor>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <rd:DefaultName>EnglishProductSubcategoryName</rd:DefaultName>
                  <Value>=Fields!EnglishProductSubcategoryName.Value</Value>
                  <CanGrow>true</CanGrow>
                  <Height>0.21in</Height>
                  <Width>1in</Width>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
            <Height>0.21in</Height>
          </ColumnGrouping>
          <ColumnGrouping>
            <DynamicColumns>
              <Grouping Name="matrix1_EnglishProductName">
                <GroupExpressions>
                  <GroupExpression>=Fields!EnglishProductName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Sorting>
                <SortBy>
                  <SortExpression>=Fields!EnglishProductName.Value</SortExpression>
                </SortBy>
              </Sorting>
              <Visibility>
                <Hidden>true</Hidden>
                <ToggleItem>EnglishProductSubcategoryName</ToggleItem>
              </Visibility>
              <ReportItems>
                <Textbox Name="EnglishProductName">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>10pt</FontSize>
                    <BackgroundColor>#dedab5</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <BorderColor>
                      <Default>DarkGray</Default>
                    </BorderColor>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <rd:DefaultName>EnglishProductName</rd:DefaultName>
                  <Value>=Fields!EnglishProductName.Value</Value>
                  <CanGrow>true</CanGrow>
                  <Height>0.21in</Height>
                  <Width>1in</Width>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
            <Height>0.21in</Height>
          </ColumnGrouping>
        </ColumnGroupings>
      </Matrix>
    </ReportItems>
  </Body>
  <Language>en-US</Language>
  <LeftMargin>1in</LeftMargin>
  <RightMargin>1in</RightMargin>
  <TopMargin>1in</TopMargin>
  <BottomMargin>1in</BottomMargin>
  <PageWidth>8.5in</PageWidth>
  <PageHeight>11in</PageHeight>
  <DataSets>
    <DataSet Name="DataSet1">
      <Fields>
        <Field Name="EnglishProductCategoryName">
          <DataField>EnglishProductCategoryName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EnglishProductSubcategoryName">
          <DataField>EnglishProductSubcategoryName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EnglishProductName">
          <DataField>EnglishProductName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="SalesTerritoryRegion">
          <DataField>SalesTerritoryRegion</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="SalesTerritoryCountry">
          <DataField>SalesTerritoryCountry</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="SalesTerritoryGroup">
          <DataField>SalesTerritoryGroup</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="SalesAmount">
          <DataField>SalesAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>AdventureWorksDW2012</DataSourceName>
        <CommandType>Text</CommandType>
        <CommandText>SELECT        DimProductCategory.EnglishProductCategoryName, DimProductSubcategory.EnglishProductSubcategoryName, DimProduct.EnglishProductName, 
                         DimSalesTerritory.SalesTerritoryRegion, DimSalesTerritory.SalesTerritoryCountry, DimSalesTerritory.SalesTerritoryGroup, 
                         FactInternetSales.SalesAmount
FROM            DimProduct INNER JOIN
                         DimProductSubcategory ON DimProduct.ProductSubcategoryKey = DimProductSubcategory.ProductSubcategoryKey INNER JOIN
                         DimProductCategory ON DimProductSubcategory.ProductCategoryKey = DimProductCategory.ProductCategoryKey INNER JOIN
                         FactInternetSales ON DimProduct.ProductKey = FactInternetSales.ProductKey INNER JOIN
                         DimSalesTerritory ON FactInternetSales.SalesTerritoryKey = DimSalesTerritory.SalesTerritoryKey</CommandText>
        <Timeout>0</Timeout>
      </Query>
    </DataSet>
  </DataSets>
</Report>