RDLC报表——动态添加列

最新推荐文章于 2022-08-09 14:55:47 发布
最新推荐文章于 2022-08-09 14:55:47 发布
阅读量621 收藏 1
点赞数
文章标签： 数据库 xhtml
原文链接：http://www.cnblogs.com/pszw/archive/2012/07/19/2599937.html
版权

前言

最近接到一个需求：在给定的数据源中，某（些）列，可能需要单独统计，是否单独统计需要根据报表配置来决定。由于项目中一直使用RDLC来生成报表，临时为了一个需求换一种技术也不是很现实，所以自己捉摸了下。

认识RDLC

RDLC的主要有三个部分：

（1）*.rdlc文件，本质是一个XML文件，这里定义了报表样式；

（2）*.xsd文件，也是一个XML文件，这里定义了数据源格式；

（3）*.aspx文件，呈现报表的web页面。

注：RDLC是什么，可参考蜡人张的博客：http://www.cnblogs.com/waxdoll/archive/2006/02/25/337713.html

 

如何实现动态

（1）LocalReport对象提供了方法LoadReportDefinition（Stream stream）和属性ReportPath保证了我们不仅可以从流中读取文件，也可以指定本地文件路径加载rdlc文件；

（2）.rdlc,.xsd都是xml文件，可使用XmlDocument进行读写操作。

实例

下面实现一个学生成绩统计报表为例，介绍如何实现动态列。

第一步 准备工作

新建空web项目->添加xsd文件，创建一个table（文件名Students.xsd）->添加rdlc文件，与xsd的table关联，并绑定相关字段(文件名FirstRdlc.rdlc)。

Students.xsd设计器视图：

image

对应的xml文件：

  View Source <?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Students" targetNamespace="http://tempuri.org/Students.xsd" xmlns:mstns="http://tempuri.org/Students.xsd" xmlns="http://tempuri.org/Students.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections />
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Students" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Students" msprop:Generator_UserDSName="Students">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dtStudent" msprop:Generator_TableClassName="dtStudentDataTable" msprop:Generator_TableVarName="tabledtStudent" msprop:Generator_TablePropName="dtStudent" msprop:Generator_RowDeletingName="dtStudentRowDeleting" msprop:Generator_UserTableName="dtStudent" msprop:Generator_RowChangingName="dtStudentRowChanging" msprop:Generator_RowEvHandlerName="dtStudentRowChangeEventHandler" msprop:Generator_RowDeletedName="dtStudentRowDeleted" msprop:Generator_RowEvArgName="dtStudentRowChangeEvent" msprop:Generator_RowChangedName="dtStudentRowChanged" msprop:Generator_RowClassName="dtStudentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" type="xs:string" minOccurs="0" />
              <xs:element name="Age" msprop:Generator_ColumnVarNameInTable="columnAge" msprop:Generator_ColumnPropNameInRow="Age" msprop:Generator_ColumnPropNameInTable="AgeColumn" msprop:Generator_UserColumnName="Age" type="xs:string" minOccurs="0" />
              <xs:element name="Scores" msprop:Generator_ColumnVarNameInTable="columnScores" msprop:Generator_ColumnPropNameInRow="Scores" msprop:Generator_ColumnPropNameInTable="ScoresColumn" msprop:Generator_UserColumnName="Scores" type="xs:string" minOccurs="0" />
              <xs:element name="RecId" msprop:Generator_ColumnVarNameInTable="columnRecId" msprop:Generator_ColumnPropNameInRow="RecId" msprop:Generator_ColumnPropNameInTable="RecIdColumn" msprop:Generator_UserColumnName="RecId" type="xs:string" />
              <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="dtStudentKey1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtStudent" />
      <xs:field xpath="mstns:RecId" />
    </xs:unique>
  </xs:element>
</xs:schema>

观察这段xml，会注意这段代码:

 <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class" type="xs:string" minOccurs="0" />

这句代码定义了报表数据源的“Class”这列。可想而知，我们如果动态添加一列，这里势必应该要修改。

FirstRdlc.rdlc文件设计器视图：

image

