📄 nworderschartwin.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>9d78d9f7-0a7a-4c49-8b80-becb76f4c867</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <BottomMargin>0.3in</BottomMargin>
  <RightMargin>0.3in</RightMargin>
  <PageWidth>11in</PageWidth>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ReportItems>
      <Chart Name="NWOrders1997Chart">
        <Legend>
          <Visible>true</Visible>
          <Style>
            <BorderStyle>
              <Default>Solid</Default>
            </BorderStyle>
            <BackgroundColor>Gainsboro</BackgroundColor>
          </Style>
          <Position>RightCenter</Position>
        </Legend>
        <Subtype>Stacked</Subtype>
        <Title>
          <Caption>Northwind Traders 1997 Quarterly Orders by Category</Caption>
          <Style>
            <FontWeight>700</FontWeight>
            <FontSize>12pt</FontSize>
          </Style>
        </Title>
        <CategoryAxis>
          <Axis>
            <Title />
            <MajorGridLines>
              <Style>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
              </Style>
            </MajorGridLines>
            <MinorGridLines>
              <Style>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
              </Style>
            </MinorGridLines>
            <MajorTickMarks>Outside</MajorTickMarks>
            <Min>0</Min>
            <Visible>true</Visible>
          </Axis>
        </CategoryAxis>
        <PointWidth>0</PointWidth>
        <ThreeDProperties>
          <Rotation>30</Rotation>
          <Inclination>30</Inclination>
          <Shading>Simple</Shading>
          <WallThickness>50</WallThickness>
        </ThreeDProperties>
        <DataSetName>NorthwindDataSet_NWOrders1997</DataSetName>
        <SeriesGroupings>
          <SeriesGrouping>
            <DynamicSeries>
              <Grouping Name="chart1_SeriesGroup1">
                <GroupExpressions>
                  <GroupExpression>=Fields!CategoryName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Label>=Fields!CategoryName.Value</Label>
            </DynamicSeries>
          </SeriesGrouping>
        </SeriesGroupings>
        <PlotArea>
          <Style>
            <BorderStyle>
              <Default>Solid</Default>
            </BorderStyle>
            <BackgroundColor>LightGrey</BackgroundColor>
          </Style>
        </PlotArea>
        <ValueAxis>
          <Axis>
            <Title>
              <Caption>Quarterly Orders</Caption>
              <Style>
                <FontWeight>700</FontWeight>
              </Style>
            </Title>
            <Style>
              <Format>C0</Format>
            </Style>
            <MajorGridLines>
              <ShowGridLines>true</ShowGridLines>
              <Style>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
              </Style>
            </MajorGridLines>
            <MinorGridLines>
              <Style>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
              </Style>
            </MinorGridLines>
            <MajorTickMarks>Outside</MajorTickMarks>
            <Min>0</Min>
            <MajorInterval>25000</MajorInterval>
            <Margin>true</Margin>
            <Visible>true</Visible>
            <Scalar>true</Scalar>
          </Axis>
        </ValueAxis>
        <Type>Area</Type>
        <CategoryGroupings>
          <CategoryGrouping>
            <DynamicCategories>
              <Grouping Name="chart1_CategoryGroup1">
                <GroupExpressions>
                  <GroupExpression>=Fields!Quarter.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <Label>=Fields!Quarter.Value</Label>
            </DynamicCategories>
          </CategoryGrouping>
        </CategoryGroupings>
        <Palette>Default</Palette>
        <ChartData>
          <ChartSeries>
            <DataPoints>
              <DataPoint>
                <DataValues>
                  <DataValue>
                    <Value>=Sum(Fields!ProductOrders.Value)</Value>
                  </DataValue>
                </DataValues>
                <DataLabel />
                <Marker />
              </DataPoint>
            </DataPoints>
          </ChartSeries>
        </ChartData>
        <Style>
          <BackgroundColor>White</BackgroundColor>
        </Style>
      </Chart>
    </ReportItems>
    <Height>4.5in</Height>
  </Body>
  <rd:ReportID>37060c22-c447-4c5b-8c65-afc90fc65b2d</rd:ReportID>
  <LeftMargin>0.3in</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>
  <Width>7.25in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>0.3in</TopMargin>
  <PageHeight>8.5in</PageHeight>
</Report>
⌨️ 快捷键说明

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