📄 2 subject area listing .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">
<DataSources>
<DataSource Name="DW_Metadata_DB">
<DataSourceReference>DW_Metadata_DB</DataSourceReference>
<rd:DataSourceID>a1362134-4660-4061-8f72-9561d9f012c1</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="DBID">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>12</Value>
</Values>
</DefaultValue>
<Prompt>DBID</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="DBName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Default</Value>
</Values>
</DefaultValue>
<Prompt>Database Name</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Textbox Name="textbox5">
<Top>0.35417in</Top>
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>2</ZIndex>
<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 a Subject Area Name below to view the Objects it contains.</Value>
</Textbox>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>3pt</Bottom>
<Top>3pt</Top>
<Left>1pt</Left>
<Right>1pt</Right>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>18pt</FontSize>
<BorderColor>
<Bottom>DarkBlue</Bottom>
<Top>DarkBlue</Top>
<Left>Black</Left>
<Right>Black</Right>
</BorderColor>
<BackgroundColor>LightGrey</BackgroundColor>
<Color>DarkBlue</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.33in</Height>
<Value>="Subject Areas in the MDWT_AdventureWorksDW"</Value>
</Textbox>
<Table Name="table1">
<DataSetName>Subject_Areas</DataSetName>
<Top>0.60417in</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Subject_Area_Key">
<rd:DefaultName>Subject_Area_Key</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Subject_Area_Key.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Subject_Area_Name">
<rd:DefaultName>Subject_Area_Name</rd:DefaultName>
<ZIndex>3</ZIndex>
<Action>
<Drillthrough>
<ReportName>3 Object Listing</ReportName>
<Parameters>
<Parameter Name="SubAreaKey">
<Value>=Fields!Subject_Area_Key.Value</Value>
</Parameter>
<Parameter Name="SubAreaName">
<Value>=Fields!Subject_Area_Name.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>12pt</FontSize>
<Color>DarkBlue</Color>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Subject_Area_Name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Subject_Area_Short_Descr">
<rd:DefaultName>Subject_Area_Short_Descr</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Subject_Area_Short_Descr.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>12pt</FontSize>
<Color>MediumBlue</Color>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Image</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Subject_Area_Status">
<rd:DefaultName>Subject_Area_Status</rd:DefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>12pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Subject_Area_Status.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.20087in</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="textbox10">
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -