freeform.rdl

来自「< SQL Server2005程序设计>」· RDL 代码 · 共 183 行

RDL
183 行
字号 
<?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>dc3a6a3e-02cc-4d7a-ac23-9e59c5dd2453</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>
      <List Name="list1">
        <Sorting>
          <SortBy>
            <SortExpression>=Fields!Territory.Value</SortExpression>
            <Direction>Ascending</Direction>
          </SortBy>
        </Sorting>
        <Left>0.25in</Left>
        <ReportItems>
          <Line Name="line2">
            <Top>0.51in</Top>
            <ZIndex>4</ZIndex>
            <Style>
              <BorderStyle>
                <Default>Solid</Default>
              </BorderStyle>
            </Style>
          </Line>
          <Textbox Name="SalesYTD">
            <Left>4.5in</Left>
            <rd:DefaultName>SalesYTD</rd:DefaultName>
            <ZIndex>3</ZIndex>
            <Style>
              <TextAlign>Right</TextAlign>
              <PaddingLeft>2pt</PaddingLeft>
              <PaddingBottom>2pt</PaddingBottom>
              <FontFamily>Verdana</FontFamily>
              <FontSize>8pt</FontSize>
              <Format>C0</Format>
              <Color>=iif(Fields!SalesYTD.Value&gt;Fields!SalesLastYear.Value,"Green","Red")</Color>
              <PaddingRight>2pt</PaddingRight>
              <PaddingTop>2pt</PaddingTop>
            </Style>
            <CanGrow>true</CanGrow>
            <Height>0.25in</Height>
            <Value>=Fields!SalesYTD.Value</Value>
          </Textbox>
          <Textbox Name="SalesLastYear">
            <Left>4.5in</Left>
            <Top>0.25in</Top>
            <rd:DefaultName>SalesLastYear</rd:DefaultName>
            <ZIndex>2</ZIndex>
            <Style>
              <TextAlign>Right</TextAlign>
              <PaddingLeft>2pt</PaddingLeft>
              <PaddingBottom>2pt</PaddingBottom>
              <FontFamily>Verdana</FontFamily>
              <FontSize>8pt</FontSize>
              <Format>C0</Format>
              <PaddingRight>2pt</PaddingRight>
              <PaddingTop>2pt</PaddingTop>
            </Style>
            <CanGrow>true</CanGrow>
            <Height>0.25in</Height>
            <Value>=Fields!SalesLastYear.Value</Value>
          </Textbox>
          <Textbox Name="Total">
            <Left>2.625in</Left>
            <rd:DefaultName>Total</rd:DefaultName>
            <ZIndex>1</ZIndex>
            <Width>1in</Width>
            <Style>
              <TextAlign>Right</TextAlign>
              <PaddingLeft>2pt</PaddingLeft>
              <PaddingBottom>2pt</PaddingBottom>
              <FontFamily>Verdana</FontFamily>
              <FontSize>8pt</FontSize>
              <Format>C0</Format>
              <PaddingRight>2pt</PaddingRight>
              <PaddingTop>2pt</PaddingTop>
            </Style>
            <CanGrow>true</CanGrow>
            <Height>0.25in</Height>
            <Value>=Fields!Total.Value</Value>
          </Textbox>
          <Textbox Name="Territory">
            <rd:DefaultName>Territory</rd:DefaultName>
            <Width>1.75in</Width>
            <Style>
              <PaddingLeft>2pt</PaddingLeft>
              <PaddingBottom>2pt</PaddingBottom>
              <FontFamily>Verdana</FontFamily>
              <FontWeight>700</FontWeight>
              <FontSize>8pt</FontSize>
              <PaddingRight>2pt</PaddingRight>
              <PaddingTop>2pt</PaddingTop>
            </Style>
            <CanGrow>true</CanGrow>
            <Height>0.25in</Height>
            <Value>=Fields!Territory.Value</Value>
          </Textbox>
        </ReportItems>
        <DataSetName>TerritoryTotals</DataSetName>
        <Top>0.625in</Top>
        <ZIndex>2</ZIndex>
        <Width>5.5in</Width>
        <Height>0.51in</Height>
      </List>
      <Textbox Name="textbox1">
        <Left>0.25in</Left>
        <Top>0.125in</Top>
        <rd:DefaultName>textbox1</rd:DefaultName>
        <ZIndex>1</ZIndex>
        <Width>3in</Width>
        <Style>
          <BorderStyle>
            <Default>Double</Default>
          </BorderStyle>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingBottom>2pt</PaddingBottom>
          <FontFamily>Verdana</FontFamily>
          <FontWeight>700</FontWeight>
          <FontSize>14pt</FontSize>
          <Color>Maroon</Color>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
        </Style>
        <CanGrow>true</CanGrow>
        <Height>0.375in</Height>
        <Value>Free Form Report</Value>
      </Textbox>
      <Subreport Name="subreport1">
        <Left>0.25in</Left>
        <Top>1.375in</Top>
        <Width>3in</Width>
        <ReportName>Chart</ReportName>
        <Height>3in</Height>
      </Subreport>
    </ReportItems>
    <Height>4.5in</Height>
  </Body>
  <rd:ReportID>b6e81edd-113b-46a9-a3fb-f5d69c9e047f</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="TerritoryTotals">
      <Query>
        <CommandText>SELECT     Sales.SalesTerritory.Name AS Territory, SUM(Sales.SalesOrderHeader.TotalDue) AS Total, Sales.SalesTerritory.SalesLastYear, 
                      Sales.SalesTerritory.SalesYTD
FROM         Sales.SalesTerritory INNER JOIN
                      Sales.SalesOrderHeader ON Sales.SalesTerritory.TerritoryID = Sales.SalesOrderHeader.TerritoryID
GROUP BY Sales.SalesTerritory.Name, Sales.SalesTerritory.SalesLastYear, Sales.SalesTerritory.SalesYTD</CommandText>
        <DataSourceName>AdventureWorks</DataSourceName>
      </Query>
      <Fields>
        <Field Name="Territory">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Territory</DataField>
        </Field>
        <Field Name="Total">
          <rd:TypeName>System.Decimal</rd:TypeName>
          <DataField>Total</DataField>
        </Field>
        <Field Name="SalesLastYear">
          <rd:TypeName>System.Decimal</rd:TypeName>
          <DataField>SalesLastYear</DataField>
        </Field>
        <Field Name="SalesYTD">
          <rd:TypeName>System.Decimal</rd:TypeName>
          <DataField>SalesYTD</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>6.5in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>

freeform.rdl - 源码说明

本页面展示了「&lt; SQL Server2005程序设计&gt;」中的 freeform.rdl 源码文件，采用 RDL 编程语言编写，共 183 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Server相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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