📄 nworders1997win.rdlc

📁 wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载
💻 RDLC
字号:
<?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="NorthwindConnectionString">
      <ConnectionProperties>
        <ConnectString>Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True</ConnectString>
        <DataProvider>SQL</DataProvider>
      </ConnectionProperties>
      <rd:DataSourceID>b756d8f9-fb2d-45a6-bbd4-0c9de2c6ed7e</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <BottomMargin>0.5in</BottomMargin>
  <RightMargin>0.5in</RightMargin>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ReportItems>
      <Textbox Name="textbox1">
        <Left>0.05208in</Left>
        <rd:DefaultName>textbox1</rd:DefaultName>
        <ZIndex>1</ZIndex>
        <Width>5.19792in</Width>
        <Style>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingBottom>2pt</PaddingBottom>
          <FontFamily>Haettenschweiler</FontFamily>
          <FontSize>18pt</FontSize>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
        </Style>
        <CanGrow>true</CanGrow>
        <Height>0.375in</Height>
        <Value>Northwind Traders Quarterly Product Orders for 1997</Value>
      </Textbox>
      <Matrix Name="matrix1">
        <MatrixColumns>
          <MatrixColumn>
            <Width>0.80208in</Width>
          </MatrixColumn>
        </MatrixColumns>
        <RowGroupings>
          <RowGrouping>
            <Width>1.125in</Width>
            <DynamicRows>
              <ReportItems>
                <Textbox Name="textbox2">
                  <rd:DefaultName>textbox2</rd:DefaultName>
                  <ZIndex>3</ZIndex>
                  <Style>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingBottom>2pt</PaddingBottom>
                    <FontWeight>700</FontWeight>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!CategoryName.Value</Value>
                </Textbox>
              </ReportItems>
              <Grouping Name="matrix1_RowGroup2">
                <GroupExpressions>
                  <GroupExpression>=Fields!CategoryName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
            </DynamicRows>
          </RowGrouping>
          <RowGrouping>
            <Width>2.51042in</Width>
            <DynamicRows>
              <ReportItems>
                <Textbox Name="ProductName">
                  <rd:DefaultName>ProductName</rd:DefaultName>
                  <ZIndex>2</ZIndex>
                  <Style>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingBottom>2pt</PaddingBottom>
                    <BackgroundColor>Gainsboro</BackgroundColor>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!ProductName.Value</Value>
                </Textbox>
              </ReportItems>
              <Subtotal>
                <ReportItems>
                  <Textbox Name="textbox3">
                    <rd:DefaultName>textbox3</rd:DefaultName>
                    <Style>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <FontWeight>700</FontWeight>
                      <Format>C0</Format>
                      <BackgroundColor>Gainsboro</BackgroundColor>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>= Fields!CategoryName.Value &amp; " Subtotal"</Value>
                  </Textbox>
                </ReportItems>
              </Subtotal>
              <Grouping Name="matrix1_ProductName">
                <GroupExpressions>
                  <GroupExpression>=Fields!ProductName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
            </DynamicRows>
          </RowGrouping>
        </RowGroupings>
        <ColumnGroupings>
          <ColumnGrouping>
            <DynamicColumns>
              <ReportItems>
                <Textbox Name="Quarter">
                  <rd:DefaultName>Quarter</rd:DefaultName>
                  <ZIndex>5</ZIndex>
                  <Style>
                    <TextAlign>Right</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingBottom>2pt</PaddingBottom>
                    <FontWeight>700</FontWeight>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Quarter.Value</Value>
                </Textbox>
              </ReportItems>
              <Subtotal>
                <ReportItems>
                  <Textbox Name="textbox5">
                    <rd:DefaultName>textbox5</rd:DefaultName>
                    <ZIndex>4</ZIndex>
                    <Style>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <FontWeight>700</FontWeight>
                      <Format>C0</Format>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>Year Total</Value>
                  </Textbox>
                </ReportItems>
              </Subtotal>
              <Grouping Name="matrix1_Quarter">
                <GroupExpressions>
                  <GroupExpression>=Fields!Quarter.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
            </DynamicColumns>
            <Height>0.25in</Height>
          </ColumnGrouping>
        </ColumnGroupings>
        <DataSetName>NorthwindDataSet_NWOrders1997</DataSetName>
        <Top>0.375in</Top>
        <Width>5.23958in</Width>
        <Corner>
          <ReportItems>
            <Textbox Name="textbox4">
              <rd:DefaultName>textbox4</rd:DefaultName>
              <ZIndex>6</ZIndex>
              <Style>
                <TextAlign>Right</TextAlign>
                <PaddingLeft>2pt</PaddingLeft>
                <PaddingBottom>2pt</PaddingBottom>
                <FontWeight>700</FontWeight>
                <PaddingRight>2pt</PaddingRight>
                <PaddingTop>2pt</PaddingTop>
              </Style>
              <CanGrow>true</CanGrow>
              <Value>Quarter</Value>
            </Textbox>
          </ReportItems>
        </Corner>
        <MatrixRows>
          <MatrixRow>
            <Height>0.25in</Height>
            <MatrixCells>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="ProductOrders">
                    <rd:DefaultName>ProductOrders</rd:DefaultName>
                    <ZIndex>1</ZIndex>
                    <Style>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingBottom>2pt</PaddingBottom>
                      <Format>C0</Format>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>=Sum(Fields!ProductOrders.Value)</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
            </MatrixCells>
          </MatrixRow>
        </MatrixRows>
      </Matrix>
    </ReportItems>
    <Height>1.125in</Height>
  </Body>
  <rd:ReportID>85fe3b88-0412-4ac5-9bef-ed0daed798f6</rd:ReportID>
  <LeftMargin>0.5in</LeftMargin>
  <DataSets>
    <DataSet Name="NorthwindDataSet_NWOrders1997">
      <rd:DataSetInfo>
        <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
        <rd:DataSetName>NorthwindDataSet</rd:DataSetName>
        <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
        <rd:TableAdapterName>NWOrders1997TableAdapter</rd:TableAdapterName>
        <rd:TableName>NWOrders1997</rd:TableName>
      </rd:DataSetInfo>
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText>SELECT     Products.ProductName, Categories.CategoryName, '1997Q' + CONVERT(varchar, DATEPART(quarter, Orders.OrderDate)) AS Quarter, CONVERT(money, 
                      SUM(([Order Details].UnitPrice * [Order Details].Quantity) * (1 - [Order Details].Discount))) AS ProductOrders