对应的xml文件如下：

  View Source <?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
  <DataSources>
    <DataSource Name="Students">
      <ConnectionProperties>
        <DataProvider>System.Data.DataSet</DataProvider>
        <ConnectString>/* Local Connection */</ConnectString>
      </ConnectionProperties>
      <rd:DataSourceID>9a61684e-8669-405d-b9ef-dc43279c6ff0</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="dsStudent">
      <Fields>
        <Field Name="Name">
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Age">
          <DataField>Age</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Scores">
          <DataField>Scores</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="RecId">
          <DataField>RecId</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Class">
          <DataField>Class</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>Students</DataSourceName>
        <CommandText>/* Local Query */</CommandText>
      </Query>
      <rd:DataSetInfo>
        <rd:DataSetName>Students</rd:DataSetName>
        <rd:SchemaPath>E:\Demo\HelloRDLC\HelloRDLC\Students.xsd</rd:SchemaPath>
        <rd:TableName>dtStudent</rd:TableName>
        <rd:TableAdapterFillMethod />
        <rd:TableAdapterGetDataMethod />
        <rd:TableAdapterName />
      </rd:DataSetInfo>
    </DataSet>
  </DataSets>
  <Body>
    <ReportItems>
      <Tablix Name="Tablix5">
        <TablixBody>
          <TablixColumns>
            <TablixColumn>
              <Width>0.98425in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>0.98425in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>0.98425in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>0.98425in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>0.98425in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.23622in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox25">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>序号</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox25</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox27">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>姓名</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox27</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox29">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>年龄</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox29</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox32">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>班级</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox32</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox34">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>得分</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox34</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.23622in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="RecId">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!RecId.Value</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>RecId</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Name">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!Name.Value</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Name</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Age">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!Age.Value</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Age</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Class">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!Class.Value</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Class</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Scores">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!Scores.Value</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Scores</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
          </TablixMembers>
        </TablixColumnHierarchy>
        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <Group Name="详细信息" />
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>dsStudent</DataSetName>
        <Top>0.52035cm</Top>
        <Left>0.47625cm</Left>
        <Height>1.2cm</Height>
        <Width>12.49997cm</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Tablix>
    </ReportItems>
    <Height>2.96875in</Height>
    <Style />
  </Body>
  <Width>6.5in</Width>
  <Page>
    <PageHeader>
      <Height>1.34938cm</Height>
      <PrintOnFirstPage>true</PrintOnFirstPage>
      <PrintOnLastPage>true</PrintOnLastPage>
      <ReportItems>
        <Textbox Name="txtHeader">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>学生成绩统计报表</Value>
                  <Style />
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Center</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <Top>0.65299cm</Top>
          <Height>0.6cm</Height>
          <Width>16.51cm</Width>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
            <VerticalAlign>Middle</VerticalAlign>
            <PaddingLeft>2pt</PaddingLeft>
            <PaddingRight>2pt</PaddingRight>
            <PaddingTop>2pt</PaddingTop>
            <PaddingBottom>2pt</PaddingBottom>
          </Style>
        </Textbox>
      </ReportItems>
      <Style>
        <Border>
          <Style>None</Style>
        </Border>
      </Style>
    </PageHeader>
    <PageFooter>
      <Height>1.7507cm</Height>
      <PrintOnFirstPage>true</PrintOnFirstPage>
      <PrintOnLastPage>true</PrintOnLastPage>
      <ReportItems>
        <Textbox Name="txtFooter">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>Copy Right 2001-2012 infosky R&amp;D</Value>
                  <Style />
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Right</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <Top>1.04069cm</Top>
          <Height>0.71cm</Height>
          <Width>16.51cm</Width>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
            <PaddingLeft>2pt</PaddingLeft>
            <PaddingRight>2pt</PaddingRight>
            <PaddingTop>2pt</PaddingTop>
            <PaddingBottom>2pt</PaddingBottom>
          </Style>
        </Textbox>
      </ReportItems>
      <Style>
        <Border>
          <Style>None</Style>
        </Border>
      </Style>
    </PageFooter>
    <PageHeight>29.7cm</PageHeight>
    <PageWidth>21cm</PageWidth>
    <LeftMargin>2cm</LeftMargin>
    <RightMargin>2cm</RightMargin>
    <TopMargin>2cm</TopMargin>
    <BottomMargin>2cm</BottomMargin>
    <ColumnSpacing>0.13cm</ColumnSpacing>
    <Style />
  </Page>
  <rd:ReportID>7d9ab7b5-369c-4d46-86a6-b8723598c7cd</rd:ReportID>
  <rd:ReportUnitType>Cm</rd:ReportUnitType>
