3 object listing .rdl

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

                        <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="textbox1">
                      <rd:DefaultName>textbox1</rd:DefaultName>
                      <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>Purpose</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox19">
                      <ZIndex>6</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <Right>Black</Right>
                        </BorderColor>
                        <BackgroundColor>LightGrey</BackgroundColor>
                        <Color>DarkBlue</Color>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Type</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox20">
                      <ZIndex>5</ZIndex>
                      <Style>
                        <BorderStyle>
                          <Bottom>Solid</Bottom>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <PaddingLeft>2pt</PaddingLeft>
                        <BorderWidth>
                          <Bottom>3pt</Bottom>
                          <Right>1pt</Right>
                        </BorderWidth>
                        <PaddingBottom>2pt</PaddingBottom>
                        <FontWeight>700</FontWeight>
                        <FontSize>14pt</FontSize>
                        <BorderColor>
                          <Bottom>DarkBlue</Bottom>
                          <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>2.5in</Width>
          </TableColumn>
          <TableColumn>
            <Width>3.75in</Width>
          </TableColumn>
          <TableColumn>
            <Width>1.25in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.9375in</Width>
          </TableColumn>
          <TableColumn>
            <Width>0.9375in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.43in</Height>
      </Table>
      <Textbox Name="textbox23">
        <Top>0.35417in</Top>
        <Width>9.375in</Width>
        <Style>
          <BorderStyle>
            <Left>Solid</Left>
            <Right>Solid</Right>
          </BorderStyle>
          <PaddingLeft>2pt</PaddingLeft>
          <BorderWidth>
            <Left>1pt</Left>
            <Right>1pt</Right>
          </BorderWidth>
          <PaddingBottom>2pt</PaddingBottom>
          <FontSize>12pt</FontSize>
          <BorderColor>
            <Left>Black</Left>
            <Right>Black</Right>
          </BorderColor>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
        </Style>
        <CanGrow>true</CanGrow>
        <Height>0.25in</Height>
        <Value>Select an Object below to view the Attributes it contains.</Value>
      </Textbox>
    </ReportItems>
    <Height>2in</Height>
  </Body>
  <rd:ReportID>84df6522-8a00-4faa-a70c-e3944278d531</rd:ReportID>
  <LeftMargin>1in</LeftMargin>
  <DataSets>
    <DataSet Name="ObjectList">
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText>SELECT O.*, CASE WHEN LEN(SAC.Join_Column)&gt;0 THEN 
Object_Display_Name + ' (' + SAC.Join_Column + ')' ELSE Object_Display_Name END As Display_Name from DW_Objects O
JOIN DW_Subject_Area_Contents SAC
	ON SAC.Object_Key = O.Object_Key
WHERE
   SAC.Subject_Area_Key = 1</CommandText>
        <DataSourceName>DW_Metadata_DB</DataSourceName>
      </Query>
      <Fields>
        <Field Name="Object_Key">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Object_Key</DataField>
        </Field>
        <Field Name="Object_ID">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Object_ID</DataField>
        </Field>
        <Field Name="Database_ID">
          <rd:TypeName>System.Int32</rd:TypeName>
          <DataField>Database_ID</DataField>
        </Field>
        <Field Name="Object_Display_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Display_Name</DataField>
        </Field>
        <Field Name="Object_Physical_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Physical_Name</DataField>
        </Field>
        <Field Name="Object_type">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Type</DataField>
        </Field>
        <Field Name="Object_purpose">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Purpose</DataField>
        </Field>
        <Field Name="Object_Short_Descr">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Short_Descr</DataField>
        </Field>
        <Field Name="Object_Long_Descr">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Long_Descr</DataField>
        </Field>
        <Field Name="Object_Usage_Tips">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Usage_Tips</DataField>
        </Field>
        <Field Name="Object_Steward_Contact">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Steward_Contact</DataField>
        </Field>
        <Field Name="Last_refresh_date">
          <rd:TypeName>System.DateTime</rd:TypeName>
          <DataField>Last_refresh_date</DataField>
        </Field>
        <Field Name="Update_Frequency">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Update_Frequency</DataField>
        </Field>
        <Field Name="Object_Status">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Object_Status</DataField>
        </Field>
        <Field Name="Display_Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Display_Name</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>9.5in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>1in</TopMargin>
</Report>