ReportViewer动态调用rdlc报表

可以参考“河北移动排座”  和 “三策监控工位操作” 软件

 

在rdlc报表设计界面，先添加一个新数据源

数据源可以是存储过程，可以是查表

添加完后，用xml编辑器打开看源代码，数据源已经有添加进去了

如下：

 <DataSets>

    <DataSet Name="SanCeDataSet">

      <rd:DataSetInfo>

        <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>

        <rd:DataSetName>SanCeDataSet</rd:DataSetName>

        <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>

        <rd:TableAdapterName>ProduceNoteTableAdapter</rd:TableAdapterName>

        <rd:TableName>ProduceNote</rd:TableName>

      </rd:DataSetInfo>

      <Query>

        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

        <CommandText>SELECT ID, ProduceId, SA1, EA1, SA2, EA2, SA3, EA3, SA4, EA4, SA5, EA5, SA6, EA6, SA7, EA7, SA8, EA8, SA9, EA9, CheckOut, UpdateDateTime FROM dbo.ProduceNote</CommandText>

        <DataSourceName>SanCeConnectionString</DataSourceName>

      </Query>

      <Fields>

        <Field Name="ID">

          <rd:TypeName>System.Int32</rd:TypeName>

          <DataField>ID</DataField>

        </Field>

        <Field Name="ProduceId">

          <rd:TypeName>System.String</rd:TypeName>

          <DataField>ProduceId</DataField>

        </Field>

        <Field Name="SA1">

          <rd:TypeName>System.Double</rd:TypeName>

          <DataField>SA1</DataField>

        </Field&