</Report>

仔细观察这段xml文件，不难看出有几部分代码是值得关注的：

（1）路径Report/DataSets/DataSet/Fields下得Field节点，这里定义的是同数据源相关的列；

  View Source         <Field Name="Name">
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>

（2）路径Report/DataSets/DataSet/rd:DataSetInfo节点，这里定义了rdlc关联的xsd文件的路径；

  View Source   <rd:DataSetInfo>
        <rd:DataSetName>Students</rd:DataSetName>
        <rd:SchemaPath>E:\Demo\HelloRDLC\HelloRDLC\Students.xsd</rd:SchemaPath>
        <rd:TableName>dtStudent</rd:TableName>
        <rd:TableAdapterFillMethod />
        <rd:TableAdapterGetDataMethod />
        <rd:TableAdapterName />
      </rd:DataSetInfo>

（3）路径Report/Body/ReportItems/Tablix/TablixBody/TablixColumns下的TablixColumn节点，这里应该定义了RDLC报表的列数

  View Source <TablixColumn>
              <Width>0.98425in</Width>
            </TablixColumn>

（4）路径Report/Body/ReportItems/Tablix/TablixBody/TablixRows下的TablixRow。从名称可知是报表行相关内容，其中每个TablixRow，又定义了单元格信息（在TablixCells下的TablixCell节点）。这里默认情况下有两行，第一行定义了报表列头显示内容，如：姓名，性别等，第二行定义了报表数据的绑定项。如：姓名绑定到xsd的Name字段。这里便有：<Value>=Fields!Name.Value</Value>

  View Source <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox27">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>姓名</Value>
                              <Style />
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox27</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>

所以，这以上几处在我们修改xml时，势必可能需要修改。其实，这里还有一处需要修改，路径：Report/Body/ReportItems/Tablix/TablixColumnHierarchy/TablixMembers下的TablixMember，该节点个数一定要和报表列数相同。否则编译便会报错。

第二步：操作XML，动态添加列(GPA列)

（1）操作XML文件使用XmlDocument类，需要添加节点时，可以使用XmlNode.CloneNode(bool)方法。

  View Source             //添加Field节点
            XmlNodeList fileds = xmlDoc.GetElementsByTagName("Fields");

            XmlNode filedNode = fileds.Item(0).FirstChild.CloneNode(true);
            filedNode.Attributes["Name"].Value = "GPA";
            filedNode.FirstChild.InnerText = "GPA";
            fileds.Item(0).AppendChild(filedNode);

（2）操作xsd文件，将需要添加的列，加入到xsd中，并保存指定路径（保存文件命名为Student1.xsd）；

  View Source         private void ModifyXSD()
        {
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "Students.xsd");

            XmlNodeList nodeList = xmlDoc.GetElementsByTagName("xs:sequence");
            XmlNode node = nodeList.Item(0).FirstChild.CloneNode(true);
            node.Attributes["name"].Value = "GPA";
            node.Attributes["msprop:Generator_ColumnVarNameInTable"].Value = "columnGPA";
            node.Attributes["msprop:Generator_ColumnPropNameInRow"].Value = "GPA";
            node.Attributes["msprop:Generator_ColumnPropNameInTable"].Value = "GPAColumn";
            node.Attributes["msprop:Generator_UserColumnName"].Value = "GPA";
            nodeList.Item(0).AppendChild(node);

            xmlDoc.Save(AppDomain.CurrentDomain.BaseDirectory + "Students1.xsd");
        }

（2）修改rdlc文件，包括，待添加列、xsd文件路径等，中（或保存为rdlc文件）；

View Code 
 1         /// <summary>
 2         /// 修改RDLC文件
 3         /// </summary>
 4         /// <returns></returns>
 5         private XmlDocument ModifyRdlc()
 6         {
 7             XmlDocument xmlDoc = new XmlDocument();
 8 
 9             xmlDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "FirstRdlc.rdlc");
