<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <RightMargin>1in</RightMargin>
  <Body>
    <ReportItems>
      <Matrix Name="matrix1">
        <Corner>
          <ReportItems>
            <Textbox Name="textbox1">
              <Style>
                <PaddingLeft>2pt</PaddingLeft>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
                <PaddingBottom>2pt</PaddingBottom>
                <PaddingTop>2pt</PaddingTop>
                <PaddingRight>2pt</PaddingRight>
              </Style>
              <ZIndex>4</ZIndex>
              <rd:DefaultName>textbox1</rd:DefaultName>
              <CanGrow>true</CanGrow>
              <Value />
            </Textbox>
          </ReportItems>
        </Corner>
        <Height>0.5in</Height>
        <Style />
        <MatrixRows>
          <MatrixRow>
            <MatrixCells>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="Qty">
                    <Style>
                      <PaddingLeft>2pt</PaddingLeft>
                      <BackgroundColor>=ReportItems!Color.Value</BackgroundColor>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <TextAlign>Right</TextAlign>
                      <PaddingBottom>2pt</PaddingBottom>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingRight>2pt</PaddingRight>
                    </Style>
                    <rd:DefaultName>Qty</rd:DefaultName>
                    <CanGrow>true</CanGrow>
                    <Value>=Sum(Fields!Qty.Value)</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
            </MatrixCells>
            <Height>0.25in</Height>
          </MatrixRow>
        </MatrixRows>
        <MatrixColumns>
          <MatrixColumn>
            <Width>0.875in</Width>
          </MatrixColumn>
        </MatrixColumns>
        <DataSetName>DataSet1</DataSetName>
        <ColumnGroupings>
          <ColumnGrouping>
            <DynamicColumns>
              <Grouping Name="Category">
                <GroupExpressions>
                  <GroupExpression>=Fields!CategoryName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="CategoryName">
                  <Style>
                    <PaddingLeft>2pt</PaddingLeft>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <TextAlign>Right</TextAlign>
                    <PaddingBottom>2pt</PaddingBottom>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingRight>2pt</PaddingRight>
                  </Style>
                  <ZIndex>3</ZIndex>
                  <rd:DefaultName>CategoryName</rd:DefaultName>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!CategoryName.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
            <Height>0.25in</Height>
          </ColumnGrouping>
        </ColumnGroupings>
        <Width>2in</Width>
        <Top>0.125in</Top>
        <Left>0.125in</Left>
        <RowGroupings>
          <RowGrouping>
            <DynamicRows>
              <Grouping Name="Country">
                <GroupExpressions>
                  <GroupExpression>=Fields!Country.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="Country">
                  <Style>
                    <PaddingLeft>2pt</PaddingLeft>
                    <BackgroundColor>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothing) Mod 2, "AliceBlue", "White")</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                      <Right>None</Right>
                    </BorderStyle>
                    <PaddingBottom>2pt</PaddingBottom>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingRight>2pt</PaddingRight>
                  </Style>
                  <ZIndex>2</ZIndex>
                  <rd:DefaultName>Country</rd:DefaultName>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Country.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
            <Width>1in</Width>
          </RowGrouping>
          <RowGrouping>
            <DynamicRows>
              <Grouping Name="Count">
                <GroupExpressions>
                  <GroupExpression>=1</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="Color">
                  <Style>
                    <PaddingLeft>2pt</PaddingLeft>
                    <BackgroundColor>=Value</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                      <Left>None</Left>
                    </BorderStyle>
                    <FontSize>1pt</FontSize>
                    <Color>=Value</Color>
                    <PaddingBottom>2pt</PaddingBottom>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingRight>2pt</PaddingRight>
                  </Style>
                  <ZIndex>1</ZIndex>
                  <CanGrow>true</CanGrow>
                  <Value>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothing) Mod 2, "AliceBlue", "White")</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
            <Width>0.125in</Width>
          </RowGrouping>
        </RowGroupings>
      </Matrix>
    </ReportItems>
    <Style />
    <Height>0.75in</Height>
  </Body>
  <TopMargin>1in</TopMargin>
  <DataSources>
    <DataSource Name="Northwind">
      <rd:DataSourceID>26f1bf87-1fa6-4e77-8d1a-81b0cd940403</rd:DataSourceID>
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>data source=.;initial catalog=Northwind</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
    </DataSource>
  </DataSources>
  <Code />
  <Width>2.25in</Width>
  <DataSets>
    <DataSet Name="DataSet1">
      <Fields>
        <Field Name="Country">
          <DataField>Country</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Qty">
          <DataField>Qty</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="CategoryName">
          <DataField>CategoryName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Year">
          <DataField>Year</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>Northwind</DataSourceName>
        <CommandText>SELECT     Customers.Country, SUM([Order Details].Quantity) AS Qty, Categories.CategoryName, DATEPART(yyyy, Orders.OrderDate) AS Year
FROM         Customers INNER JOIN
                      Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN
                      [Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN
                      Products ON [Order Details].ProductID = Products.ProductID INNER JOIN
                      Categories ON Products.CategoryID = Categories.CategoryID
GROUP BY Customers.Country, Categories.CategoryName, DATEPART(yyyy, Orders.OrderDate)</CommandText>
      </Query>
    </DataSet>
  </DataSets>
  <LeftMargin>1in</LeftMargin>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <rd:DrawGrid>true</rd:DrawGrid>
  <Description />
  <rd:ReportID>ab2c120b-3169-427d-8ad6-b8716f8c5101</rd:ReportID>
  <BottomMargin>1in</BottomMargin>
</Report>