⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 reporttemplate.rdl

📁 数据仓库开发的很好的一个例子
💻 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">
  <InteractiveHeight>11in</InteractiveHeight>
  <rd:ReportID>c9f4fc24-d8d4-4d33-a57e-5b3326bc9fd5</rd:ReportID>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ReportItems>
      <Textbox Name="textbox5">
        <rd:DefaultName>textbox5</rd:DefaultName>
        <Top>0.8525in</Top>
        <ZIndex>2</ZIndex>
        <Style>
          <PaddingLeft>2pt</PaddingLeft>
          <BorderColor>
            <Left>Black</Left>
            <Right>Black</Right>
          </BorderColor>
          <BorderWidth>
            <Left>1pt</Left>
            <Right>1pt</Right>
          </BorderWidth>
          <PaddingTop>2pt</PaddingTop>
          <BorderStyle>
            <Left>Solid</Left>
            <Right>Solid</Right>
          </BorderStyle>
          <PaddingBottom>2pt</PaddingBottom>
          <PaddingRight>2pt</PaddingRight>
        </Style>
        <CanGrow>true</CanGrow>
        <Height>0.25in</Height>
        <Value>Select a Subject Area Name below to view the Objects it contains.</Value>
      </Textbox>
      <Table Name="table1">
        <DataSetName>Subject_Areas</DataSetName>
        <Top>1.1025in</Top>
        <ZIndex>1</ZIndex>
        <Details>
          <TableRows>
            <TableRow>
              <Height>0.20087in</Height>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox2">
                      <rd:DefaultName>textbox2</rd:DefaultName>
                      <ZIndex>4</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox1">
                      <rd:DefaultName>textbox1</rd:DefaultName>
                      <ZIndex>3</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox3">
                      <rd:DefaultName>textbox3</rd:DefaultName>
                      <ZIndex>2</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox10">
                      <rd:DefaultName>textbox10</rd:DefaultName>
                      <ZIndex>1</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox4">
                      <rd:DefaultName>textbox4</rd:DefaultName>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
            </TableRow>
          </TableRows>
        </Details>
        <Style>
          <BorderColor>
            <Top>DarkBlue</Top>
          </BorderColor>
          <BorderWidth>
            <Top>3pt</Top>
          </BorderWidth>
          <BorderStyle>
            <Top>Solid</Top>
          </BorderStyle>
        </Style>
        <Header>
          <TableRows>
            <TableRow>
              <Height>0.21913in</Height>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox6">
                      <ZIndex>9</ZIndex>
                      <Style>
                        <FontWeight>700</FontWeight>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Times New Roman</FontFamily>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Left>Black</Left>
                        </BorderColor>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Left>1pt</Left>
                        </BorderWidth>
                        <PaddingTop>2pt</PaddingTop>
                        <FontSize>12pt</FontSize>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Left>Solid</Left>
                        </BorderStyle>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <TextAlign>Right</TextAlign>
                        <Color>DarkBlue</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>ID</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox7">
                      <ZIndex>8</ZIndex>
                      <Style>
                        <FontWeight>700</FontWeight>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Times New Roman</FontFamily>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                        </BorderColor>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                        </BorderWidth>
                        <PaddingTop>2pt</PaddingTop>
                        <FontSize>12pt</FontSize>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Subject Area Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox8">
                      <ZIndex>7</ZIndex>
                      <Style>
                        <FontWeight>700</FontWeight>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Times New Roman</FontFamily>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                        </BorderColor>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                        </BorderWidth>
                        <PaddingTop>2pt</PaddingTop>
                        <FontSize>12pt</FontSize>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Short Descr</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox9">
                      <ZIndex>6</ZIndex>
                      <Style>
                        <FontWeight>700</FontWeight>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Times New Roman</FontFamily>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Right>Black</Right>
                        </BorderColor>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingTop>2pt</PaddingTop>
                        <FontSize>12pt</FontSize>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Data Model</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox14">
                      <ZIndex>5</ZIndex>
                      <Style>
                        <FontWeight>700</FontWeight>
                        <PaddingLeft>2pt</PaddingLeft>
                        <FontFamily>Times New Roman</FontFamily>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Right>Black</Right>
                        </BorderColor>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingTop>2pt</PaddingTop>
                        <FontSize>12pt</FontSize>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Status</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
            </TableRow>
          </TableRows>
          <RepeatOnNewPage>true</RepeatOnNewPage>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>0.5in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.625in</Width>
          </TableColumn>
          <TableColumn>
            <Width>3.125in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.75in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.75in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.42in</Height>
      </Table>
      <Textbox Name="textbox17">
        <Top>0.4775in</Top>
        <Style>
          <FontWeight>700</FontWeight>
          <PaddingLeft>2pt</PaddingLeft>
          <FontFamily>Times New Roman</FontFamily>
          <BorderColor>
            <Bottom>DarkBlue</Bottom>
            <Left>Black</Left>
            <Top>DarkBlue</Top>
            <Right>Black</Right>
          </BorderColor>
          <BorderWidth>
            <Bottom>3pt</Bottom>
            <Left>1pt</Left>
            <Top>3pt</Top>
            <Right>1pt</Right>
          </BorderWidth>
          <PaddingTop>2pt</PaddingTop>
          <FontSize>18pt</FontSize>
          <BorderStyle>
            <Bottom>Solid</Bottom>
            <Left>Solid</Left>
            <Top>Solid</Top>
            <Right>Solid</Right>
          </BorderStyle>
          <BackgroundColor>LightGrey</BackgroundColor>
          <TextAlign>Center</TextAlign>
          <Color>DarkBlue</Color>
          <PaddingBottom>2pt</PaddingBottom>
          <PaddingRight>2pt</PaddingRight>
        </Style>
        <CanGrow>true</CanGrow>
        <Height>0.33in</Height>
        <Value>="Subject Areas in the " &amp; Parameters!DBName.Value &amp; " Database"</Value>
      </Textbox>
    </ReportItems>
    <Height>2in</Height>
    <Style />
  </Body>
  <BottomMargin>1in</BottomMargin>
  <LeftMargin>1in</LeftMargin>
  <RightMargin>1in</RightMargin>
  <Width>6.75in</Width>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>

⌨️ 快捷键说明

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