4 attribute listing .rdl

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

                        <PaddingBottom>2pt</PaddingBottom>
                        <FontSize>12pt</FontSize>
                        <BorderColor>
                          <Bottom>Black</Bottom>
                          <Right>Black</Right>
                        </BorderColor>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!Attribute_Status.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.25in</Height>
            </TableRow>
          </TableRows>
        </Details>
        <Style>
          <BorderStyle>
            <Top>Solid</Top>
          </BorderStyle>
          <BorderWidth>
            <Top>3pt</Top>
          </BorderWidth>
          <BorderColor>
            <Top>DarkBlue</Top>
          </BorderColor>
        </Style>
        <Header>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox18">
                      <ZIndex>14</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                          <Left>Solid</Left>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Top>1pt</Top>
                          <Left>1pt</Left>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Top>Black</Top>
                          <Left>Black</Left>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Attribute Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox5">
                      <rd:DefaultName>textbox5</rd:DefaultName>
                      <ZIndex>13</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Top>1pt</Top>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontFamily>Times New Roman</FontFamily>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Top>Black</Top>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox19">
                      <ZIndex>12</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Top>1pt</Top>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontFamily>Times New Roman</FontFamily>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Top>Black</Top>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox20">
                      <ZIndex>11</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                          <Right>None</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Top>1pt</Top>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontFamily>Times New Roman</FontFamily>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Top>Black</Top>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox21">
                      <ZIndex>10</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Top>Solid</Top>
                          <Left>None</Left>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Top>1pt</Top>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontFamily>Times New Roman</FontFamily>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Top>Black</Top>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.25in</Height>
            </TableRow>
          </TableRows>
          <RepeatOnNewPage>true</RepeatOnNewPage>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>3.5in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.05687in</Width>
          </TableColumn>
          <TableColumn>
            <Width>3.77454in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.05687in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.90589in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.75in</Height>
      </Table>
    </ReportItems>
    <Height>1.25in</Height>
  </Body>
  <rd:ReportID>09d3c7a5-526b-4f0d-bfe9-07b650b1b109</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="AttributeList">
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText>select * from dbo.DW_Attributes
where Database_ID = 11 and object_id = 149575571</CommandText>
        <DataSourceName>DW_Metadata_DB</DataSourceName>
      </Query>
      <Fields>
        <Field Name="Attribute_Key">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Attribute_Key</DataField>
        </Field>
        <Field Name="Attribute_ID">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_ID</DataField>
        </Field>
        <Field Name="Database_ID">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Database_ID</DataField>
        </Field>
        <Field Name="Object_ID">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Object_ID</DataField>
        </Field>
        <Field Name="Attribute_sequence">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Attribute_Sequence</DataField>
        </Field>
        <Field Name="Attribute_Display_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Display_Name</DataField>
        </Field>
        <Field Name="Attribute_Physical_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Physical_Name</DataField>
        </Field>
        <Field Name="Attribute_Group_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Group_Name</DataField>
        </Field>
        <Field Name="Datatype">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Datatype</DataField>
        </Field>
        <Field Name="Attribute_length">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Attribute_Length</DataField>
        </Field>
        <Field Name="Attribute_Short_Descr">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Short_Descr</DataField>
        </Field>
        <Field Name="Attribute_Long_Descr">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Long_Descr</DataField>
        </Field>
        <Field Name="Attribute_Example_Values">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Example_Values</DataField>
        </Field>
        <Field Name="Attribute_Comment">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Comment</DataField>
        </Field>
        <Field Name="Attribute_Default_Value">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Default_Value</DataField>
        </Field>
        <Field Name="Attribute_ETL_Rules">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_ETL_Rules</DataField>
        </Field>
        <Field Name="Source_system">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Source_System</DataField>
        </Field>
        <Field Name="Attribute_Usage_Tips">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Usage_Tips</DataField>
        </Field>
        <Field Name="Attribute_Steward_Contact">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Steward_Contact</DataField>
        </Field>
        <Field Name="Attribute_Status">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Attribute_Status</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>11.35104in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>