10 
11             //添加Field节点
12             XmlNodeList fileds = xmlDoc.GetElementsByTagName("Fields");
13 
14             XmlNode filedNode = fileds.Item(0).FirstChild.CloneNode(true);
15             filedNode.Attributes["Name"].Value = "GPA";
16             filedNode.FirstChild.InnerText = "GPA";
17             fileds.Item(0).AppendChild(filedNode);
18 
19             //添加TablixColumn
20 
21             XmlNodeList tablixColumns = xmlDoc.GetElementsByTagName("TablixColumns");
22             XmlNode tablixColumn = tablixColumns.Item(0).FirstChild;
23             XmlNode newtablixColumn = tablixColumn.CloneNode(true);
24             tablixColumns.Item(0).AppendChild(newtablixColumn);
25 
26             //TablixMember
27             XmlNodeList tablixMembers = xmlDoc.GetElementsByTagName("TablixColumnHierarchy");
28 
29             XmlNode tablixMember = tablixMembers.Item(0).FirstChild.FirstChild;
30             XmlNode newTablixMember = tablixMember.CloneNode(true);
31             tablixMembers.Item(0).FirstChild.AppendChild(newTablixMember);
32 
33             XmlNodeList tablixRows = xmlDoc.GetElementsByTagName("TablixRows");
34 
35             //TablixRows1
36             var tablixRowsRowCells1 = tablixRows.Item(0).FirstChild.ChildNodes[1];
37             XmlNode tablixRowCell1 = tablixRowsRowCells1.FirstChild;
38             XmlNode newtablixRowCell1 = tablixRowCell1.CloneNode(true);
39             var textBox1 = newtablixRowCell1.FirstChild.ChildNodes[0];
40             textBox1.Attributes["Name"].Value = "GPA1";
41 
42             var paragraphs = textBox1.ChildNodes.Cast<XmlNode>().Where(item => item.Name == "Paragraphs").FirstOrDefault();
43             paragraphs.FirstChild.FirstChild.FirstChild.FirstChild.InnerText = "GPA";
44             var defaultName1 = textBox1.ChildNodes.Cast<XmlNode>().Where(item => item.Name == "rd:DefaultName").FirstOrDefault().InnerText = "GPA1";
45 
46             tablixRowsRowCells1.AppendChild(newtablixRowCell1);
47 
48             //TablixRows2
49             var tablixRowsRowCells2 = tablixRows.Item(0).ChildNodes[1].ChildNodes[1];
50             XmlNode tablixRowCell2 = tablixRowsRowCells2.FirstChild;
51             XmlNode newtablixRowCell2 = tablixRowCell2.CloneNode(true);
52             var textBox2 = newtablixRowCell2.FirstChild.ChildNodes[0];
53             textBox2.Attributes["Name"].Value = "GPA";
54 
55             var paragraphs2 = textBox2.ChildNodes.Cast<XmlNode>().Where(item => item.Name == "Paragraphs").FirstOrDefault();
56             paragraphs2.FirstChild.FirstChild.FirstChild.FirstChild.InnerText = "=Fields!GPA.Value";
57             var defaultName2 = textBox2.ChildNodes.Cast<XmlNode>().Where(item => item.Name == "rd:DefaultName").FirstOrDefault().InnerText = "GPA";
58 
59             tablixRowsRowCells2.AppendChild(newtablixRowCell2);
60 
61             xmlDoc.Save(AppDomain.CurrentDomain.BaseDirectory + "FirstRdlc1.rdlc");
62             return xmlDoc;
63         }

 （3）将得到的XmlDocument实例，序列化到MemoryStream。

 1         /// <summary>
 2         /// 序列化到内存流
 3         /// </summary>
 4         /// <returns></returns>
 5         private Stream GetRdlcStream(XmlDocument xmlDoc)
 6         {
 7             Stream ms = new MemoryStream();
 8             XmlSerializer serializer = new XmlSerializer(typeof(XmlDocument));
 9             serializer.Serialize(ms, xmlDoc);
10 
11             ms.Position = 0;
12             return ms;
13         }

 

第三步：加载报表，并显示

（1）添加一个Page页面，并添加ReportView控件和ScriptManager控件，页面代码如下：

  View Source <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <rsweb:ReportViewer ID="rvDemo" runat="server" Width="100%">
    </rsweb:ReportViewer>
        <asp:ScriptManager ID="smDemo" runat="server">
        </asp:ScriptManager>
    </div>
    </form>