FROM         Categories INNER JOIN
                      Products INNER JOIN
                      Orders INNER JOIN
                      [Order Details] ON Orders.OrderID = [Order Details].OrderID ON Products.ProductID = [Order Details].ProductID ON 
                      Categories.CategoryID = Products.CategoryID
WHERE     (Orders.OrderDate BETWEEN '1/1/1997' AND '12/31/1997')
GROUP BY Products.ProductName, Categories.CategoryName, DATEPART(quarter, Orders.OrderDate)
ORDER BY Categories.CategoryName, Products.ProductName, Quarter</CommandText>
        <DataSourceName>NorthwindConnectionString</DataSourceName>
      </Query>
      <Fields>
        <Field Name="ProductName">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>ProductName</DataField>
        </Field>
        <Field Name="CategoryName">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>CategoryName</DataField>
        </Field>
        <Field Name="Quarter">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Quarter</DataField>
        </Field>
        <Field Name="ProductOrders">
          <rd:TypeName>System.Decimal</rd:TypeName>
          <DataField>ProductOrders</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Author>Roger Jennings</Author>
  <Code />
  <Width>6.125in</Width>
  <InteractiveHeight>22in</InteractiveHeight>
  <Description>Sample crosstab (matrix) report</Description>
  <Language>en-US</Language>
  <TopMargin>0.5in</TopMargin>
</Report>
⌨️ 快捷键说明

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