matrix.rdl

< SQL Server2005程序设计>
RDL
字号:
<?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="AdventureWorks">
      <DataSourceReference>AdventureWorks</DataSourceReference>
      <rd:DataSourceID>eb1324a2-510b-4679-bf1f-98f6f8429511</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <BottomMargin>1in</BottomMargin>
  <RightMargin>1in</RightMargin>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ReportItems>
      <Matrix Name="matrix1">
        <MatrixColumns>
          <MatrixColumn>
            <Width>0.875in</Width>
          </MatrixColumn>
          <MatrixColumn>
            <Width>0.625in</Width>
          </MatrixColumn>
        </MatrixColumns>
        <RowGroupings>
          <RowGrouping>
            <Width>1in</Width>
            <DynamicRows>
              <ReportItems>
                <Textbox Name="Territory">
                  <rd:DefaultName>Territory</rd:DefaultName>
                  <ZIndex>3</ZIndex>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingBottom>2pt</PaddingBottom>
                    <FontFamily>Verdana</FontFamily>
                    <FontSize>8pt</FontSize>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Territory.Value</Value>
                </Textbox>
              </ReportItems>
              <Grouping Name="matrix1_Territory">
                <GroupExpressions>
                  <GroupExpression>=Fields!Territory.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
            </DynamicRows>
          </RowGrouping>
          <RowGrouping>
            <Width>1.375in</Width>
            <DynamicRows>
              <ReportItems>
                <Textbox Name="AccountNumber">
                  <rd:DefaultName>AccountNumber</rd:DefaultName>
                  <ZIndex>2</ZIndex>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingBottom>2pt</PaddingBottom>
                    <FontFamily>Verdana</FontFamily>
                    <FontSize>8pt</FontSize>
                    <VerticalAlign>Middle</VerticalAlign>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!AccountNumber.Value</Value>
                </Textbox>
              </ReportItems>
              <Grouping Name="matrix1_AccountNumber">
                <GroupExpressions>
                  <GroupExpression>=Fields!AccountNumber.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
            </DynamicRows>
          </RowGrouping>
        </RowGroupings>
        <ColumnGroupings>
          <ColumnGrouping>
            <DynamicColumns>
              <ReportItems>
                <Textbox Name="Year">
                  <rd:DefaultName>Year</rd:DefaultName>
                  <ZIndex>6</ZIndex>
                  <Style>
                    <TextAlign>Right</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingBottom>2pt</PaddingBottom>
                    <FontFamily>Verdana</FontFamily>
                    <FontSize>8pt</FontSize>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Year.Value</Value>
                </Textbox>
              </ReportItems>
              <Grouping Name="matrix1_Year">
                <GroupExpressions>
                  <GroupExpression>=Fields!Year.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
            </DynamicColumns>
            <Height>0.25in</Height>
          </ColumnGrouping>
          <ColumnGrouping>
            <Height>0.25in</Height>
            <StaticColumns>
              <StaticColumn>
                <ReportItems>
                  <Textbox Name="textbox2">
                    <rd:DefaultName>textbox2</rd:DefaultName>
                    <ZIndex>5</ZIndex>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <FontFamily>Verdana</FontFamily>
                      <FontWeight>700</FontWeight>
                      <FontSize>8pt</FontSize>
                      <VerticalAlign>Middle</VerticalAlign>
                      <BackgroundColor>DimGray</BackgroundColor>
                      <Color>White</Color>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>Total Due</Value>
                  </Textbox>
                </ReportItems>
              </StaticColumn>
              <StaticColumn>
                <ReportItems>
                  <Textbox Name="textbox3">
                    <rd:DefaultName>textbox3</rd:DefaultName>
                    <ZIndex>4</ZIndex>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <FontFamily>Verdana</FontFamily>
                      <FontWeight>700</FontWeight>
                      <FontSize>8pt</FontSize>
                      <VerticalAlign>Middle</VerticalAlign>
                      <BackgroundColor>DimGray</BackgroundColor>
                      <Color>White</Color>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>Unit Qty</Value>
                  </Textbox>
                </ReportItems>
              </StaticColumn>
            </StaticColumns>
          </ColumnGrouping>
        </ColumnGroupings>
        <DataSetName>Sales</DataSetName>
        <Corner>
          <ReportItems>
            <Textbox Name="textbox1">
              <rd:DefaultName>textbox1</rd:DefaultName>
              <ZIndex>7</ZIndex>
              <Style>
                <PaddingLeft>2pt</PaddingLeft>
                <PaddingBottom>2pt</PaddingBottom>
                <FontFamily>Verdana</FontFamily>
                <FontWeight>700</FontWeight>
                <FontSize>12pt</FontSize>
                <PaddingRight>2pt</PaddingRight>
                <PaddingTop>2pt</PaddingTop>
              </Style>
              <CanGrow>true</CanGrow>
              <Value>Sales by 