</body>
</html>

（2）加载报表定义，并绑定数据源（使用LoadReportDefinition（Stream stream）方法加载MemoryStream中信息）

View Code 
 1         /// <summary>
 2         /// 加载报表
 3         /// </summary>
 4         private void LoadReport()
 5         {
 6             //获取数据源
 7             DataTable dataSource = GetDataSource();
 8 
 9             //修改xsd文件
10             ModifyXSD();
11 
12             //修改rdlc文件
13             XmlDocument xmlDoc = ModifyRdlc();
14 
15             //将修改后的rdlc文档序列化到内存流中
16             Stream stream = GetRdlcStream(xmlDoc);
17 
18             //加载报表定义
19             rvDemo.LocalReport.LoadReportDefinition(stream);
20             //rvDemo.LocalReport.ReportPath = "FirstRdlc.rdlc";
21 
22             //添加数据源，rvDemo是页面上的ReportView控件
23             rvDemo.LocalReport.DataSources.Add(new ReportDataSource("dsStudent", dt));
24             rvDemo.LocalReport.Refresh();
25         }
26 
27         /// <summary>
28         /// 获取数据源
29         /// </summary>
30         /// <returns></returns>
31         private DataTable GetDataSource()
32         {            
33             //伪造一个数据源
34             DataTable dt = new DataTable();
35             dt.Columns.AddRange(new DataColumn[] 
36                 { 
37                     new DataColumn() { ColumnName = "RecId" }, 
38                     new DataColumn() { ColumnName = "Name" }, 
39                     new DataColumn() { ColumnName = "Age" }, 
40                     new DataColumn() { ColumnName = "Class" }, 
41                     new DataColumn() { ColumnName = "Scores" },
42                     new DataColumn() { ColumnName = "GPA" }
43                 });
44 
45             DataRow dr = dt.NewRow();
46             dr["RecId"] = "1";
47             dr["Name"] = "小明";
48             dr["Age"] = "26";
49             dr["Class"] = "1年级";
50             dr["Scores"] = "90";
51             dr["GPA"] = "4.0";
52 
53             dt.Rows.Add(dr);
54             return dt;
55         }

如此，我们便可以动态的添加GPA这列到报表上了，结果如下：

image

 

源码地址：HelloRdlc.7z

转载于:https://www.cnblogs.com/pszw/archive/2012/07/19/2599937.html

