<?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 YearFROM 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.CategoryIDGROUP 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>