2 subject area listing .rdl

数据仓库开发的很好的一个例子

                          <Bottom>3pt</Bottom>
                          <Left>1pt</Left>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Left>Black</Left>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>ID</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox11">
                      <ZIndex>8</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Left>Solid</Left>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Left>1pt</Left>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Left>Black</Left>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Subject Area Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox12">
                      <ZIndex>7</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Left>Solid</Left>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Left>1pt</Left>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Left>Black</Left>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Short Descr</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox2">
                      <rd:DefaultName>textbox2</rd:DefaultName>
                      <ZIndex>6</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Left>Solid</Left>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Left>1pt</Left>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Left>Black</Left>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Data Model</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox13">
                      <ZIndex>5</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Left>Solid</Left>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Left>1pt</Left>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Left>Black</Left>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Status</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.25in</Height>
            </TableRow>
          </TableRows>
          <RepeatOnNewPage>true</RepeatOnNewPage>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>0.65679in</Width>
          </TableColumn>
          <TableColumn>
            <Width>2.83409in</Width>
          </TableColumn>
          <TableColumn>
            <Width>3.91375in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.98519in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.98518in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.45087in</Height>
      </Table>
    </ReportItems>
    <Height>2in</Height>
  </Body>
  <rd:ReportID>1e5c6c7f-f237-4957-b414-6871a3122b16</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="Subject_Areas">
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText>SELECT * FROM dbo.DW_Subject_Areas WHERE Database_ID = 11</CommandText>
        <DataSourceName>DW_Metadata_DB</DataSourceName>
      </Query>
      <Fields>
        <Field Name="Subject_Area_Key">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Subject_Area_Key</DataField>
        </Field>
        <Field Name="Database_ID">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Database_ID</DataField>
        </Field>
        <Field Name="Primary_Fact_Table_ID">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Primary_Fact_Table_ID</DataField>
        </Field>
        <Field Name="Subject_Area_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Subject_Area_Name</DataField>
        </Field>
        <Field Name="Subject_Area_Short_Descr">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Subject_Area_Short_Descr</DataField>
        </Field>
        <Field Name="Subject_Area_Long_Descr">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Subject_Area_Long_Descr</DataField>
        </Field>
        <Field Name="Business_Process_Area">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Business_Process_Area</DataField>
        </Field>
        <Field Name="Subject_Area_Status">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Subject_Area_Status</DataField>
        </Field>
        <Field Name="Subject_Area_Image">
          <rd:TypeName>System.Byte[]</rd:TypeName>
          <DataField>Subject_Area_Image</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>9.375in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>