Asp.netReportViewer为RDLC报表传递参数

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

我的report 用到三个数据源，首先添加网站数据源

DataSet1_SDA_PROJECT_MEMBER
DataSet1_SDA_PROJECT_TARGET
DataSet1_SDA_SIGN_HISTORY

为report添加报表参数

把建立的网站数据源添加到报表数据源，同时在报表数据源－属性－过滤添加报表参数过滤条件

在网页上添加ReportViewer 控件，指定到report即可

在网页内部添加代码为ReportViewer 添加数据源及报表参数

Me.ReportViewer2.LocalReport.DataSources.Clear()
Dim Myyear As New ReportParameter
Myyear.Name = ReportViewer2.LocalReport.GetParameters.Item(0).Name
Myyear.Values.Add("S00009")
ReportViewer2.LocalReport.SetParameters(New ReportParameter() {Myyear})
Dim RP2_DateSourceMem As New ReportDataSource("DataSet1_SDA_PROJECT_MEMBER", DataSet1.Tables(0))
Dim RP2_DateSourceTAR As New ReportDataSource("DataSet1_SDA_PROJECT_TARGET", DataSet2.Tables(0))
Dim RP2_DateSourceSig As New ReportDataSource("DataSet1_SDA_SIGN_HISTORY", DataSet3.Tables(0))
ReportViewer2.LocalReport.DataSources.Clear()
ReportViewer2.LocalReport.DataSources.Add(RP2_DateSourceMem)
ReportViewer2.LocalReport.DataSources.Add(RP2_DateSourceTAR)
ReportViewer2.LocalReport.DataSources.Add(RP2_DateSourceSig)
ReportViewer2.LocalReport.Refresh()