Territory and Year</Value>
            </Textbox>
          </ReportItems>
        </Corner>
        <Style>
          <FontFamily>Verdana</FontFamily>
        </Style>
        <MatrixRows>
          <MatrixRow>
            <Height>0.25in</Height>
            <MatrixCells>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="TotalDue">
                    <rd:DefaultName>TotalDue</rd:DefaultName>
                    <ZIndex>1</ZIndex>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <FontFamily>Verdana</FontFamily>
                      <FontSize>8pt</FontSize>
                      <VerticalAlign>Middle</VerticalAlign>
                      <Format>C0</Format>
                      <BackgroundColor>Gainsboro</BackgroundColor>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>=Sum(Fields!TotalDue.Value)</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="Unit_Qty">
                    <rd:DefaultName>Unit_Qty</rd:DefaultName>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <FontFamily>Verdana</FontFamily>
                      <FontSize>8pt</FontSize>
                      <VerticalAlign>Middle</VerticalAlign>
                      <Format>N0</Format>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>=Sum(Fields!Unit_Qty.Value)</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
            </MatrixCells>
          </MatrixRow>
        </MatrixRows>
      </Matrix>
    </ReportItems>
    <Height>0.75in</Height>
  </Body>
  <rd:ReportID>e57906a3-32cb-48f4-a330-9762d2e25cb2</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="Sales">
      <Query>
        <CommandText>SELECT     Sales.SalesTerritory.Name AS Territory, Sales.Customer.AccountNumber, YEAR(Sales.SalesOrderHeader.OrderDate) AS Year, 
                      Sales.SalesOrderHeader.TotalDue, SUM(Sales.SalesOrderDetail.OrderQty) AS [Unit Qty]
FROM         Sales.SalesPerson INNER JOIN
                      Sales.SalesOrderHeader ON Sales.SalesPerson.SalesPersonID = Sales.SalesOrderHeader.SalesPersonID INNER JOIN
                      Sales.SalesOrderDetail ON Sales.SalesOrderHeader.SalesOrderID = Sales.SalesOrderDetail.SalesOrderID INNER JOIN
                      Sales.SalesTerritory ON Sales.SalesPerson.TerritoryID = Sales.SalesTerritory.TerritoryID AND 
                      Sales.SalesOrderHeader.TerritoryID = Sales.SalesTerritory.TerritoryID INNER JOIN
                      Sales.Customer ON Sales.SalesOrderHeader.CustomerID = Sales.Customer.CustomerID AND 
                      Sales.SalesTerritory.TerritoryID = Sales.Customer.TerritoryID
GROUP BY Sales.SalesTerritory.Name, Sales.Customer.AccountNumber, YEAR(Sales.SalesOrderHeader.OrderDate), Sales.SalesOrderHeader.TotalDue</CommandText>
        <DataSourceName>AdventureWorks</DataSourceName>
      </Query>
      <Fields>
        <Field Name="Territory">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Territory</DataField>
        </Field>
        <Field Name="AccountNumber">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>AccountNumber</DataField>
        </Field>
        <Field Name="Year">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Year</DataField>
        </Field>
        <Field Name="TotalDue">
          <rd:TypeName>System.Decimal</rd:TypeName>
          <DataField>TotalDue</DataField>
        </Field>
        <Field Name="Unit_Qty">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Unit Qty</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>3.875in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -