且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在用于ReportViewer报表的存储过程中传递参数

更新时间:2023-11-29 21:01:16

1.bind将存储过程从报表数据集中绑定到报表中

2.
在报告中添加与在以下代码中编写的名称相同的报告参数,即
Year_s,Consolidation_cd,product_id

注意:

在您的报表中,参数名称和传递的参数名称必须相同.

3.通过从工具箱中拖放将报表查看器添加到您的.aspx页中
并设置reportviewer属性和属性
例如:
< rsweb:reportviewer runat =服务器" id ="reportviewer1" width ="100%" processingmode =远程" xmlns:rsweb =#unknown">
ShowCredentialPrompts ="false" BackColor ="AliceBlue" ShowParameterPrompts ="false"
ShowBackButton ="false" ShowFindControls ="false" ShowPrintButton ="true"
ShowZoomControl ="false" ShowPageNavigationControls ="true" ShowRefreshButton ="false" Height ="400px">


4.后面的代码

Me.reportviewer1.Visible = True

Me.reportviewer1.ServerReport.ReportServerUrl =新System.Uri("ReportServer url")

而Me.reportviewer1.ServerReport.IsDrillthroughReport
Me.reportviewer1.PerformBack()
结束时

Me.reportviewer1.ServerReport.ReportPath ="/s-s-rsReportprojectname/reportname"

昏暗的parm(2)作为Microsoft.Reporting.WebForms.ReportParameter
parm(0)=新的Microsoft.Reporting.WebForms.ReportParameter("Year_s",列表框选定的值)
parm(1)=新增Microsoft.Reporting.WebForms.ReportParameter("Consolidation_cd",组合框选择的值)
parm(2)=新的Microsoft.Reporting.WebForms.ReportParameter("product_id",列表框选定的值)
Me.reportviewer1.ServerReport.SetParameters(parm)
Me.reportviewer1.ServerReport.Refresh()

我希望它能起作用
1.bind store procedure to your report from dataset of report

2.
Add report parameters in your report with same name which you write in below code ie.
Year_s,Consolidation_cd,product_id

note:

In your report parameter name and passed parameter name must be same.

3.add report viewr to you .aspx page by drag and drop from toolbox
and set reportviewer properties and attributes
ex:
<rsweb:reportviewer runat="server" id="reportviewer1" width="100%" processingmode="Remote" xmlns:rsweb="#unknown">
ShowCredentialPrompts="false" BackColor="AliceBlue" ShowParameterPrompts="false"
ShowBackButton="false" ShowFindControls="false" ShowPrintButton="true"
ShowZoomControl="false" ShowPageNavigationControls="true" ShowRefreshButton="false" Height="400px">


4.code behind

Me.reportviewer1.Visible = True

Me.reportviewer1.ServerReport.ReportServerUrl = New System.Uri("ReportServer url")

While Me.reportviewer1.ServerReport.IsDrillthroughReport
Me.reportviewer1.PerformBack()
End While

Me.reportviewer1.ServerReport.ReportPath = "/s-s-rsReportprojectname/reportname"

Dim parm(2) As Microsoft.Reporting.WebForms.ReportParameter
parm(0) = New Microsoft.Reporting.WebForms.ReportParameter("Year_s", listbox selected value)
parm(1) = New Microsoft.Reporting.WebForms.ReportParameter("Consolidation_cd", combobox selected value)
parm(2) = New Microsoft.Reporting.WebForms.ReportParameter("product_id", listbox selected value)
Me.reportviewer1.ServerReport.SetParameters(parm)
Me.reportviewer1.ServerReport.Refresh()

i hope it will works


相对于

2.
在报表中添加与在以下代码中编写的名称相同的报表参数.
Year_s,Consolidation_cd,product_id


我在哪里以及如何做....

其他一切都很清楚,但不确定如何做到这一点...

谢谢
Reffering to

2.
Add report parameters in your report with same name which you write in below code ie.
Year_s,Consolidation_cd,product_id


where do I do this and how....

Everithing else is clear but not sure how to make this...

Thanks