<?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> <Table Name="table1"> <Height>1.25in</Height> <Style /> <Header> <TableRows> <TableRow> <Height>0.25in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox2"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>19</ZIndex> <rd:DefaultName>textbox2</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Parameters!Group1.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox4"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>18</ZIndex> <CanGrow>true</CanGrow> <Value>=Parameters!Group2.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox1"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>17</ZIndex> <rd:DefaultName>textbox1</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Parameters!Group3.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox29"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>16</ZIndex> <rd:DefaultName>textbox29</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Quantity</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> <RepeatOnNewPage>true</RepeatOnNewPage> </Header> <DataSetName>DataSet1</DataSetName> <Width>5.25in</Width> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <Height>0.25in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox10"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>15</ZIndex> <rd:DefaultName>textbox10</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields(iif(Parameters!Group1.Value is Nothing, "Year", Parameters!Group1.Value)).Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox11"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>14</ZIndex> <rd:DefaultName>textbox11</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox5"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>13</ZIndex> <rd:DefaultName>textbox5</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Quantity_2"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>12</ZIndex> <rd:DefaultName>Quantity_2</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Sum(Fields!Quantity.Value)</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Visibility> <Hidden>=Parameters!Group1.Value is Nothing</Hidden> </Visibility> </TableRow> </TableRows> </Header> <Grouping Name="table1_Group1"> <GroupExpressions> <GroupExpression>=iif(Parameters!Group1.Value is Nothing,1,Fields(iif(Parameters!Group1.Value is Nothing, "Year",Parameters!Group1.Value)).Value)</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> <TableGroup> <Header> <TableRows> <TableRow> <Height>0.25in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox16"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>11</ZIndex> <rd:DefaultName>textbox16</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox3"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>10</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields(iif(Parameters!Group2.Value is Nothing, "Year", Parameters!Group2.Value)).Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox9"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>9</ZIndex> <rd:DefaultName>textbox9</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Quantity_3"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>8</ZIndex> <rd:DefaultName>Quantity_3</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Sum(Fields!Quantity.Value)</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Visibility> <Hidden>=Parameters!Group2.Value is Nothing</Hidden> </Visibility> </TableRow> </TableRows> </Header> <Grouping Name="table1_Group2"> <GroupExpressions> <GroupExpression>=iif(Parameters!Group2.Value is Nothing,1,Fields(iif(Parameters!Group2.Value is Nothing, "Year",Parameters!Group2.Value)).Value)</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> <TableGroup> <Header> <TableRows> <TableRow> <Height>0.25in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox6"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>7</ZIndex> <rd:DefaultName>textbox6</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox8"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>6</ZIndex> <rd:DefaultName>textbox8</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox7"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>5</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields(iif(Parameters!Group3.Value is Nothing, "Year", Parameters!Group3.Value)).Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Quantity_4"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>4</ZIndex> <rd:DefaultName>Quantity_4</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Sum(Fields!Quantity.Value)</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Visibility> <Hidden>=Parameters!Group3.Value is Nothing</Hidden> </Visibility> </TableRow> </TableRows> </Header> <Grouping Name="table1_Group3"> <GroupExpressions> <GroupExpression>=iif(Parameters!Group3.Value is Nothing,1,Fields(iif(Parameters!Group3.Value is Nothing, "Year",Parameters!Group3.Value)).Value)</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <Footer> <TableRows> <TableRow> <Height>0.25in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox12"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>3</ZIndex> <rd:DefaultName>textbox12</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Total</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox13"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>2</ZIndex> <rd:DefaultName>textbox13</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox14"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>1</ZIndex> <rd:DefaultName>textbox14</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox17"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <CanGrow>true</CanGrow> <Value>=Sum(Fields!Quantity.Value)</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Footer> <TableColumns> <TableColumn> <Width>1.5in</Width> <Visibility> <Hidden>=Parameters!Group1.Value is Nothing</Hidden> </Visibility> </TableColumn> <TableColumn> <Width>1.5in</Width> <Visibility> <Hidden>=Parameters!Group2.Value is Nothing</Hidden> </Visibility> </TableColumn> <TableColumn> <Width>1.5in</Width> <Visibility> <Hidden>=Parameters!Group3.Value is Nothing</Hidden> </Visibility> </TableColumn> <TableColumn> <Width>0.75in</Width> </TableColumn> </TableColumns> </Table> </ReportItems> <Style /> <Height>1.375in</Height> </Body> <TopMargin>1in</TopMargin> <DataSources> <DataSource Name="AdventureWorks2000"> <rd:DataSourceID>5db4126a-bb58-4b0a-b47b-5d13aa506c1d</rd:DataSourceID> <ConnectionProperties> <DataProvider>SQL</DataProvider> <ConnectString>data source=.;initial catalog=AdventureWorks2000</ConnectString> <IntegratedSecurity>true</IntegratedSecurity> </ConnectionProperties> </DataSource> </DataSources> <Width>5.375in</Width> <DataSets> <DataSet Name="DataSet1"> <Fields> <Field Name="Product"> <DataField>Product</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="SubCategory"> <DataField>SubCategory</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Category"> <DataField>Category</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Quantity"> <DataField>Quantity</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Year"> <DataField>Year</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Territory"> <DataField>Territory</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>AdventureWorks2000</DataSourceName> <CommandText>SELECT Product.Name AS Product, ProductSubCategory.Name AS SubCategory, ProductCategory.Name AS Category, SUM(SalesOrderDetail.OrderQty) AS Quantity, DATEPART(yyyy, SalesOrderHeader.OrderDate) AS Year, SalesTerritory.Name AS TerritoryFROM Product INNER JOIN ProductSubCategory ON Product.ProductSubCategoryID = ProductSubCategory.ProductSubCategoryID INNER JOIN ProductCategory ON ProductSubCategory.ProductCategoryID = ProductCategory.ProductCategoryID INNER JOIN SalesOrderDetail ON Product.ProductID = SalesOrderDetail.ProductID INNER JOIN SalesOrderHeader ON SalesOrderDetail.SalesOrderID = SalesOrderHeader.SalesOrderID INNER JOIN SalesTerritory ON SalesOrderHeader.TerritoryID = SalesTerritory.TerritoryIDGROUP BY Product.Name, ProductSubCategory.Name, ProductCategory.Name, SalesOrderHeader.OrderDate, SalesTerritory.Name</CommandText> </Query> </DataSet> </DataSets> <LeftMargin>1in</LeftMargin> <rd:SnapToGrid>true</rd:SnapToGrid> <rd:DrawGrid>true</rd:DrawGrid> <Description /> <rd:ReportID>5f07b29a-5f39-47c0-92ae-56c8ab0b31cc</rd:ReportID> <BottomMargin>1in</BottomMargin> <ReportParameters> <ReportParameter Name="Group1"> <DataType>String</DataType> <Nullable>true</Nullable> <DefaultValue> <Values> <Value>Category</Value> </Values> </DefaultValue> <Prompt>Group 1</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>Category</Value> </ParameterValue> <ParameterValue> <Value>Year</Value> </ParameterValue> <ParameterValue> <Value>Territory</Value> </ParameterValue> <ParameterValue> <Label>None</Label> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> <ReportParameter Name="Group2"> <DataType>String</DataType> <Nullable>true</Nullable> <DefaultValue> <Values> <Value>Year</Value> </Values> </DefaultValue> <Prompt>Group 2</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>Category</Value> </ParameterValue> <ParameterValue> <Value>Year</Value> </ParameterValue> <ParameterValue> <Value>Territory</Value> </ParameterValue> <ParameterValue> <Label>None</Label> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> <ReportParameter Name="Group3"> <DataType>String</DataType> <Nullable>true</Nullable> <DefaultValue> <Values> <Value>Territory</Value> </Values> </DefaultValue> <Prompt>Group 3</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>Category</Value> </ParameterValue> <ParameterValue> <Value>Year</Value> </ParameterValue> <ParameterValue> <Value>Territory</Value> </ParameterValue> <ParameterValue> <Label>None</Label> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> </ReportParameters></Report>