📄 report2.rdlc
字号:
<?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="conString">
<ConnectionProperties>
<ConnectString />
<DataProvider>SQL</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>1530d3ed-26cf-42c1-96ab-e480b88f3012</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="Dep_Name">
<Left>8.5cm</Left>
<Top>1.75cm</Top>
<rd:DefaultName>Dep_Name</rd:DefaultName>
<ZIndex>1</ZIndex>
<Width>2.53968cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>瀹嬩綋</FontFamily>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5cm</Height>
<Value>=First(Fields!Dep_Name.Value)</Value>
</Textbox>
<Textbox Name="ID">
<Left>5.25cm</Left>
<Top>1.75cm</Top>
<rd:DefaultName>ID</rd:DefaultName>
<Width>2.53968cm</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>瀹嬩綋</FontFamily>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.63492cm</Height>
<Value>=Sum(Fields!ID.Value)</Value>
</Textbox>
</ReportItems>
<Height>5cm</Height>
</Body>
<rd:ReportID>10be8dff-cb77-4ac4-bb3c-3a42ce5ba0cf</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet3_Department">
<rd:DataSetInfo>
<rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
<rd:DataSetName>DataSet3</rd:DataSetName>
<rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
<rd:TableAdapterName>DepartmentTableAdapter</rd:TableAdapterName>
<rd:TableName>Department</rd:TableName>
</rd:DataSetInfo>
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT Department.*FROM Department</CommandText>
<DataSourceName>conString</DataSourceName>
</Query>
<Fields>
<Field Name="ID">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>ID</DataField>
</Field>
<Field Name="Dep_Name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Dep_Name</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>zh-CN</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -