为SQL报告服务设置参数时出现C＃错误 [英] C# Error when setting parameter for SQL reporting service

问题描述

嗨伙计



我在添加时遇到以下错误

Hi Folks

I am getting following error when adding

reportViewer1.LocalReport.SetParameters(paramz);

AccessViolationException was unhandled<br />
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.<br />

ReportParameter[] paramz = new ReportParameter[3];
                reportViewer1.LocalReport.ReportEmbeddedResource =                  "Reports.ReportInvoice.rdlc";

                paramz[0] = new ReportParameter("paramValueInWord", inWord);
                paramz[1] = new ReportParameter("paramPreviousBalance", previousBalance.ToString());
                paramz[2] = new ReportParameter("paramTodaysReceipt", todaysReceipt.ToString());
                reportViewer1.LocalReport.Refresh();

                reportViewer1.LocalReport.SetParameters(paramz);

                reportViewer1.LocalReport.DataSources.Clear();

                ReportDataSource rds = new ReportDataSource();
                rds.Name = "report_DataSet";
                rds.Value = reportDT;
                reportViewer1.LocalReport.DataSources.Add(rds);
                reportViewer1.RefreshReport();

请帮助



提前谢谢...

Please help

Thanks in advance...

推荐答案

试试这个：

而不是ServerReport

Let try this:
Instead of ServerReport

ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ServerReport serverReport;
serverReport = ReportViewer1.ServerReport;
serverReport.ReportServerUrl = new Uri(ReportServerTextBox.Text);
serverReport.ReportPath = FolderTextBox.Text + ReportNameTextBox.Text;

ReportParameter[] rp = new ReportParameter[1];
rp[0] = new ReportParameter("OrderID", txtOrderID.Text);
ReportViewer1.ServerReport.SetParameters(rp);
ReportViewer1.ServerReport.Refresh();

我已经过测试和工作。

I have tested and worked.

这篇关于为SQL报告服务设置参数时出现C＃错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！