lceBear
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
C#代码加载RDLC文件报表且是否显示指定行或列内容
05-26
这是一个关于使用C#开发的.NET Framework 4框架的RDLC文件报表WinForm项目工程，包含了一个完整的实现例子，可以作为参考学习使用，该项目工程实现的功能如下： ①创建人员信息模型； ②创建人员信息内容； ③创建人员信息报表模板； ④获取报表模板所需的人员信息； ⑤加载报表模板且填充报表数据； ⑥可以根据条件显示或隐藏指定的报表行、列内容；
RDLC 动态列
luochengbang的专栏
08-14 4384
很久没有写博客了，关于动态列，国内很少资料有介绍动态列的，所想写点心得给哥们 啥是动态列呢？通常我们用存储过程时有列转行和行转列的做法，那么在RDLC 怎么支持呢？其实很简单，就是利用了RDLC的 Column Groups 先看看源数据： 序号 姓名 科目 分数 1 张三 语文 80 2 张三 数学 90 3 张三 物
动态RDLC报表（六）
xgh815的专栏
08-09 843
在前面已经人寿了一个空的报表文档，各种节点的数据也已经生成，现在只需把各种节点的数据放进报表文档里，然后加载到ReportViewer中就可以了。显示报表之前要先传入一个ReportViewer。动态RDLC报表完整实例下载。可以选择是否直接打印出来。生成RDLC报表并显示。动态RDLC报表（一）动态RDLC报表（二）动态RDLC报表（三）动态RDLC报表（四）动态RDLC报表（五）动态RDLC报表（六）动态RDLC报表（七）......
rdlc报表使用详细方法
tjc076336的专栏
01-11 1459
使用RDLC报表(一)   1       建立数据源启动VS2005新建一个窗体项目，命名为TestProj  在左边的窗体内选择“添加新数据源”或在菜单上操作“添加新数据源”：  选择后出现对话窗体，选择“数据库”，进入“下一步”：  本数据源以SqlServer2000所提供的Northwind数据库为例，因此在数据库内选择驱动程序为SqlServer，具
动态RDLC报表完整实例和代码
最新发布
08-09
在没有rdlc为后缀的报表文件和没有xsd为后缀的DataSet数据源的情况下，依据从数据库中获取的数据生成RDLC报表。 Visual Studio 的最新版本是2022，在以住的版本中微软都会有一个 Microsoft RDLC Report Designer ...
C# 动态生成RDLC报表
10-06
为了在运行时动态控制报表的列，我们需要在C#代码中处理用户输入，例如，根据用户选择的字段动态生成报表列。这可能涉及到事件处理、控件交互以及数据绑定。例如，用户可能会通过一个下拉列表选择要显示的字段，我们...
RDLC报表部署——查找相关dll文件
03-12
.net 开发的程序如用到rdlc 报表，在部署到客户电脑上时经常会出现错误，...1、文本文件，RDLC报表部署——查找相关dll文件 2、RDLC报表部署所需dll文件，包含10.0版本下Microsoft.ReportViewer.Common.dll等9个文件
VS2010的RDLC报表使用教程
10-02
RDLC报表可以动态地从数据库或其他数据源检索数据，并以各种格式显示，如表格、图表、图像等。 1. **创建RDLC报表** - 打开Visual Studio 2010，创建一个新的Windows Forms或ASP.NET项目。 - 在解决方案资源管理...
水晶报表（rdlc报表）常用小技巧整理
06-08
1、RDLC报表表格中添加序号，调用表达式RowNumber( Nothing ) 2、RDLC报表，表格分组后添加序号，分两种情况 第一种情况，在分组内添加从1开始的序号，每个分组内都是从1开始计数。 在报表属性-》代码中添加如下...
RDLC 绑定动态列 源码
06-01
RDLC 绑定动态列 源码 中文说明文档和代码, 简单明了好资料
RDLC报表通过后台代码动态生成
07-30
RDLC报表通过后台代码动态生成 表头合并，数据操作，换行！
代码加载RDLC文件报表时是否显示指定行或列内容
CoffeMilk的博客
05-26 570
一、实现效果 1.1、业务需求 在使用C#代码加载RDLC文件报表时根据条件设置显示或隐藏指定的行或列内容。 1.2、业务实现效果 C#代码加载RDLC文件报表且是否显示指定行或列内容项目工程https://download.csdn.net/download/xiaochenXIHUA/85465245大概的实现效果如下图所示： 二、实现方法 2.1、添加显示或隐藏的参数 打开RDLC文件报表然后在报表数据中添加参数：比如我这里想添加的参数为：IsShowParaRow、IsSh..
C#的rdlc报表分组汇总学习
xinxin_2011的博客
04-24 6247
介绍 最近项目中要用到报表的分组显示，觉得rdlc报表功能比较强大，就尝试用它来实现一下。实现方式也是有很多种，下面一一介绍。 创建分组后的数据库表 自己计算相对麻烦些，可以在数据库先创建一张表每班汇总信息（EveryTotalInfo），然后创建一个与该表对应的数据集xxx.xsd文件，在数据集中添加该表需要展示的哪些字段（注意字段类型必须与数据库中的一致）： 下面的适配器中添加一个带时间参数...
C#中实现动态隐藏/显示RDLC报表的表头（列）
duskvalley的专栏
08-04 4257
1.设计好RDLC报表（.rdlc文件），包含所有可能要选择的列。 2.在.rdlc文件中创建参数，如图 3.设置列的可见性，如图 4.在相应的代码中传递显示/隐藏参数，代码： ReportParameter rp; if (checkBox_cehao.Checked) rp = new R
rdlc报表动态生成实例
星火燎猿
04-15 7131
using System; using System.Collections; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.
RDLC使用手册，推荐学习
08-30
技巧部分将介绍一些常见问题和解决方法，比如如何处理大量数据、如何设计动态报表、如何优化报表性能等。 总体而言，这本RDLC使用手册是一个非常实用和全面的学习工具。它不仅涵盖了RDLC报表的基本知识和使用方法，...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值